Linkedin Learning – Complete Guide to Oracle Database 23ai: From Beginner to Advanced
English | Tutorial | Size: 660.57 MB
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
RAPIDGATOR:
rapidgator.net/file/c108d412433a251a9ddc18a6ab7b2ca0/LinkedIn_Learning_-_Complete_Guide_to_Oracle_Database_23ai_-_From_Beginner_to_Advanced.rar.html