Complete Guide to Oracle Database 23ai: From Beginner to Advanced

As open-source technology becomes more standard, this course highlights the importance of robust, mature, and fully-supported relational database systems. Join instructor Kellyn Gorman as she guides you on your journey toward becoming a proficient database administrator, covering the robust features, innovative enhancements, and powerful capabilities of Oracle 23ai. Kellyn helps equip you with the comprehensive knowledge and skills required to effectively manage Oracle Database systems, the most widely used in enterprise environments, and to manage much of the most critical business data. By delving into Oracle's intricacies, you’ll gain a deep understanding of how to design, implement, and maintain robust and high-performing database systems, making them indispensable assets to organizations that rely on Oracle technology.

Learning objectives
Oracle Administration
Basic terminology
Database management
Installation
Upgrading and patching
Backup and Recovery
Oracle architecture
Tiered architecture
Oracle memory allocation and background processes
Physical and logical file layout
Oracle software and directory structures
Multi-tenancy
Why Multi tenant
Multi Tenancy architecture
Separation between container and pluggable databases
Connecting to and switching and logging into CDBs/PDBs
Managing pluggable databases (PDBs)
SQL and PL/SQL
Database query language
SQL basics
DML vs. DDL
PL/SQL specifics
procedural languages
Misc. language details
Security
Protecting the data
Roles and privileges
Users, SSO and authentication
Encryption
Data masking and obfuscation
data in flight vs. data at rest
Performance
Physical vs. logical optimization
The Oracle optimizer
Indexing and partitioning
SQL tuning
Statistics and metrics
Oracle performance data and tools