GaussDB General Knowledge Courses Learning Path

This course covers the GaussDB system architectures (primary/standby and distributed), high availability deployment solutions, core O&M capabilities, and security measures. It also explains how SQL engines and storage engines work.

This course introduces the GaussDB database scaling principles, performance metrics, specifications constraints, and precautions and also describes how to scale a GaussDB database step by step.

This course covers how to upgrade GaussDB, the principles involved, various upgrade features, and how to locate faults.

This course is about backup and recovery. It covers GaussDB backup types, backup processes, and how to perform backups and recovery with the GaussDB management platform (TPOPS).

This course introduces GaussDB alarm monitoring, including the alarm monitoring platform, monitored metrics, configuration and handling suggestions of custom alarms, and troubleshooting methods for typical alarms.

This course covers how to install database instances and troubleshoot common installation issues using the GaussDB management platform (TPOPS).

This course covers the architecture of the GaussDB management platform (TPOPS) and its functions, such as instance management, instance upgrade, instance scaling, performance monitoring, and alarming.

This course is about backup and recovery. It covers GaussDB backup types, backup processes, and how to perform backups and recovery with the GaussDB management platform (TPOPS).

This course mainly introduces three GaussDB development tools: Navicat, gsql, and TPDSS.

This course covers GaussDB database objects. Database objects are a series of data structures used by databases to store, manage, and query data. GaussDB database objects include databases, schemas, tablespaces, users, views, tables, indexes, sequences, and more.

This course mainly introduces the best practices and specifications of database development, covering database design, table structure design, SQL writing, stored procedures, etc.

This course describes how to use GaussDB's JDBC and ODBC drivers for application development, how to set driver parameters, and how to handle common problems.

This course covers basic principles and tools for GaussDB (centralized and distributed) SQL tuning and provides use cases to illustrate tuning methods.

This course covers basic knowledge and processes of GaussDB system tuning and describes performance diagnosis and WDR analysis.

This course describes the tools for importing and exporting GaussDB data, including gsql, gs_dump, gs_restore, gs_loader, GDS, and COPY syntax. You can use them in various scenarios.

This course introduces data dictionaries of GaussDB. A data dictionary stores information about a database system and all the objects in the database. It is the foundation of a database system and describes how a database is operated and managed. A GaussDB data dictionary includes system catalogs and system views.

This course introduces the overall security architecture and security design principles of GaussDB, including login control, access control, data protection, audit tracking, and data display.

This course explains the compatibility and syntax differences between GaussDB and Oracle and provides basic methods and principles for migrating data objects.

This course introduces the overall database migration solution and the working principles, features, and usage of UGO.

This course describes how DRS works and provides FAQs, troubleshooting methods, and the best practice of migrating Oracle databases to GaussDB.

This course describes how to migrate applications and data from Oracle to GaussDB. After completing this course, you will be able to understand the data migration process. 1. UGO Operation Demonstration 2. DRS Operation Demonstration