Complete Oracle Database Administration course 19C21C
What you’ll learn
Oracle Database Administration
Oracle Database Architecture, Physical files of the DB, Memory Structures, Memory Management, Background Processes
How to install Oracle Database Software on the server without GUI
How to access Oracle Database via sqlplus, sqlcl and SQL Developer
Managing Database Instance: Starting and Shutting down DB, working with initialization parameters, Diagnosing problems, working with Data Dictionary
Oracle Net Services
Administering User Access, Privileges & Roles, Resource Limitation
Multitenancy: Creating PDBs from SEED, Clonning PDBs, creating Refreshable Clones, Unplug/Plug PDBs
Transparent Data Encryption (TDE)
Creating and Managing Tablespaces
Managing UNDO Data
Practicing different Backup and Recovery scenarious via RMAN
Moving Data: Data Pump, SQL Loader
Data Guard configuration
Applying the latest Database Patch
Database Upgrade from 19c to 21c
Requirements
Basic Linux Knowledge
understand what is a process in linux
Basic SQL Knowledge
Description
After completing this Complete Oracle Database Administration course (19C,21C) course you will become a confident Database Administrator and will be ready to jump start your career.You get hands-on experience in the most common administration tasks. You will create and configure Oracle Database Server for the real world production scenario ( in 99% there is no GUI on production servers ). We will go the extra mile and implement different backup strategies, perform numerous restore operations in the Oracle Database Backup&Recovery section of the course. We don’t forget about Patching operations. Because these operations are required to comply with information security policies. And we will have many more interesting assignments.According to the U.S. BUREAU OF LABOR STATISTICS employment of database administrators is projected to grow 15 percent from 2019 to 2029, much faster than the average for all occupations. Growth in this occupation will be driven by the increased data needs of companies across the economy. After the pandemic the demand doubles.There is a lack of DBAs even in the Oracle itself! Follow my Instagram page – @it.rockstars, where I post new opening positions on a regular basis.The long-term support Oracle Database 19c version was chosen for this course to teach you the database administration skills. It provides the highest level of release stability and longest duration of support and bug fixes, giving you the most stable platform for your applications.At the end of the course we will learn different ways to Upgrade from the 19c to 21c version. Upgrades are crucial to satisfy business high growing demands for the new features released in the new product versions. All operation manuals provided for the 19c version still work on 21c.
Overview
Section 1: Introduction
Lecture 1 Introduction
Section 2: Oracle Database Architecture ( part 1 )
Lecture 2 Oracle Database Server Architecture. Basics.
Lecture 3 Physical files of the Database review
Lecture 4 Possible Oracle Server Configurations
Section 3: Oracle Database Installation
Lecture 5 Important Message
Lecture 6 Create and configure Virtual machine in VirtualBox Manager
Lecture 7 Download and Install Oracle Linux on VM
Lecture 8 SOFTWARE SILENT INSTALLATION
Lecture 9 License Warning
Section 4: Oracle Database Architecture ( part 2 )
Lecture 10 Memory Structures
Lecture 11 Memory Management
Lecture 12 Background processes
Lecture 13 Multitenant Architecture
Section 5: Accessing an Oracle Database
Lecture 14 SQL*Plus
Lecture 15 Oracle SQL Developer
Lecture 16 SQLcl
Lecture 17 OEM
Section 6: Manage Database Instance
Lecture 18 Initialization Parameters
Lecture 19 Starting DB Instance
Lecture 20 Diagnostic Repository
Lecture 21 Data Dictionary
Lecture 22 Shutting Down an DB Instance
Section 7: Creating PDBs
Lecture 23 Creating PDBs from SEED
Lecture 24 Cloning PDBs
Lecture 25 Refreshable Clone
Lecture 26 Unplugging and Plugging PDBs
Lecture 27 Unplug/Plug PDB using an archive file
Lecture 28 Dropping PDBs
Section 8: Oracle Net Services
Lecture 29 Part 1
Lecture 30 Part 2
Section 9: Users
Lecture 31 Creating Users
Lecture 32 Privileges & Roles
Lecture 33 Show Privileges
Lecture 34 Revoke privilege, Drop roles and users
Lecture 35 Authentication
Lecture 36 Limit Resources
Section 10: TDE
Lecture 37 TDE
Section 11: Tablespaces
Lecture 38 General Information
Lecture 39 Create Tablespaces
Lecture 40 Alter Tablespace
Lecture 41 OMF
Section 12: UNDO
Lecture 42 What is UNDO?
Lecture 43 UNDO vs REDO
Lecture 44 Read-consistent queries
Lecture 45 Flashback queries
Lecture 46 UNDO Management
Section 13: Backup & Recovery
Lecture 47 What can go wrong?
Lecture 48 What should you configure in DB?
Lecture 49 RMAN
Lecture 50 Backup Types
Lecture 51 Backup pieces, sets and image copies
Lecture 52 RMAN configuration
Lecture 53 Create a Full DB backup
Lecture 54 Create an Incremental DB backup
Lecture 55 Backup Strategies
Lecture 56 Backup Scripts
Lecture 57 Schedule Backup Scripts
Lecture 58 Viewing Backups
Lecture 59 Remove RMAN Backups
Lecture 60 Manage Archived Redo Logs with RMAN
Lecture 61 Detect Data Corruption with RMAN
Lecture 62 Recovery Decision
Lecture 63 Restore lost Control File
Lecture 64 Recover from the lost Redo Log File
Lecture 65 Understand Complete and Incomplete Recovery
Lecture 66 High Level Procedure for the Recovery with RMAN
Lecture 67 Recover PDB
Lecture 68 PDB PITR
Lecture 69 Recover CDB
Lecture 70 CDB PITR
Lecture 71 Checkpoint
Lecture 72 Instance Recovery
Lecture 73 Instance MTTR
Section 14: Patch DB
Lecture 74 General Procedure
Lecture 75 Checking Installed Patches
Lecture 76 Download Patch
Lecture 77 Upgrade OPatch tools
Lecture 78 Preparation steps
Lecture 79 Apply Patch
Section 15: Monitoring
Lecture 80 Monitoring Script ( part 1 )
Lecture 81 Monitoring Script ( part 2 )
Lecture 82 EM: Connection
Lecture 83 EM: Create Load
Lecture 84 EM: Analyze Data
Lecture 85 Create AWR report
Section 16: Oracle Database Upgrade from 19c to 21c
Lecture 86 Upgrade Overview
Lecture 87 Upgrade PDB with UNPLUG/PLUG
Lecture 88 Upgrade PDB using Refreshable Clone method
Section 17: Data Guard
Lecture 89 Introduction
Lecture 90 Architecture
Lecture 91 DG configuration: Steps on the Primary DB
Lecture 92 DG configuration: STBY server configuration
Lecture 93 DG configuration: Network
Lecture 94 DG configuration: Create Standby Database
Lecture 95 DG configuration: Broker
Lecture 96 Switchover
Lecture 97 Failover
Section 18: Moving Data
Lecture 98 Data Pump (part I)
Lecture 99 Data Pump (part II)
Lecture 100 Load records from a CSV file by using Linux commands
Lecture 101 Load Data from a CSV file by using External Tables (part1)
Lecture 102 Load Data from a CSV file by using External Tables (part2)
Lecture 103 Load Data From a CSV file by using SQL Loader
Section 19: Production Challenges
Lecture 104 Automate Startup of the Oracle Database
Lecture 105 Discovere if a System Parameter has been changed
Lecture 106 Rebuild or Coalesce?
Lecture 107 Recover a Corrupted Block
Lecture 108 Restore RMAN backup on the New Server
Lecture 109 TDE Rekey Operation
Section 20: BONUS: 1Z0-082 Exam Examples ( Database Administration Part )
Lecture 110 1Z0-082 topics
Section 21: BONUS: ATP ( Database in the Oracle Cloud )
Lecture 111 Create an Always Free Cloud Account
Lecture 112 Create ATP database
Lecture 113 Connect to ATP ( SQL Developer )
Section 22: BONUS: Practice SQL skills
Lecture 114 Important announcement
Lecture 115 Installing Sample Schemas
Students looking for a job in IT industry,IT specialists willing to improve their database knowledge,Retraining for DBA who worked with other Database Management Systems,Oracle Database Beginners willing to advance
Course Information:
Udemy | English | 9h 48m | 4.38 GB
Created by: Oleksiy Gusarov
You Can See More Courses in the IT & Software >> Greetings from CourseDown.com