Databases and DBMS Courses

This course teaches you how to use Oracle Data Guard. Expert Oracle University instructors will demonstrate how this solution protects your Oracle database against planned and unplanned downtimes.

This Oracle Database: Managing Multitenant Architecture course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database and its regular and application pluggable databases. You learn why and how to create and manage a multitenant container database and its regular and application pluggable databases, with storage structures appropriate for the business applications. You will practice cold and hot cloning, plugging unplugged pluggable databases in multitenant container databases using various methods. In addition, you learn how to create common and local users and administer database security to meet your business requirements by using encryption, Database Vault and auditing and you will learn how to create a database deployment in the Cloud.

This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

This credential earner has completed instructor-led learning for understanding how to plan, implement and maintain Db2 11.1 databases. Topics covered include: Advanced Monitoring; Db2 Table Space Management; Db2 Database Memory Management; Database rebuild support; Db2 database and tablespace relocation; and Db2 Incremental Backup.

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively.