TƏLİMLƏR

ONLAYN -20 GÜZƏŞT
Oracle

Oracle Database Administration

4 ay / 64 saat 250 m

Oracle Database: Introduction to SQL
1. Introduction to Relational Databases
- The need for an SQL standard
- The ANSI standards
- What is a database?
- What is a relational database?
- Components of a relational database
- Normalised data
- Anatomy of a table
- Primary and foreign keys
- Joins
- Components of SQL

2. Data Manipulation Language
- SELECT operations
- DISTINCT
- Virtual columns
- Column aliases
- Functions
- Restricting the rows returned
- Multiple conditions
- Ordering data
- Inserting rows
- Updating rows
- Deleting rows

3. Joining tables
- The theory of joining tables
- Cross, Inner, Outer, Full, Left and Right
- Composite joins
- Table aliases

4. Data Definition Language
- Data types
- Column attributes
- Create table
- Primary and foreign keys
- Referential integrity
- Alter and drop tables

5. Views
- Defining simple views
- Views with virtual columns
- Restricted-column views
- Joined-table views
- Restricted-row views
- View restrictions

6. Summarised Queries
- Table aggregates
- GROUP BY and aggregates
- The HAVING clause

7. Subqueries
- Using simple Subqueries
- EXISTS
- Correlated Subqueries

8. Set operations
- Union
- Intersect
- Except/Minus


Oracle Database: Administration Workshop Ed 1

1. Introduction
- Oracle Database Editions, Options, and Management Packs
- Oracle Cloud Overview
- Sample HR Schema

2. Oracle Database Architecture
- Oracle Database Server Architecture
- Oracle Database Instance Configurations
- Connecting to the Database Instance
- Oracle Database Memory and Process Structures
- Logical and Physical Database Structures
- Multitenant Architecture
- Automatic Storage Management (ASM) Overview

3. Introdction to Oracle Database Cloud
- Oracle Database Cloud Service Architecture
- Features and Tooling
- Automated Database Provisioning

4. Creating Oracle Database Cloud Service (DBCS) Deployments
- Input to the Creation Wizard
- SSH Key Pairs
- Database File Storage

5. Accessing an Oracle Database
- SQL*Plus
- SQL Developer
- Database Configuration Assistant (DBCA)
- Oracle enterprise Manager Database Express
- Oracle Enterprise Manager Cloud Control
- Oracle Database Cloud Service Tools

6. Managing DBCS Database Deployments
- Managing the Compute Node
- Managing Network Access to DBCS
- Scaling a Database Deployment
- Patching a Database Deployment

7. Managing Database Instances
- Initialization Parameter Files
- Starting Up Oracle Database Instances
- Shutting Down Oracle Database Instances
- Automatic Diagnostic Repository (ADR)
- Alert Log and Trace Files
- Dynamic Performance Views
- Data Dictionary Views

8. Oracle Net Services
- Oracle Net Listener Overview
- Connecting to an Oracle Database Instance
- Naming Methods
- Oracle Net Services Administration Tools
- Configuring Communication Between Database Instances
- Comparing Dedicated and Shared Server Configurations

9. Administering User Security
- Managing Oracle Cloud Users, Privileges, and Roles
- Managing Oracle Database Users, Privileges, and Roles
- User Authentication
- Creating and Assigning Profiles
- Assigning Quotas to Users
- Applying the Principal of Least Privilege

10. Creating PDBs
- Methods and Tools to Create PDBs
- Creating PDBs from Seed
- Cloning PDBs
- Unplugging and Plugging in PDBs
- Dropping PDBs

11. Creating Master Encryption Keys for PDBs
- Encryption in Oracle Database Cloud Service
- Overview of Transparent Data Encryption (TDE)
- CDB and PDB Master Encryption Keys
- Creating and Activating an Encryption Key

12. Creating and Managing Tablespaces
- Table Data Storage
- Creating, Altering and Dropping Tablespaces
- Viewing Tablespace Information
- Implementing Oracle Managed Files
- Moving and Renaming Online Data Files
- Tablespace Encryption by Default in DBCS

13. Managing Storage Space
- Oracle Database Space Management Features
- Block Space Management
- Types of Segments
- Deferred Segment Creation
- Space-Saving Features
- Table and Row Compression
- Shrinkable Segments
- Resumable Space Allocation

14. Managing Undo Data
- Transactions and Undo Data
- Storing Undo Information
- Comparing Undo Data and Redo Data
- Comparing Local Undo Mode and Shared Undo Mode
- Configuring Undo Rentention
- Temporary Undo

15. Moving Data
- Oracle Data Pump
- SQL*Loader
- External Tables
- Migrating to Oracle Database Cloud Service

16. Backup and Recovery Concepts
- Categories of Failure
- Instance Recovery
- Complete Recovery
- Point-in-time Recovery
- Flashback Technology

17. Backup and Recovery Configuration
- Configuring and Monitoring the Fast Recovery Area
- Multiplexing Control Files
- Multiplexing Redo Log Files
- Archive Redo Log Files
- Configuring ARCHIVELOG Mode

18. Creating Database Backups
- Backup Terminology
- Using Recovery Manager (RMAN)
- RMAN Backup Types
- Automatic Backups on Database Cloud Service (DBCS)
- On-Demand Backups on DBCS

19. Performing Database Recovery
- Database Recovery Advisor
- Recovering Data Files in NOARCHELOG Mode
- Recovering Data Files in ARCHIVELOG Mode
- Recovery Options in Database Cloud Service (DBCS)

20. Monitoring and Tuning Database Performance
- Performance Planning Considerations
- Automatic Workload Repository (AWR)
- Automatic Database Diagnostic Monitor (ADDM)
- Advisory Framework
- Managing Metric Thresholds and Alerts
- Monitoring Wait Events, Sessions, and Services
- Performance Tuning Methodology
- Managing Memory Components

21. SQL Tuning
- SQL Tuning Process
- Oracle Optimizer
- Optimizer Statistics
- SQL Tuning Advisor
- SQL Access Advisor
- SQL Performance Analyzer