From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
Further learning with Oracle 23ai - Oracle Database Tutorial
From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced
Further learning with Oracle 23ai
- Congratulations, you've made it to the end of the entire Oracle 23c course. And you've completed the Capstone. I want to thank you for spending the time with me on this journey, discovering all that Oracle 23c has to offer as a database professional. This course emphasized the value of Oracle 23c in the organizations to maximize the value of data while ensuring it's always available, accessible, and secure. Included as part of this course is a PDF with additional resources to continue your journey. After two decades in the industry, I can attest that you never stop learning. And these resources will help you pursue your technical dreams. I'll ask that you find ways to bring what you've learned from this course into your organization. Modernize the archaic, and use the newest features from Oracle to achieve more tomorrow.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
Schema objects: All about tables2m 43s
-
(Locked)
Indexing in Oracle 23ai4m 4s
-
(Locked)
Views, object views, JSON views, and materialized views2m 50s
-
(Locked)
Segment partitioning2m 18s
-
(Locked)
The data dictionary and dynamic performance views3m 20s
-
(Locked)
Final project countdown: Schema objects recap40s
-
-
-
What is an Oracle instance?4m 8s
-
(Locked)
Container database (CDB)2m 40s
-
(Locked)
Pluggable databases (PDBs)3m 6s
-
(Locked)
Oracle Real Application Clusters (RAC)4m 21s
-
(Locked)
Oracle Data Guard3m 24s
-
(Locked)
Sharding architecture4m 35s
-
(Locked)
Oracle Net Services and application architecture4m 19s
-
(Locked)
Final project countdown: Instance vs. container database recap38s
-
-
-
Role of a database administrator4m 28s
-
(Locked)
Overview of maximum availability architecture3m 32s
-
(Locked)
Understanding Oracle high availability4m 21s
-
(Locked)
Disaster recovery options5m
-
(Locked)
Backing up and recovering using RMAN3m 46s
-
(Locked)
Final project countdown: Database administration recap30s
-
-
-
Introduction to performance optimization2m 35s
-
(Locked)
Instance tuning5m 10s
-
(Locked)
Understanding the AWR report4m 9s
-
(Locked)
ASH, ADDM, and the rest of AWR3m 46s
-
(Locked)
SQL tuning5m 49s
-
(Locked)
SQL tracing3m 16s
-
(Locked)
Cost-based optimizer5m 5s
-
(Locked)
Performing an optimization exercise4m 26s
-
(Locked)
Final project countdown: Optimizing performance recap36s
-
-
-
(Locked)
Assignment: Starting and stopping databases55s
-
(Locked)
Walkthrough: Starting and stopping databases4m 50s
-
(Locked)
Assignment: Configuring and managing space1m 8s
-
(Locked)
Walkthrough: Configuring and managing space4m 23s
-
(Locked)
Assignment: User management1m 28s
-
(Locked)
Walkthrough: User management6m 6s
-
(Locked)
-
-
(Locked)
Assignment: Create a sales summary schema owner user1m 15s
-
(Locked)
Walkthrough: Create a sales summary schema owner user6m 56s
-
(Locked)
Assignment: Create reporting data2m 13s
-
(Locked)
Walkthrough: Create reporting data8m 53s
-
(Locked)
Assignment: Manipulate data2m 58s
-
(Locked)
Walkthrough: Manipulate data10m 32s
-
(Locked)