Who is the target audience?

Oracle Database Administrators who want to learn how to create and manage Oracle RAC databases and administer Oracle Data Guard.

Course curriculum

  • 1
    Oracle 11g Database Administration
    • Linux Fundamentals I
    • Linux Fundamentals II
    • Linux Fundamentals III
    • Linux Fundamentals IV
    • Linux Fundamentals V
    • Differences Between Windows And Linux
    • What Is A Linux Operating System Prompt
    • Check System Requirements
    • Linux Commands: How To Move Backwards In Linux
    • Linux Commands: How To Move Forward In Linux
    • Linux Commands: What Is A Mount Point
    • Linux Commands: How To Create A Directory In Linux
    • Linux Commands: How To Create A File In Linux
    • Linux Commands: How To Copy A File Or Directory In Linux
    • Linux Commands: How To Move A File Or Directory In Linux
    • Linux Quizes
    • Linux Commands: How To Delete A File Or Directory In Linux
    • Linux Commands: How To List Directories In Linux
    • Linux Commands: How To Switch Users In Linux
    • Linux Commands: How To Change Permissions On A File In Linux
    • Linux Commands: How To Change Ownership In Linux
    • Linux Commands: How To Shutdown Your Server In Linux
    • Notes: Basic Unix Commands
    • Project 1
    • How To Turn In Your Homework Assignment
    • Week 2: Part 1
    • Week 2: Part 2
    • How To Connect To An Oracle Database
    • How To Startup And Shutdown An Oracle Database
    • Select Statement- What Is A Server Parameter File
    • What Is A Controlfile
    • What Is A Datafile And Redolog File
    • What Is A Datafile And Redolog File
    • Select Statements: Explaining Data Manipulation,Data Definition,Data Control Languages
    • Select Statement- Rules Of Select Statements| Select Statement Basics
    • Select Statement- Aliases| Select Statement Basics
    • Select Statement- Arithmetic Functions|Select Statement Basics
    • Select Statement- Arithmetic Functions|Select Statement Basics
    • Select Statement- Case Functions|Select Statement Basics
    • SQL QUIZ PART 1
    • Select Statement- Concatenation|Select Statement Basics
    • Select Statement- Group By Clause|Select Statement Basics
    • Select Statement- Length Clause|Select Statement Basics
    • Select Statement- Replace Clause|Select Statement Basics
    • Select Statement- Left Pad And Right Pad|Select Statement Basics
    • Select Statement- NVL|Select Statement Basics
    • Select Statement- Left Pad And Right Pad|Select Statement Basics
    • Select Statement- Instr|Select Statement Basics
    • Select Statement- Substr|Select Statement Basics
    • Select Statement-To-Char|Select Statement Basics
    • Select Statement-To-Char|Select Statement Basics
    • Select Statement- Where Clause Pt 1|Select Statement Basics
    • Select Statement-Where To + And Clause|Select Statement Basics
    • Select Statement- OR clause|Select Statement Basics
    • Select Statement- And Clause|Select Statement Basics
    • Select Statements- Where Clause contd|Select Statement Basics
    • Select Statement-Between clause|Select Statement Basics
    • Select Statement- Between Clause Contd|Select Statement Basics
    • SQL QUIZ PART 2
    • Select Statement-In clause|Select Statement Basics
    • Select Statement-In clause|Select Statement Basics
    • Select Statement- Like|Select Statement Basics
    • Select Statement-Null Clause|Select Statement Basics
    • Select Statement- Putting It All Together|Select Statement Basics
    • Project 2
    • SQL CLASS NOTES
    • PROJECT 1 SOLUTIONS
    • About this week
    • Week 3: Part 1
    • Week 3: Part 2
    • Select Statement- Group by Clause|Select Statement Basics
    • Select Statement-GroupBY Clause Part2|Select Statement Basics
    • Select Statement-Group BY Clause Part 3|Select Statement Basics
    • Select Statement- How To Perform A Subquery|Select Statement Basics
    • Select Statement- How To Perform A Subquery Part 2|Select Statement Basics
    • Select Statement- How To Perform A Subquery Part 3|Select Statement Basics
    • Select Statement- What Is An Equijoin| Select from Multiple Tables
    • Select Statement- What Is An Equijoin| Select from Multiple Tables
    • Select Statement- What Is An Equijoin Part 2 | Select from Multiple Tables
    • Select Statement- What Is An Equijoin Part 3| Select from Multiple Tables
    • Select Statement- What Is An Equijoin Part 4| Select from Multiple Tables
    • Select Statement- What Is An Equijoin Part 5| Select from Multiple Tables
    • Select Statement- What Is A Leftjoin| Select from Multiple Tables
    • Select Statement- What Is A Rightjoin| Select from Multiple Tables
    • Select Statement- Minus Clause| Select from Multiple Tables
    • Select Statement- Intersect Clause| Select from Multiple Tables
    • Select Statement- Union Clause| Select from Multiple Tables
    • SQL QUIZ PART 3
    • Select Statement- Union Clause| Select from Multiple Tables
    • Select Statement-Putting IT All Together| Selecting From Multiple tables
    • Project 3
    • Copy of SQL CLASS NOTES
    • Copy of PROJECT 2 SOLUTIONS
    • About This Week
    • Week 4: Part 1
    • Week 4: Part 2
    • Data Definition Language- How To Connect To A New Schema
    • Data Definition Language- How to Create A Duplicate Table
    • Data Definition Language- Understanding Oracle Database Tables Datatypes
    • Data Definition Language- Table Column Level Constraints
    • Data Definition Language- Adding A Primary Key Constraint
    • Data Definition Language- Adding A Not Null Constraint
    • Data Definition Language- Adding Unique Constraint
    • Data Definition Language- Adding A Check Constraint
    • Data Definition Language-Adding A Foreign Key Constraint
    • Alter Statement- Adding A Table Constraint After Table Creation| Data Definition Language
    • Alter Statement- Disable Column Level Constraint After Table Creation|Data Definition Language
    • Alter Statement- Enabling A ColumnConstraint After Table Creation|Data Definition Language
    • Alter Statement- Dropping A Column Level Constraint After Table Creation|Data Definition Language
    • Alter Statement-Renaming A Column In A Table|Data Definition Language
    • Alter Statement- Modify A Table Column|Data Definition Language
    • Alter Statement- Renaming A Table|Data Definition Language
    • Alter Statement- Modify A Table Column|Data Definition Language
    • Alter Statement- Drop A Table Column|Data Definition Language
    • Alter Statement- Adding A Column To A Table|Data Definition Language
    • Insert Statement- Inserting Data Into A Table Column|Data Manipulation Language
    • Update Statement- Update Data In A Table Column|Data Manipulation Language
    • Deleting Data In A Table Column|Data Manipulation Language
    • Delete, Drop, Truncate In SQL
    • Data Definition Language-Creating A View
    • SQL QUIZ 4
    • Data Definition Language- Create A Sequence
    • Data Definition Language- Create A Sequence
    • Data Definition Language- Create An Index
    • Data Definition Language- Create A Synonym
    • Project 4
    • SQL CLASS NOTES
    • PROJECT 3 SOLUTIONS
    • About This Week
    • Week 5: Part 1
    • Week 5: Part 2
    • Notes: Database Creation
    • Notes: Managing Oracle Instance
    • Notes: Oracle Database Architecture
    • Notes: User Management
    • How To Create An Oracle Database
    • Oracle Database Administration- Understanding The Oratab File|
    • Oracle Database Administration- Editing The Bash Profile
    • Oracle Database Administration- Understanding Spfile Part 2
    • Oracle Database Administration- Understanding The Export Command
    • Oracle Database Administration- Understanding The Echo Command
    • Oracle Database Administration- Understanding The Physical Structure Of An Oracle Database
    • Oracle Database Administration- Understanding The Logical Structure Of An Oracle Database
    • Oracle Database Administration- Difference The Between SPfile And Pfile
    • Oracle Database Administration-How To Create An Spfile And Pfile
    • Oracle Database Administration- Editing The Pfile
    • Oracle Database Administration- How To Start Oracle Database With The Pfile
    • Oracle Database Administration- How To View Spfile Parameters
    • Oracle Database Administration- Understanding Spfile Scopes
    • Oracle Database Administration- Understanding Spfile Scopes
    • Oracle Database Administration- Understanding The Controlfile
    • Oracle Database Administration- Understanding Datafile
    • Oracle Database Administration- Understanding Redolog files
    • Oracle Database Administration- Understanding Archived Redologfiles
    • Oracle Database Administration- Understanding Dynamic Performance Views
    • Oracle Database Administration- Understanding How To Create A Tablespace And Datafiles
    • Oracle Database Administration- Understanding The 5 Default Tablespaces
    • Oracle Database Administration- Understanding Oracle Managed Files (OMF)
    • Oracle Database Administration- Understanding How To Create Users In A Database
    • Oracle Database Administration- Understanding How To Create Users In A Database
    • Oracle Database Administration- Understanding System Privileges
    • Oracle Database Administration- Understanding How To Create Roles
    • Oracle Database Administration- Understanding How To Create Roles
    • Oracle Database Administration- Understanding How To Create User Profiles
    • Oracle Database Administration- Understanding Enterprise Manager In 11g
    • Project 5
    • Copy of ORACLE ADMIN QUIZ 1
    • Copy of PROJECT 4 SOLUTIONS
    • About This Week
    • Week 6: Part 1
    • Week 6: Part 2
    • Notes: Database Maintenance
    • Notes: Oracle_Network
    • Notes: Auditing
    • Project 6
    • Oracle Database Administration- Understanding Standard Auditing
    • Oracle Database Administration- Understanding Standard Auditing Part 2
    • Oracle Database Administration- Understanding How To Set Up Standard Audits
    • Oracle Database Administration- Understanding Setting Up Fine Grain Auditing
    • Oracle Database Administration- Understanding How To Set Up Finegrain Auditing contd
    • Oracle Database Administration- Understanding How To Disable Finegrain Audit Policies
    • Oracle Database Administration- Understanding How To Configure Oracle Listener
    • Oracle Database Administration- Explaining How To Control The Oracle Database Listener
    • Oracle Database Administration- Undestanding How To Configure The TNS Names.ora File
    • Oracle Database Administration- How to Register The Database A Listener Via Net Manager
    • Oracle Database Administration- Understanding How To Resolve Common Listener Issues
    • Oracle Database Administration- Understanding How Configure The Archivelog
    • Oracle Database Administration- Understanding How To Configure Fast Recovery Area
    • Oracle Database Administration- Understanding The Undo Tablespace
    • Oracle Database Administration- Understanding How To Configure The Undo Tablespace
    • Oracle Database Administration- Listener Definition
    • Oracle Database Administration- Listener Creation
    • Oracle Database Administration- Listener Modification
    • Oracle Database Administration- Understanding TNS Names.ora file
    • Oracle Database Administration-TNS Names Creation
    • Oracle Database Administration- Database Registration
    • Oracle Database Administration- Understanding Automatic Workload Repository (AWR)
    • Oracle Database Administration- Undestanding Automatic Workload Repository(AWR) Contd
    • Oracle Database Administration- Running An AWR Report
    • Oracle Database Administration- Running An ADDM Report
    • Oracle Database Administration- Identifying Blocking Sessions
    • Oracle Database Administration- Understanding The Optimizer
    • Oracle Database Administration- Optimizer Statistic Gathering
    • ORACLE ADMIN QUIZ 2
    • PROJECT 5 SOLUTIONS
    • About This Week
    • Week 7: Part 1
    • Week 7: Part 2
    • Notes: Backup Concepts
    • Notes: Datapump
    • Notes: Flashback
    • Notes: Locks
    • Notes: Restore and Recovery
    • Notes: RMAN Backup
    • Project 7
    • Oracle Database Administration II- Connecting To Recovery Manager
    • Oracle Database Administration II- Setting Up RMAN Parameters
    • Oracle Database Administration II- Setting Up RMAN Contd
    • Oracle Database Administration II- Backing Up The Database Via Recovery Manager
    • Oracle Database Administration II- How To Recover From A SPfile Loss
    • Oracle Database Administration II- How To Recover From A Controlfile Loss
    • Oracle Database Administration II- How To Recover From A Datafile Loss
    • Oracle Database Administration II- How To Recover From A Redo Log File Loss
    • Oracle Database Administration II- How To Recover From A Loss Of All Physical Files
    • Oracle Database Adminsitration II- Backing Up The Controlfile To A Trace File
    • Oracle Database Administration II- Datapump Part 1
    • ORACLE ADMIN QUIZ 3
    • Oracle Database Administration II- Datapump Backup Part 2|
    • Oracle Database Administration II- Flashback Database
    • Oracle Database Administration II- Flashback Drop
    • Oracle Database Administration II- Flashback Table
    • Oracle Database Administration II- Resetting Sys Password File
    • ORACLE ADMIN QUIZ 4
    • Oracle Database Administration II- SQL LOADER Best Practices
    • RMAN Settings
    • PROJECT 6 SOLUTIONS
    • About This Week
    • Week 8: Part 1
    • Week 8: Part 2
    • How To uninstall Oracle 12c Software From A Server
    • Oracle Upgrade Explained
    • Oracle Database Administration II- Upgrade 11.2.0.1 to 11.2.0.2
    • Oracle Database Administration II- Upgrade 11.2.0.1 to 11.2.0.2 Part 2
    • Upgrade From 11.2.0.4 To Oracle 12c Part 3
    • Upgrade From 11.2.0.4 To Oracle 12c
    • Upgrade From 11.2.0.4 To Oracle 12c Part 2
    • Upgrade From 11.2.0.4 To Oracle 12c Part 3
    • Oracle Database Administration II- Datafile Relocation Explained
    • Oracle Database Administration II- Critical Patch Update
    • Oracle Database Administration II- Sqldeveloper Basics
    • ORACLE ADMIN QUIZ 4
    • Oracle Database Administration II- Sqldeveloper New Connection
    • Oracle Database Administration II- Duplicating A Database Via Rman
    • Cloning A Database Via Recovery Manager Script
    • Project 8
    • Oracle Software
    • PROJECT 7 SOLUTIONS
    • FINAL EXAM
  • 2
    ORACLE 12C ADMINISTRATION
    • How To Uninstall The Oracle Software Completely From Your Server
    • How To Create A Container Database
    • How To Create A Pluggable Database From DBCA
    • How To Create A Pluggable Database From Seed
    • Registering The Container And PDB Databases With The TNS Names And Listener.ora Files
    • Registering The Container And PDB Databases With The TNS Names And Listener.ora Files Part 2
    • How To Move From One PDB To Another PDB Database
    • How To Put PDB Database In Archive Redo Log Mode
    • How To Save The State Of A Pluggable Database
    • How To Change Initialization Parameters In A Pluggable Database
    • Creating A Common User
    • Creating A Common User Locally
    • Creating A Common Role
    • Granting A Common Role To A Common User
    • Revoking A Common Role
    • Backing-Up-CDB-Database
    • Backing-Up-PDB-Database
    • Backing-Up-PDB-Database-AS-PDBADmin
    • Backing-Up-PDB-Tablespace-Database
    • Create-Common-User-For-Backups
    • FlashbackCDB-With-Restorepoint
    • PDB-TablespaceLoss-recovery
    • 12C PROJECT
    • Backup and recovery scripts
    • UNINSTALLING ORACLE SOFTWARE
    • Multitenant Oracle Database How To Install Oracle Software From Your Machine
    • Oracle Database How To Create An Empty Container Database
    • Oracle Database How To A NON- Container Database
    • Configuring Your Net Service Names File
    • Connecting To SQL Developer
    • Creating A Pluggable Database From Seed
    • Creating A Pluggable Database Through DBCA
    • Registering Your PDB With Your TNS Names File
    • Deleting A Pluggable Database Through DBCA
    • Creating A Pluggable Database Through SQL Developer
    • Understanding The New Dictionary Tables In Oracle 12C
    • Switching Containers
    • Locating All PDB's In The Container Database
    • Locating All PDB's In The Container Database
    • Creating A CDB and PDB Through DBCA wih Example TBS
    • Viewing Tables Owned By Schemas From The Root Container
    • Common Files Held By Pluggable DB'S
    • Starting And Shutting Down Container Database
    • Starting And Shutting Down PDB Database
    • Starting And Shutting Down PDB Database From Root
    • Changing Parameters In The Root Container And PDB Simultaneously
    • Changing Parameters In Your PDB Database
    • Getting History of Your PDB Database
    • Dropping Your PDB Database Including Datafile
    • Examining The States Of Your PDB Database
    • Examining Which Parameter Is Modifiable
    • Renaming Your Pluggable Database
    • Drop and Clone Your Pluggable Database
    • Understanding PDB$SEED
    • Cloning A PDB From Another PDB
    • Creating A Database Link
    • Creating A Pluggable Database Through A DB Link
    • Using EZ-Connect Configuration To Connect To A Database
    • Unplugging And Replugging A PDB via XML File
    • Creating A PDB via Archive File
    • Creating A PDB From Non-PDB via DBLink
    • Creating A PDB From DBMS PACKAGE
    • Creating A REFRESHABLE Pluggable Database
    • Understanding Common Users and Local Roles
    • Creating Common Users And Granting Them Privileges
    • Creating Common Users And Granting Them Local Privileges
    • Viewing All Local Users In The Container
    • Creating Local Users In The PDB Container
    • Viewing All Common Roles In The PDB and Root Container
    • Creating Common Role In The CDB$Root Container
    • Creating Local Role In The PDB Container
    • Granting Common Role To Common User
    • Viewing Granted Roles
    • Granting Common Role To Common User More Examples
    • Granting Privileges To A Common Role
    • Revoking Privileges From A Common Role
    • Granting Common Role To Local User
    • Backing Up A CDB Database
    • Backing Up A PDB Database
    • Backing Up A PDB Tablespace
    • Restore A SYSTEM PDB Tablespace
    • Restore A NON- SYSTEM PDB Tablespace
    • Backing Up A CDB Database As A Dedicated User
    • Backing Up A CDB Database As A SYSBACKUP
    • Creating A Restore Point
    • Point In Time Recovery For a PDB
    • Flashback To Scn
    • Flashback Pluggable Database To Restore Point
    • Flashback Pluggable Tablespace to PITR
    • Exporting A Schema From One PDB To Another
    • Understanding Application CDB's and PDB's
    • Creating An Application Container
    • Installing An Application In the Application Root
    • Creating An Application Seed
    • Creating An Application Seed From Application Root
    • Creating An Application Seed From Application Root
    • Creating An Application PDB
    • Viewing Application PDB and Application CDB's
    • Registering App PDB and App CDB's With Listener
    • Installing A New Application and Syncing App PDB's
    • Querying Data, Meta and Extended Linked Objects
    • Deleting Rows From Data Linked, MetaLinked and Extended Data-Linked Objects
    • Upgrading An Application
    • Patching An Application
  • 3
    Oracle12c Real Application Clusters Classroom Lecture
    • Oracle Real Application Clusters Classroom Lecture Video 1
    • Oracle Real Application Clusters Classroom Lecture Video 2
    • Oracle Real Application Clusters Classroom Lecture Video 3
    • Oracle Real Application Clusters Classroom Lecture Video 4
    • Oracle Real Application Clusters Classroom Lecture Video 5
    • Oracle Real Application Clusters Classroom Lecture Video 6
    • Oracle Real Application Clusters Classroom Lecture Video 7
    • Oracle Real Application Clusters Classroom Lecture Video 8
    • Oracle Real Application Clusters Classroom Lecture Video 9
    • Oracle Real Application Clusters Classroom Lecture Video 10
    • Oracle Real Application Clusters Classroom Lecture Video 11
    • Oracle Real Application Clusters Classroom Lecture Video 12
    • Oracle Real Application Clusters Classroom Lecture Video 13
    • Oracle Real Application Clusters Classroom Lecture Video 14
    • Oracle Real Application Clusters Classroom Lecture Video 15
    • Oracle Real Application Clusters Classroom Lecture Video 16
    • Oracle Real Application Clusters Classroom Lecture Video 17
    • Oracle Real Application Clusters Classroom Lecture Video 18
    • Oracle Real Application Clusters Classroom Lecture Video 19
    • Oracle Real Application Clusters Classroom Lecture Video 20
    • Oracle Real Application Clusters Classroom Lecture Video 21
    • Oracle Real Application Clusters Classroom Lecture Video 22
    • Oracle Real Application Clusters Classroom Lecture Video 23
    • Oracle Real Application Clusters Classroom Lecture Video 24
    • Oracle Real Application Clusters Classroom Lecture Video 25
    • Oracle Real Application Clusters Classroom Lecture Video 26
    • Oracle Real Application Clusters Classroom Lecture Video 27
    • Oracle Real Application Clusters Installation Video 1
    • Oracle Real Application Clusters Installation Video 2
    • Oracle Real Application Clusters Installation Video 3
    • Oracle Real Application Clusters Installation Video 4
    • Oracle Real Application Clusters Installation Video 5
    • Oracle Real Application Clusters Installation Video 6
    • Oracle Real Application Clusters Installation Video 7
    • Oracle Real Application Clusters Installation Video 8
    • Oracle Real Application Clusters Installation Video 9
    • Oracle Real Application Clusters Installation Video 10
    • Oracle Real Application Clusters Installation Video 11
    • Oracle Real Application Clusters Installation Video 12a
    • Oracle Real Application Cluster Installation Video 12b
    • Oracle Real Application Clusters Installation Video 12
    • Oracle Real Application Clusters Installation Video 13
    • Oracle Real Application Clusters Installation Video 14
    • Oracle Real Application Clusters Installation Video 15
    • Grid Infrastructure Commands
    • RAC RPMS
    • ORACLE REAL APPLICATION CONFIGURATION SCRIPTS
  • 4
    Oracle 12C RAC Advanced
    • Oracle RAC Video 1 - How To Download Linux 6.5 ISO File
    • Oracle RAC Video 2 - Installing Your Virtual Machine
    • Downloading XMING Software
    • Oracle RAC Video 5 - Downloading Putty Software
    • Oracle RAC Video 6 - Creating Primary Node Virtual Machine
    • Oracle RAC Video 7 - Configuring Network Settings For Primary Node
    • Oracle RAC Video 8 - Installing OEL 6.5 To Virtual Machine
    • Oracle Rac Video 9 - Creating Second Node
    • Oracle Rac Video 10 - Configuring Network Settings On Node 2
    • Oracle Rac Video 11 - Establishing Connectivity Between The Two Nodes
    • Oracle Rac Video 12 - Fixing Eth0 and Eth1 Connectivity Issues
    • Oracle Rac Video 13 - Installing Yum Packages
    • Oracle Rac Video 14 - Installing WinSCP
    • Oracle RAC Video 15 - Transferring Database and Grid Infrastructure Software Files Via WinSCP
    • Oracle RAC Video 16 - Configuring Private , VIP And Scan Name Ip's For Connectivity
    • Oracle RAC Video 17 - Configuring Shared Storage
    • Oracle RAC Video 18 - Partitioning Hard Disks For Both Nodes
    • Oracle RAC Video 19 - Creating ASM Disks From Partitions
    • Oracle RAC Video 20 - Configuring Grid Infrastructure Pre-Requisites
    • Oracle RAC Video 21 - Configuring SSH Utility
    • Oracle RAC Video 22 - Running Grid Infrastructure Pre Check
    • Oracle RAC Video 23 - Installing Grid Infrastructure
    • Oracle RAC Video 24 - Creating Diskgroups Via ASMCA
    • Oracle RAC Video 25 - Installing Oracle Software On Both Nodes
    • Oracle RAC Video 26 - Creating Oracle Database On Both Nodes
    • Oracle RAC Video 27 - Setting Up RAC Connection
    • Oracle RAC Video 28 - Different Ways To Connect To Rac DB
    • Oracle RAC Video 29 - How To Use Srvctl Utility
    • Oracle RAC Video 30 - How To Stop A Database On An Instance
    • Oracle RAC Video 31 - How To Stop A Database On All Instances
    • Oracle RAC Video 32 - How To Start A Database On A Local Instances
    • Oracle RAC Video 33 - How To Locate The Spfile On Shared Storage
    • Oracle RAC Video 34 - Creating A Pfile From An Spfile In Rac
    • Oracle Rac Video 35 - Changing Spfile Parameters On All Nodes
    • Oracle RAC Video 36 - Putting Your Database In Archivelog Mode
    • Oracle RAC Video 37 - Backing Up Your RAC Database
    • Oracle RAC Video 38 - Creating Backup Jobs For Your Database
    • Oracle RAC Video 39 - Backing Up Your Database WIth Tags
    • Oracle RAC Video 40 - Using The Global View
    • Oracle RAC Video 41 - Using CRSCTL Utility
    • Oracle RAC Video 42 - Using Olsnodes Utility To Check The Number Of Nodes
    • Oracle RAC Video 43 - Shutting Down The Clusterware Resources
    • Oracle RAC Video 44 - Shutting Down The Clusterware Resources On A Local Node
    • Oracle RAC Video 45 - Enabling High Availability Service
    • Oracle RAC Video 46 - Creating User Friendly OCR Copies
    • Oracle RAC Video 47 - Performing Manual OCR Backups
    • Oracle RAC Video 48 - Understanding The OLR File
    • Oracle RAC Video 49 - Understanding The Voting Disks
    • Oracle Rac Video 50 - Verifying The Status Of Node Applications Via SRVCTL
    • Oracle Rac Video 51 - Understanding ASM Basics
    • Oracle Rac Video 52 - Understanding ASMCMD Basics
    • Oracle Rac Video 53 - Creating Directories VIA ASMCMD
    • Oracle Rac Video 54 - Creating A Service on A Local Node
    • Oracle Rac Video 55 - Modifying A Service
    • Oracle Rac Video 56 - Enabling And Relocating Services
    • Oracle Rac Video 57 - Creating TNS Entry For Dynamic Services
    • Oracle Rac Video 58 - Testing A Dynamic Services
    • Oracle Rac Video 59 - Testing A Dynamic Services From RAC2 Back To RAC1
    • Oracle Rac Video 60 - How To Create A One Node RAC Database
    • Oracle Rac Video 61 - How To Start A Service On A One Node RAC DB On 12c Release 1
    • Oracle Rac Video 62 - How To Relocate A One Node RAC DB On 12c Release 1
    • Oracle Rac Video 63 - How To Convert A One Node DB To A RAC Database
    • Oracle Rac Video 64 - Creating A Multitenant RAC Database
    • Oracle Rac Video 65 - Different Ways Of Connecting To A Single Node A RAC Database
    • Oracle Rac Video 66 - Getting The Status Of A Rac Database
    • Oracle Rac Video 67 - Connecting To A Of A Multitenant RAC Database
    • Oracle Rac Video 68 - Connecting To A Multitenant PDB RAC Database
    • Oracle Rac Video 69 - Closing To A Multitenant PDB RAC Database On A Particular Node
    • Oracle Rac Video 70 - Closing To A Multitenant PDB RAC Database On All Nodes
    • Oracle Rac Video 71 - Cloning A Multitenant PDB RAC Database On All Nodes
    • Oracle Rac Video 72 - Connecting To A Cloned Multinentant PDB
    • Oracle Rac Video 73 - Creating A Service For A Multitenant PDB
    • Oracle Rac Video 74 - Dropping A Multitenant PDB Via SQLPlus
    • Oracle Rac Video 75 - Dropping A Multinentant PDB and CDB Via DBCA
    • Oracle Rac Video 76 - Creating Serverpools
    • Oracle Rac Video 77 - Creating Policy Managed Database
    • Oracle Rac Video 78 - Connecting To Your Policy Managed Database
    • Oracle Rac Video 79 - Creating Dynamic Services For Your Policy Managed PDB Database
    • Oracle Rac Video 80 - Creating Labels For Serverpools
    • Oracle Rac Video 81 - Displaying Serverpool Configuration
    • Oracle Rac Video 82 - Removing Serverpool Labels and Server Categories
    • Oracle Rac Video 83 - Removing A Node From A CLuster - Part 1
    • Oracle Rac Video 84 - Removing A Node From A Cluster - Removing Oracle Home - Part 2
    • Oracle Rac Video 85 - Removing A Node From A Cluster - Removing Clusterware - Part 3
    • Oracle Rac Video 86 - Removing A Node From A Cluster - Deleting Node From Clusterware - Part 4
    • Oracle Rac Video 87 - Adding Node Incomplete
    • Oracle Rac Video 88 - Connecting To ASM Instance
    • Oracle Rac Video 89 - Determining Which DIskgroups are in Use By ASM
    • Oracle RAC Video 90 - Determing Which ASM Disks Are Not Members Of A Diskgroup
    • Oracle RAC Video 91 - Creating A New Diskgroup Via ASM Instance - External Redundancy
    • Oracle RAC Video 92 - Adding A Disk To A Diskgroup Via ASM Instance
    • Oracle RAC Video 93 - Removing A Disk From A Diskgroup
    • Oracle RAC Video 94 - Creating A New Diskgroup Via ASM Instance - Normal Redundancy
    • Oracle RAC Video 95 - Renaming A Diskgroup
    • Oracle RAC Video 96 - Navigating ASMCMD Utility
    • Oracle RAC Video 97 - Getting ASM Version and Patch Information
    • Oracle RAC Video 98 - Using LSDG Command
    • Oracle RAC Video 99 - Using LSDSK Command
    • Oracle RAC 100 - Using The Find And IOStats Command
    • Oracle RAC Video 101 - Creating New Hard Disks From Scratch
    • Oracle RAC Video 102 - Adding Second Node To New Disk
    • Oracle RAC Video 103 - Using Fdisk To Create Partitions
    • Oracle RAC Video 104 - Stamping Disks With Oracle ASM
    • Oracle RAC Video 105 - Adding Disks To A Diskgroup via ASMCA
    • RAC PRACTICE SCRIPTS
  • 5
    Oracle 12c Dataguard Classroom Lecture And Installation
    • Data Guard Class Lecture
    • Dataguard Pre-Installation Video 1
    • Dataguard Pre-Installation Part 2
    • Dataguard Pre-Installation Part 3
    • Dataguard Pre-Installation Part 4
    • Changing Modes In Dataguard Configuration part 1
    • Changing Modes In Dataguard Configuration part 2
    • Changing Modes In Dataguard Configuration part 3
    • Verifying Archived Logs Are Applying To Standby Database
    • Inserting Data Into Primary Database In a Datguard Environment
    • Converting From Standby to Snapshot Database
    • Converting From A Snapshot To A Physical Standby Database
    • Performing A Switchover From Primary To Standby
    • How To Resolve "Resolvable Gap Issues"
    • How To Perform A Switchover From Standby To Primary
    • How To Configure Data Broker
    • Changing Protection Modes Via Data Guard Broker
    • Performing A Switch Over Via Databroker
    • DATAGUARD CONFIGURATION SCRIPTS
  • 6
    Oracle 12c Advanced Backup and Recovery Strategies
    • 12c Backup Video 1 - How To Uninstall The Oracle Software and Database
    • 12c Backup Video 2 - How To Install The Oracle Software and Create A Database
    • 12c Backup Video 3 - Understanding The Bash Profile
    • 12c Backup Video 4 - Different Ways To Connect To Recovery Manager
    • 12c Backup Video 5 - Creating A Dedicated User To Connect To Recovery Manager
    • 12c Backup Video 6 - Configuring Basic Rman Settings
    • 12c Backup Video 7 - Configuring Archive Log Mode
    • 12c Backup Video 8 - Performing A Consistent Backup Plus Archivelog
    • 12c Backup Video 9 - Backing Up Multiple Tablespaces
    • 12c Backup Video 10 - Listing Options In RMAN
    • 12c Backup Video 11 - Performing A Hot Backup In RMAN
    • 12c Backup Video 12 - Specifying A Backup Location
    • 12c Backup Video 13 - Determining Space Allocation In The FRA
    • 12c Backup Video 14 - Backing Up The Controlfile
    • 12c Backup Video 15 - Backing Up The Database With Tags
    • 12c Backup Video 16 - Perfoming Image Copy Backups
    • 12c Backup Video 17 - Changing Controlfile Record Keep Time
    • 12c Backup Video 18 - Performing Incremental Level Backups With Tags
    • 12c Backup Video 19 - Enabling Change Tracking
    • 12c Backup Video 19 - Enabling Change Tracking2
    • 12c Backup Video 20 - Scheduling A job With Cron
    • 12c Backup Video 21 - Setting Retention Policy In RMAN
    • 12c Backup Video 22 - Changing Backup Destination With Configure Channel Command
    • 12c Backup Video 23 - Checking RMAN Job Details With Virtual Tables
    • 12c Backup Video 24 - Running OS and SQL Commands In RMAN
    • 12c Backup Video 25 - Running Crosscheck Backup Commands In RMAN
    • 12c Backup Video 26 - Running Report Need Backup In RMAN
    • 12c Backup Video 27 - Monitoring Backup Jobs In RMAN
    • 12c Backup Video 28 - Changing Compression Algorithm For RMAN Backup Jobs
    • 12c Backup Video 29 - Breaking Up Backups Into Multi Sections
    • 12c Backup Video 30 - Creating Recovery Catalog Database
    • 12c Backup Video 31- Catalog Backup Pieces
    • 12c Backup Video 32- Cataloging Multiple Backup Pieces
    • 12c Backup Video 33- Backing Up The Fast Recovery Area
    • 12c Backup Video 34- Creating An E-Wallet For Your Backups
    • 12c Backup Video 35- Creating An Auto-Login Keystore
    • 12c Backup Video 36- Creating A Password Encryption Backup Set
    • 12c Backup Video 37- Creating A Dual Mode Encryption Backup Set
    • 12c Backup Video 38- Restore Database In No Archive Log Mode
    • 12c Backup Video 39- Restore All Datafiles In Archive Log Mode
    • 12c Backup Video 40- Restore Non-System Tablespace In Archive Log Mode
    • 12c Backup Video 41 - Saving Your DBID
    • 12c Backup Video 42 - Restoring Tablespace With Image Copy Backup
    • 12c Backup Video 43- Performing PITR After Data Loss
    • 12c Backup Video 44- Performing PITR After Data Loss IF Time Unknown
    • 12c Backup Video 45- Performing PITR Of A Tablespace
    • 12c Backup Video 46- Performing PITR Of A Table With Users Still Inserting Data
    • 12c Backup Video 47- Create Spfile From Memory
    • 12c Backup Video 48- Create Spfile From Pfile
    • 12c Backup Video 49- Restore Spfile From Autobackup
    • 12c Backup Video 51- Recreating A Lost Inactive RedoLog Member
    • 12c Backup Video 52- Recreating A Lost RedoLog Group
    • 12c Backup Video 53- Recreating A Lost RedoLog Group In Active Database
    • 12c Backup Video 54- Recreating Lost Members In An Active RedoLog Group
    • 12c Backup Video 55- Recreating Lost Members In A CUURENT RedoLog Group
    • 12c Backup Video 56- Recovery From Los Of Your Non - System Datafile
    • 12c Backup Video 57- Recovery From Loss Of Password File
    • 12c Backup Video 59- Recovering A Tablespace From Encrypted Backup
    • 12c Backup Video 60- Restoring A New Database From A Backupset
    • 12c Backup Video 61- Using Data Recovery Advisor
    • 12c Backup Video 62 - Recovery From Corrupted Blocks
    • 12c Backup Video 63 -Duplicating An Active Database
    • 12c Backup Video 64 -Creating An Auxiliary DB From Recovery Catalog Without The Source DB
    • 12c Backup Video 64 -Duplicating An Active Database With A Backupset
    • 12c Backup Video 66 -Creating A Duplicate db Without Recovery Catalog Or Active Database
    • 12c Backup Video 67- Creating A CONTAINER DB And PLUGGABLE DB
    • 12c Backup Video 68- Registering CONTAINER DB And PLUGGABLE DB With Listener and TNSNames
    • 12c Backup Video 69- Backing Up The Container Database
    • 12c Backup Video 70- Backing Up The Pluggable Database
    • 12c Backup Video 71- Backing Up The Tablespace In A Pluggable Database
    • 12c Backup Video 72- Restoring A Container Datafile
    • 12c Backup Video 73- Restoring A Pluggable Datafile
    • 12c Backup Video 58- Recovering From Lost Tempfile
  • 7
    ORACLE 12C GOLDEN GATE
    • Downloading XMING Software
    • Downloading Putty Software
    • Installing Your Virtual Machine Video 1
    • Oracle RAC Video 1 - How To Download Linux 6.5 ISO File
    • Oracle GG Video 5 - Download Oracle Software From Edelivery Platform
    • Oracle Dataguard Video 1 - How To Create A New VM For The Primary Server Part 1
    • Oracle Dataguard Video 2 - How To Create A New VM For The Primary Server Part 2
    • Oracle GG Video 9 - HOw To Create A New VM For The Target Server Part 2a
    • Oracle GG Video 10 - How To Create A New VM For The Source Server Part 3a
    • Oracle GG Video 11 - How To Create A New VM For The Target Server Part 3a
    • Oracle Dataguard Video 6 - Adding Oracle User To Primary VM
    • Oracle Dataguard Video 8 - Adding Oracle User To Standby VM
    • Oracle GG Video 13 - Adding Oracle User To Target VM a
    • Oracle Dataguard Video 14 - Saving Your Machine State
    • Oracle Dataguard Video 15 - Configuring IP Address For Primary VM
    • Oracle GG Video 16 - Configuring IP Address For Target VMa
    • Oracle GG Video 17 - Installing YUM updates and Downloading Oracle Software on Source Server
    • Oracle GG Video 18 - Setting Up Communication Between The Primay and Standby VM'sa
    • Oracle GG Video 19 - Installing YUM updates and Downloading Oracle Software on Target Server
    • Oracle GG Video 20 - Installing Oracle Database on Source Server
    • Oracle GG Video 21 - Installing Oracle Database on Target Server
    • Oracle GG Video 22 - Installing Oracle GoldenGate Software For Edelivery Site
    • Oracle GG Video 23 - Copying Oracle GoldenGate Software Zip Files To VM's
    • Oracle GG Video 25 - Installing Oracle Golden Gate Software on Source and Target Servers
    • Oracle GG Video 26 - Adding Entries In The Bash Profile For Both Servers
    • Oracle GG Video 27 - Configuring Golden Gate Supplemental Logging For Both Servers
    • Oracle GG Video 28 - Configuring The Golden Gate Master User For Replication
    • Oracle GG Video 29 - Granting Admin Privileges To Golden Gate Master User For Replication
    • Oracle GG Video 30 - Adding Parameters In The Manager Process
    • Oracle GG Video 31 - Starting The Manager Process
    • Oracle GG Video 32 - Creating A Basic Table For Replication On Both Servers
    • Oracle GG Video 33 - Connecting To GG Via Master User
    • Oracle GG Video 34 - Adding Table Level Logging and Creating An Extract Process
    • Oracle GG Video 35 - Adding A Trail File Locaton For Extract Process
    • Oracle GG Video 36 - Creating Parameter File For Extra Process
    • Oracle GG Video 37 - Creating A Datapump Process
    • Oracle GG Video 38 - Creating A Remote Trail For The Datapump Process
    • Oracle GG Video 39 - Creating A Parameter File For The Datapump Process
    • Oracle GG Video 40 - Creating The Replicat Process
    • Oracle GG Video 41 - Creating Parameters For The Replicat Process
    • Oracle GG Video 42 - Starting Golden Gate Processes on Source Server FREE PREVIEW
    • Oracle GG Video 43 - Starting Golden Gate Replicat Processes on Target Server
    • Oracle GG Video 44 - Basic Replication Unifnished
    • Oracle GG Video 45 - Performance Tuning - Fixing Replication Issues
    • Oracle GG Video 46 - Fixing Performance Issues - Handle Collission Clause
    • Oracle GG Video 47 - Issuing Delete In Golden Gate
    • Oracle GG Video 48 - Issuing Insert In Golden Gate
    • Oracle GG Video 49 - Issuing Updates In Golden Gate
    • Oracle GG Video 50 - Golden Gate Basic Command - Info All and Help Command
    • Oracle GG Video 51 - Golden Gate Command - Detail Flag
    • Oracle GG Video 52 - Golden Gate Basic Command - View Parameters
    • Oracle GG Video 53 - Golden Gate Basic Commands - Stats
    • Oracle GG Video 54 - Single Table Initial Load Part 1
    • Oracle GG Video 55 - Single Table Initial Load Part 2
    • Oracle GG Video 56 - Single Table Initial Load - Adding Initial Load Extract - Part 3
    • Oracle GG Video 57 - Single Table Load Part 4 - Performing Change Synch and Initial Load Extract
    • Oracle GG Video 58 - Performing Replication With Different Schema Definitions Part 1
    • Oracle GG Video 59 - Performing Replication With Different Schema Definitions Part 2
    • Oracle GG Video 60 - Performing Replication With Different Schema Definitions Part 3
    • Oracle GG Video 61 - Performing Replication With Different Schema Definitions Part 4
    • Oracle GG Video 62 - Performing Replication With Different Schema Definitions Part 5
    • Oracle GG Video 63 - Performing Delete Operation On Schemas With Columns
    • Performing Update Operation On Tables With Data Mapped To Diff Columns
    • Oracle GG Video 65 - Data Mapping To Columns With Different Names Part 1
    • Oracle GG Video 66 - Data Mapping To Columns With Different Names Part 2
    • Oracle GG Video 65 - Data Mapping To Columns With Different Names Part 1
    • Oracle GG Video 66 - Data Mapping To Columns With Different Names Part 2
    • Oracle GG Video 67 - Updating Data Mapped To Columns With Different Names Part 3
    • Oracle GG Video 68 - Golden Gate Filter Functions - Understanding Case Filter
    • Oracle GG Video 69 - Golden Gate Filter Functions - Understanding Eval Filter
    • Oracle GG Video 70 - Golden Gate Filter Functions - Understanding IF Filter
    • Oracle GG Video 71 - Golden Gate Filter Functions - Understanding DATENOW Filter
    • Oracle GG Video 72 - Golden Gate Filter Functions - Understanding DATEDIFF Filter
    • Oracle GG Video 73 - Golden Gate Filter Functions - Understanding COLSTAT Filter
    • Oracle GG Video 74 - Golden Gate Filter Functions - Understanding COLTEST Filter
    • Oracle GG Video 75 - Golden Gate Filter Functions - Understanding NUMSTR Filter
    • Oracle GG Video 76 - Golden Gate Filter Functions - Understanding STRNUM Filter
    • Oracle GG Video 77 - Golden Gate Filter Functions - Understanding STRUP Filter
    • Oracle GG Video 78 - Golden Gate Filter Functions - Understanding COMPUTE Filter
    • Oracle GG Video 79 - Golden Gate - Setting Up DDL Replication
    • Oracle GG Video 80 - Golden Gate - Performing DDL Transactions
    • Oracle GG Video 81 - Golden Gate - SCHEMA Replication
    • Oracle GG Video 82 - Golden Gate - DDL AND DML SCHEMA REPLICATION
    • Oracle GG Video 83 - Golden Gate - Bidirectional Replication
    • Oracle GG Video 84 - Golden Gate - Trouble Shooting Abended Processes
    • Oracle GG Video 85 - Golden Gate - Confirming Bi-Directional Replication
    • Oracle GG Video 86 - Golden Gate - Upgrade Golden Gate Software From 12.1.0.2 to 12.2.0.2 Part 1
    • Oracle GG Video 87 - Golden Gate - Upgrade Golden Gate Software From 12.1.0.2 to 12.2.0.2 Part 2
    • Oracle GG Video 88 - Golden Gate - Upgrade Golden Gate Software From 12.1.0.2 to 12.2.0.2 Part 3
    • GOLDEN GATE BI-DIRECTIONAL PART 1
    • GOLDEN GATE BI-DIRECTIONAL PART 2
    • GOLDEN GATE EXPRESSIONS
  • 8
    Oracle 12c SQL Tuning Administration
    • Oracle SQL Tuning Video 1 - Setting Up PLUSTRACE ROLE For Users
    • Oracle SQL Tuning Video 2 - Understanding Autotrace Features
    • Oracle SQL Tuning Video 3 - Displaying Exaplain Plan Only
    • Oracle SQL Tuning Video 4 - Displaying Auto trace Stats Only
    • Oracle SQL Tuning Video 5 - Displaying Autot Trace Only
    • Oracle SQL Tuning Video 6 - Reading Directly From The DBMS_XPLAN.DISPLAY Table
    • Oracle SQL Tuning Video 7 - How to Display Execution Plan From Cursor Cache
    • Oracle SQL Tuning Video 8 - How to Display Execution PlanUsing SQL ID
    • Oracle SQL Tuning Video 9 - How to Display Execution From SQLDEVELOPER
    • Oracle SQL Tuning Video 10 - Understanding The Optimizer
    • Oracle SQL Tuning Video 11 - Understanding Full Table Scans
    • Oracle SQL Tuning Video 12 - Access Path - Understanding Table Access By RowID
    • Oracle SQL Tuning Video 13 - Access Path - Understanding Sample Table Scan
    • Oracle SQL Tuning Video 14 - Access Path - Understanding Index Unique Scan
    • Oracle SQL Tuning Video 15 - Access Path - Understanding Index Full Scan
    • Oracle SQL Tuning Video 16 - Access Path - Understanding Index Fast Full Scan
    • Oracle SQL Tuning Video 17 - Access Path - Understanding Index Skip Scan
    • Oracle SQL Tuning Video 18 - Access Path - Understanding Index Join Scan
    • Oracle SQL Tuning Video 19 - Access Path - Understanding Bitmap Index Single Value
    • Oracle SQL Tuning Video 20 - Access Path - Understanding Bitmap Index Range Scan
    • Oracle SQL Tuning Video 21 - Access Path - Understanding Cluster Scan
    • Oracle SQL Tuning Video 22 - Access Path - Understanding Hash Scan
    • Oracle SQL Tuning Video 23 - Join Methods - Understanding Nested Loops
    • Oracle SQL Tuning Video 24 - Join Methods - Understanding Sort Merge Joins
    • Oracle SQL Tuning Video 25 - Join Methods - Understanding Cartesian Joins
    • Oracle SQL Tuning Video 26 - Join Methods - Understanding Hash Joins
    • Oracle SQL Tuning Video 27 - Join Types - Understanding Inner (Simple) Joins
    • Oracle SQL Tuning Video 28 - Join Types - Understanding Non-Equity Inner Joins
    • Oracle SQL Tuning Video 29 - Join Types - Understanding Left Outer Joins
    • Oracle SQL Tuning Video 30 - Join Types - Understanding Right Outer Joins
    • Oracle SQL Tuning Video 31 - Join Types - Understanding Full Outer Joins
    • Oracle SQL Tuning Video 32 - Join Types - Understanding SORT MERGE Joing part 2
    • Oracle SQL Tuning Video 33 - Understanding How To Influence The Optimizer
    • Oracle SQL Tuning Video 34 - Understanding Optimizer Goals
    • Oracle SQL Tuning Video 35 - Influencing The Optimizer - Access Path
    • Oracle SQL Tuning Video 36 - Influencing The Optimizer - Access Path (INDEX)
    • Oracle SQL Tuning Video 37 - Influencing The Optimizer - Access Path (INDEX FFS)
    • Oracle SQL Tuning Video 38 - Influencing The Optimizer - Access Path (JOIN ORDER)
    • Oracle SQL Tuning Video 39 - Influencing The Optimizer - Access Path (LEADING)
    • Oracle SQL Tuning Video 40 - Influencing The Optimizer - Access Path (NESTED LOOP)
    • Oracle SQL Tuning Video 41 - Influencing The Optimizer - Access Path (HASH JOIN)
    • Oracle SQL Tuning Video 42 - Influencing The Optimizer - Access Path (MERGE JOIN)
    • Oracle SQL Tuning Video 43 - Optimizer Statistics - Analyzing A Table
    • Oracle SQL Tuning Video 44 - Optimizer Statistics - Importance Of Gathering Table Statistics
    • Oracle SQL Tuning Video 45 - Optimizer Statistics - Querying Index Statistics
    • Oracle SQL Tuning Video 46 - Optimizer Statistics - Understanding Clustering Factor
    • Oracle SQL Tuning Video 47 - Optimizer Statistics - Understanding Clustering Factor part 2
    • Oracle SQL Tuning Video 48 - Column Statistics - Understanding Histograms
    • Oracle SQL Tuning Video 49 - Column Statistics - Purpose of Histograms
    • Oracle SQL Tuning Video 50 - Column Statistics - Understanding The Types of Histograms
    • Oracle SQL Tuning Video 51 - Column Statistics - Creating A Frequency Histogram
    • Oracle SQL Tuning Video 52 - Column Statistics - Creating A TOP Frequency Histogram
    • Oracle SQL Tuning Video 53 - Column Statistics - Creating A Height Balanced Histogram
    • Oracle SQL Tuning Video 54 - Column Statistics - Creating A Hybrid Histogram
    • Oracle SQL Tuning Video 55 - Optimizer Statistics - Refreshing Table Statistics
    • Oracle SQL Tuning Video 56 - Optimizer Statistics - Refreshing Schema Statistics
    • Oracle SQL Tuning Video 57 - Optimizer Statistics - Refreshing Table and Index Statistics
    • Oracle SQL Tuning Video 58 - Optimizer Statistics - Refreshing Database Statistics
    • Oracle SQL Tuning Video 59 - Undestanding The Difference Between Autotrace and Explain Plan
    • Oracle SQL Tuning Video 60 - Verifying That An Execution Plan Was Used
    • Oracle SQL Tuning Video 61 - Reading An Execution Plan
    • Oracle SQL Tuning Video 62 - Reading An Execution Plan pt 2
    • Oracle SQL Tuning Video 63 - Reading An Execution Plan pt 3
    • Optimizer Access Paths Script
    • Optimizer Join Methods
  • 9
    Oracle 12c PLSQL Introductory Course
    • Classroom Lecture 1 - Introduction to PL/SQL
    • Classroom Lecture 2 - Difference btwn SQL AND PL/SQL
    • Classroom Lecture 3 - Anonymous Blocks
    • Classroom Lecture 4 Anonymous block
    • Classroom Lecture 4 Rules of anonymous Block
    • Classroom Lecture 5 - DBMS OUTPUT PUT LINE
    • Classroom Lecture 6 - Understanding Variables
    • Classroom Lecture 7 -- Making Comments
    • Classroom Lecture 8
    • Classroom Lecture 8 - Global and Local Variable
    • Classroom Lecture 9- IF THEN ELSIF
    • Classroom Lecture 10- IF THEN ELSE
    • Classroom Lecture 11- IF THEN ELSE
    • Classroom Lecture 12- What is WHILE Loop
    • Classroom Lecture 13 - What is FOR Loop
    • Classroom Lecture 14 - Fetching Data From the Database
    • Classroom Lecture 15- What is %TYPE
    • Classroom Lecture 16 - CASE
    • Classroom Lecture 17- Datatypes
    • Classroom Lecture 18 - Handling Literals
    • Classroom Lecture 19 - Bind Variable
    • Classroom Lecture 20 - Nested Blocks
    • Classroom Lecture 21 - Nested Blocks p2
    • Classroom Lecture 22 - Petting It Together
    • Classroom Lecture 23 - Cursors
    • Classroom Lecture 24 - Cursor Attributes
    • Classroom Lecture 25 - Composite Datatype
    • Classroom Lecture 26 - UPDATE SET ROW
    • Classroom Lecture 27 - Index by Table
    • Classroom Lecture 28 - Nested Tables
    • Classroom Lecture 29 - Nested Tables Extended
    • Classroom Lecture 30 - Index by Table of Record
    • Classroom Lecture 31 - Associative Array
    • Classroom Lecture 32 - Stored Procedure Syntax
    • Classroom Lecture 33 - Creating a Stored Procedure
    • Classroom Lecture 34 - IN parameters
    • Classroom Lecture 35 - Out Parameters
    • Classroom Lecture 36 - Calling a Stored Procedure
    • Classroom Lecture 37- IN OUT PARAMETERS
    • Classroom Lecture 38 - Adding Exceptions to functions
    • Classroom Lecture 39 - What is a package
    • Classroom Lecture 40 - Creating a package specification
    • Classroom Lecture 41 - How to create a package body
    • Oracle PLSQL Video 1- Installing 12c Oracle Database
    • Oracle PLSQL Video 2- Launching SQL Developer For 12c Oracle Database
    • Oracle PLSQL Video 3 - Numbering Your SQL Worksheet
    • Oracle PLSQL Video 4 - Highlighting Comments In Your SQL Worksheet
    • Oracle PLSQL Video 5 - Block Structure Fundamentals
    • Oracle PLSQL Lesson 6 - Turning On Server Output
    • Oracle PLSQL Lesson 7 - Variable Basics
    • Oracle PLSQL Lesson 8 - Variable Basics Pt 2
    • Oracle PLSQL Lesson 9 - Variable Naming Rules
    • Oracle PLSQL Lesson 10 - Datatypes
    • Oracle PLSQL Lesson 11 - Constants
    • Oracle PLSQL Lesson 12 - Dataypes contd
    • Oracle PLSQL Lesson 13 - Constants and Variables Combined
    • Oracle PLSQL Lesson 14 - TYPE attribute
    • Oracle PLSQL Lesson 15 - ROWTYPE attribute
    • Oracle PLSQL Lesson 16 - ROWTYPE attribute contd
    • Oracle PLSQL Lesson 17 -TYPE.. Table
    • Oracle PLSQL Lesson 18 - Understanding Records
    • Oracle PLSQL Lesson 19 - Creating Table Based Records
    • Oracle PLSQL Lesson 20 - Creating Table Based Records Part 2
    • Oracle PLSQL Lesson 21 - Creating A Cursor Based Record
    • Oracle PLSQL Lesson 22 - Creating User Defined Records
    • Oracle PLSQL Lesson 23 - User Defined TYPE.. Record
    • Oracle PLSQL Lesson 20 - Concatenating Variables
    • Oracle PLSQL Lesson 21 - Handling String Literals (')
    • Oracle PLSQL Lesson 22 - Handling String Literals (') CONTD
    • Oracle PLSQL Lesson 26 - IF THEN ELSIF
    • Oracle PLSQL Lesson 26 - IF THEN ELSIF
    • Oracle PLSQL Lesson 18 -TYPE.. Record
    • Oracle PLSQL Lesson 24 - IF THEN ELSE basics
    • Oracle PLSQL Lesson 23 - IF THEN basics
    • Oracle PLSQL Lesson 25 - IF THEN ELSE Basics part 2
    • Oracle PLSQL Lesson 27 - Calculating With Numberic Variables
    • Oracle PLSQL Lesson 29 - Bolean Datatype
    • Oracle PLSQL Lesson 28 - Date Variables
    • Oracle PLSQL Lesson 30 - Using Comparison Operators
    • Oracle PLSQL Lesson 26 - IF THEN ELSIF
    • Oracle PLSQL Lesson 36 - Using Comparison Operators with Records
    • Oracle PLSQL Lesson 37 - Using DML's With PLSQL
    • Oracle PLSQL Lesson 38 - Using DML's in PLSQL Script
    • Oracle PLSQL Lesson 39 - Creating Sequences
    • Oracle PLSQL Lesson 40 - GOTO and Labels
    • Oracle PLSQL Lesson 41 - For Loops Basics
    • Oracle PLSQL Lesson 42 - Reverse Loops Basics
    • Oracle PLSQL Lesson 43 - For Loops Basics part 2
    • Oracle PLSQL Lesson 44 - EXIT WHEN .. LOOP
    • Oracle PLSQL Lesson 45 - WHILE LOOP
    • Oracle PLSQL Lesson 46 - CASE Statement
    • Oracle PLSQL Lesson 46 - CASE STATEMENTS
    • Oracle PLSQL Lesson 47 - Basic CASE STATEMENT part 2
    • Oracle PLSQL Lesson 48 - Creating A Basic Stored Procedure
    • Oracle PLSQL Lesson 49 - INPUT Parameters In Stored Procedures
    • Oracle PLSQL Lesson 50 - Creating A Basic Stored Procedure part 2
    • Oracle PLSQL Lesson 51 - Creating Static Stored Procedures
    • Oracle PLSQL Lesson 52 - Undestanding When To Use Variables in Stored Procedures
    • Oracle PLSQL Lesson 53 - Creating Stored Procedures with OUTPUT Parameters
    • Oracle PLSQL Lesson 54 - FUNCTIONS Basics
    • Oracle PLSQL Lesson 55 - Creating Stored Procedures Via SQL Developer Pane
    • Oracle PLSQL Lesson 56 - Understanding Triggers
    • Oracle PLSQL Lesson 57 - Creating A Basic Trigger
    • Oracle PLSQL Lesson 58 - Statement Level Triggers
    • Oracle PLSQL Lesson 59 - BEFORE EVENT Triggers
    • Oracle PLSQL Lesson 60 - Passing New OLD parameters
  • 10
    POSTGRES Administration
    • Installing Postgresql
    • Getting the status of your postgres session
    • How to clear your screen
    • How to describe your table
    • How to get a list of all the schemas in the database
    • How to get a list of tables in your database
    • How to log into the database
    • How to quit a session
    • How to switch databases
    • Understanding difference btwn users and schemas
    • How to re-execute your last command
    • Adding data into a table from an outside source
    • Set autocommit off
    • Create a database
    • Dropping a database
    • Another way to create a database from the OS
    • Another way to drop a database from the OS
    • How to create a user from the OS
    • Granting super user privileges to a new user
    • How to create a new user with super user privileges
    • How to revoke public access to a database from the public
    • Creating and dropping a schema
    • How to create a user from the OS Interactively
    • Grant a user the ability to connect to a database
    • Understanding the Postgresql Home vs Oracle DB Home
    • Understanding the Postgresql Auto Conf
    • Understanding Postgres Configuration Files
    • Understanding the pg identity conf file
    • Understanding the pg hba conf file
    • UNDERSTANDING PG CATALOGS
    • How to reset parameter settings back to default
    • How to view your parameter settings in the Postgresql.conf file
    • Creating tables
    • Creating tables with constraints
    • Performing DML's on tables
    • Understanding Table Inheritance
    • Creating a copy of a table
    • Creating Tablesapces
    • Moving tables from one tablesapce to another
    • Performing a Logical Backup
    • Performing a Logical Backup of the cluster
    • Compressing a Logical backup
    • Restoring a DB
    • Restoring a table from a Logical Backup
    • Performing an offline backup
    • Enabling Archive log mode
    • Performing an online backup
    • Performing an online backup of cluster with pg basebackup
    • Updating optimizer statistics via analyze command
    • Understandin bloating and data fragmentation
    • Difference btwn VACCUM and VACCUM FULL
    • Understanding MVCC and AUTO Vaccum
    • Difference btwn DML, Vaccum and Vaccum full
    • How to re-index a bloated index
    • How to adjust the analyze setting in the pg_setting table
    • Creating a clustered table based on an index
    • How to connect to PGAdmin4 user interface
    • How to Uninstall the Postgresql
    • Understanding the Postgresql CONF file vs SPFILE
  • 11
    AWS Solutions Architect Advanced
    • Logging Into AWS Console
    • Signing Up For A New AWS Console
    • Getting Familiar With AWS Console
    • Identify Access Management Initial Setup
    • Creating Billing Alarms
    • Creating AWS Organizations
    • Grant Access To Users In A Different Account
    • Cross Region Replication
    • Creating An S3 Bucket
    • Steps To Deleting An S3 Bucket
    • Steps To Uploading Files Into An S3 Bucket
    • Granting Permission on S3 Bucket Objects
    • Granting Permission on S3 Bucket Objects Part 2
    • Granting Permission on S3 Bucket Objects Part 3
    • Creating Lifecycle Rules
    • Understanding Bucket Versioning
    • Enabling Bucket Versioning
    • Enabling Bucket Versioning
    • Understanding the Unique ID for Bucket Versioning
    • Bucket Versioning- Delete A File and Updating Storage Class
    • Encrypting Your Bucket and Files
    • Creating Users In The AWS Console
    • How To Log In As A New IAM User
    • Delete An IAM User Via AWS Console
    • How To Download The csv file After Creating Users
    • Setting Up Environmental Variables
    • How to Email A New User Account Credentials
    • Installing AWS Command Line Interface
    • Configuring and Completing AWI CLI
    • Setting Up Environmental Variables
    • AWS CLI Man Page Basics
    • AWS CLI Command Basics - Using Different Text Outputs
    • AWS CLI Command Basics - Using the Help Command
    • Creating and Using a Key Pair
    • Creating and Launching a New Instance
    • Creating a New Key Pair Using AWS CLI
    • Deleting an EC2 Instance Using AWS CLI
    • Creating an S3 Bucket Using AWS CLI
    • Creating an S3 Bucket In A Different Region Using AWS CLI
    • Copying a File Into an S3 Bucket
    • Moving a File Into an S3 Bucket
    • Moving a File From an S3 Bucket To Local Storage
    • Synchronizing a File From a Local Storage To S3 Bucket
    • Synchronizing a File From a Local Storage To A Subfolder In an S3 Bucket
    • S3 Transfer Acceleration
    • Creating Cloud Front Distribution
    • Creating A Static Website
    • Removing a File From an S3 Bucket Using AWS CLI
    • Creating A Lifecycle Policy For Objects In a Bucket
    • Creating A Lifecycle Policy to Permanently Delete Objects in A Bucket
    • Creating Pre-Signed URLs
    • Creating Pre-signed URLs With 60 Sec Expiration
    • Creating A Group
    • Creating A User And Assigning User To A Group
    • Logging In Via CLI With an IAM User Credentials
    • How To Replicate A Bucket From One Region To Another
    • How To Create A Bucket Policy
    • How To Create A Bucket Policy
    • How To Test A Bucket Policy
    • How To Delete A Bucket Policy
    • Configuring MFA Delete For S3 Buckets
    • Configuring MFA Delete For S3 Buckets part 2
    • Understanding IAM User Roles
    • Creating Restrictive Policies
    • Creating A Role
    • Attaching A Role To An Instance
    • Connecting To An Instance Via SSH
    • Creating A Custom VPC
    • Creating Custom Subnets
    • Creating Custom Route Tables
    • Creating Custom Internet Gateways
    • Connecting Internet Gateways To Subnet Automatically
    • Creating Instances Inside Subnets
    • Connecting To Public EC2s
    • Attempting To Connect To Private EC2s
    • Connecting To Private EC2s Via Public Ec2
    • Connecting To An EC2 Instance Remotely Part 2
    • Creating A NAT Gateway
    • Creating An EC2 Instance And Apache Web Page
    • Navigating Your EC2 Instance
    • Terminating Your EC2 Instance
    • Creating EBS Volumes
    • Creating New Snapshots and AMI's From An EBS Block Storage
    • Encrypting An EC2 Instance After Creation
    • Configuring EC2 Hybernation
    • Configuring CloudWatch For More Frequent Updates
    • AWS CLI - Launching An EC2 Instance From Scratch
    • AWS CLI - Creating New Tags For An EC2 Instance
    • AWS CLI - Searching For Instances By Instance Type
    • AWS CLI - Searching For Instances By AMI Type
    • AWS CLI - Stopping An EC2 Instance
    • AWS CLI - Terminating An EC2 Instance
    • Creating IAM Roles To Connect To An EC2 Instance
    • Using The Curl Command To Get Meta-Data Of An EC2 Instance
    • Creating Boot Strap Scripts For Your EC2 Instance
    • Creating An EFS File System For A Cluster of EC2 Instances
    • Creating An EFS File System For A Cluster of EC2 Instances p2
    • Creating And Installing An Oracle Database Instance
    • Fixing Connection Issues In An Oracle Database Instance
    • Modifying and Deleting A Oracle Database Instance
    • Creating And Installing A MYSQL Database Instance
    • Launching An EC2 Instance For MYSQL Database
    • Connecting To RDS MYSQL Instance From EC2 Instance
    • Launching An EC2 Instance For MYSQL Database
    • Connecting To RDS MYSQL Instance From EC2 Instance
    • Creating Databases and Tables Inside a MYSQL Instance
    • Creating a Dynamo Database
    • Creating an Amazon Redshift Database
    • Amazon Redshift- Uploading Data into an S3 Bucket
    • C Amazon Redshift- Creating Tables in Query Editor
    • Creating An Aurora Cluster DB
    • Amazon Redshift- Copying Files From S3 Bucket Into Redshift DB
    • Registering a New Domain On AWS
    • Configuring A Simple Routing Policy In Route 53
    • Configuring A Weighted Routing Policy In Route 53
    • Configuring A Latency Routing Policy In Route 53
    • Configuring Health Checks For EC2 Instances
    • Configuring A Geolocation Routing Policy In Route 53
    • Configuring A Multi-Value Routing Policy In Route 53
    • Configuring An Application Load Balancer For A Static Web Page
    • Configuring An Application Load Balancer For Ans Target Groups

Course Cost