Video Course
BEST SELLER

1z0-082: Oracle Database Administration I Certification Video Training Course

Looking for studying for 1z0-082: Oracle Database Administration I certification training course. Our 1z0-082 certification video training course training course is your number one assistant. Pass with our 1z0-082: Oracle Database Administration I certification training course on the first try and become a certified professional in no time.

  • 108 Students Enrolled
  • 202 Lectures
  • 3 Hours
  • 4.5 Rating
$38.49
$34.99

Curriculum For This Course

  • Introduction and foundations

    Video Name Time
    1. Basic Introduction 11:00
    2. Brief History of Oracle Database 0:00
    3. Oracle DB editions 5:00
    4. Database VS Database Instance 8:00
    5. sever processes and the PGA 7:00
    6. System Global Area Part 1 10:00
    7. System Global Area Part 2 7:00
    8. Background Processes 6:00
    9. Database Files 9:00
    10. Logical Storage Structure 5:00
    11. Default tablespaces 7:00
    12. Multitenant Database 12c /18c 6:00
    13. DBA Tasks and tools 6:00
    14. Installation Methods and OS 4:00

  • Download & installing + Basic Linux commands

    Video Name Time
    1. Overview about installation steps 5:00
    2. Downloading and installing Oracle Vbox 2:00
    3. Downloading oracle Linux image 5:00
    4. Creating our virtual machine for this course 5:00
    5. Installing oracle Linux 12:00
    6. Installing gust additions 7:00
    7. Creating shared folder 3:00
    8. Basic Linux commands part 1 10:00
    9. Basic Linux commands part 2 5:00
    10. Basic Linux commands part 3 10:00
    11. Prerequisites for installing oracle DB 18c 11:00
    12. Valuable information about the installation Prerequisites 3:00
    13. OS configurations for oracle user 9:00
    14. Downloading and installing oracle DB 18c 11:00

  • Database Startup,shutdown and connections

    Video Name Time
    1. Database Startup part 1 8:00
    2. Database Startup part 2 7:00
    3. Shutdown database part 1 11:00
    4. Shutdown database part 2 9:00
    5. Understanding oracle listener and Listener.ora 6:00
    6. Understanding service name 5:00
    7. Understanding tnsnames.ora 4:00
    8. How client connections work 3:00
    9. Installing Putty and so connections 7:00
    10. Installing winSCP and so connections 5:00
    11. Installing Oracle SQL developer (client side) 5:00
    12. Connecting sys user in many methods 4:00
    13. Moving from container to pluggable 7:00
    14. Starting and stopping the listener 15:00
    15. Easy connect method 10:00
    16. connecting using tnsnames 10:00
    17. unlock the hr schema in the pluggable database 6:00
    18. saving and runing scripts 6:00

  • Helpful queries to explore Oracle DB architecture

    Video Name Time
    1. oracle data dictionary concept 12:00
    2. Common uses VS local users part 1 4:00
    3. Common uses VS local users part 2 8:00
    4. Understanding Dynamic Performance Views 8:00
    5. cdb_ & dba_ when you are inside a pluggable 5:00
    6. query the data files 8:00
    7. query the temps files 5:00
    8. V$DATABASE / v$version / v$instance 4:00
    9. V$CONTAINERS / cdb_PDBS 5:00
    10. V$DATAFILE 5:00
    11. cdb_tablespaces / V$TABLESPACE 5:00
    12. v$logfile / V$CONTROLFILE 6:00
    13. Pluggable Database Save state 6:00

  • Managing Database Instance

    Video Name Time
    1. Initialization Parameters & Parameters Files 6:00
    2. Search order for a parameter file 4:00
    3. Uses of Initialization Parameters 3:00
    4. Types of Initialization Parameters 11:00
    5. About Modifying Initialization Parameters 5:00
    6. Alter session example 8:00
    7. v$parameter VS v$parameter2 7:00
    8. v$system_parameter VS v$system_parameter2 8:00
    9. example: Search order for a parameter file and creating pfile 7:00
    10. Understanding the parameter spfile 3:00
    11. creating non default name for pfile and startup 10:00
    12. alter system example ( memory ) 7:00
    13. alter system example ( spfile ) 4:00
    14. alter system example ( both ) 5:00
    15. Default scope in alter statement part 1 2:00
    16. Default scope in alter statement part 2 9:00
    17. CONTAINER clause in alter system & Inheritance 1 5:00
    18. CONTAINER clause in alter system & Inheritance 2 11:00
    19. About Automatic Diagnostic Repository 6:00
    20. The alert log Part 1 7:00
    21. The alert log Part 2 6:00
    22. View alert log using ADRCI 9:00
    23. Trace files and Purging Part 1 7:00
    24. Trace files and Purging Part 2 15:00
    25. Enable DDL logging 7:00
    26. V$SPPARAMETER 7:00

  • Creating PDBs

    Video Name Time
    1. About creating PDBs 4:00
    2. Creating PDB from seed part 1 5:00
    3. Creating PDB from seed part 2 15:00
    4. Connecting to the new PDB 9:00
    5. Creating PDB from seed (DBCA) 6:00
    6. Dropping pluggable using SQL 4:00
    7. Dropping pluggable using DBCA 2:00
    8. Cloning PDBs part 1 5:00
    9. Cloning PDBs part 2 15:00
    10. Unplugging and plugging in PDBs part 1 6:00
    11. Unplugging and plugging in PDBs part 2 14:00
    12. Unplugging and plugging in PDBs part 3 6:00

  • Configuring the Oracle Network Environment

    Video Name Time
    1. Establishing a connection and session 4:00
    2. The default listener 11:00
    3. The default listener exercise 9:00
    4. Using non-default port 8:00
    5. creating dynamic listener example 8:00
    6. creating static listener example 15:00
    7. Oracle net configuration assistant (netca) 12:00
    8. Oracle Net Manager (netmgr ) 7:00
    9. CREATE DATABASE LINK 6:00
    10. CREATE DATABASE LINK example part 1 6:00
    11. CREATE DATABASE LINK example part 2 13:00

  • Administering User Security

    Video Name Time
    1. basic knowledge for controlling user access 12:00
    2. System and objects privileges part 1 8:00
    3. System and objects privileges part 2 14:00
    4. Creating private roles examples 11:00
    5. common users and common privileges 11:00
    6. common roles 11:00
    7. More About Users accounts 4:00
    8. Oracle- supplied administrator accounts 5:00
    9. Special system privileges for administrators 4:00
    10. Oracle –supplied roles 5:00
    11. Best practice to create user like SYS 13:00
    12. Best practice to create pluggable admin 6:00
    13. Role granted to another role 8:00
    14. Understanding the role PDB_DBA (DBCA method) 10:00
    15. system privileges with admin option 4:00
    16. About user profile 6:00
    17. Password Parameters 7:00
    18. Oracle-supplied password verification functions 5:00
    19. Resource parameters 5:00
    20. Creating common profile example 13:00
    21. Creating local profile example 5:00
    22. Password verification full example 13:00

  • Creating and managing tablespaces

    Video Name Time
    1. Review tablespaces basic information 8:00
    2. How table data is stored 5:00
    3. Database block content 3:00
    4. About creating tablespace part 1 4:00
    5. About creating tablespace part 2 8:00
    6. About creating tablespace part 3 4:00
    7. Creating new PDB for practice 10:00
    8. Helpful queries for tablespaces 18:00
    9. Create permanent tablespace example 14:00
    10. managing tablespace using SQL developer wizard 14:00
    11. Alter tablespace and datafile 15:00
    12. Moving and Renaming Online Data Files 8:00
    13. last tips for this chapter 3:00

  • Managing Storage Space

    Video Name Time
    1. Space can be automatically managed by Oracle 8:00
    2. Segments,Extents & blocks using SQL 1 15:00
    3. Segments,Extents & blocks using SQL 2 6:00
    4. Availability and Optimization of Free Space in a Data Block 7:00
    5. Row Chaining and Migrating 4:00
    6. Types of Segments 10:00
    7. Controlling Deferred Segment Creation 7:00
    8. Space-Saving Features (UNUSABLE index) 8:00
    9. basic compression part 1 13:00
    10. basic compression part 2 7:00
    11. Advanced row compression 8:00
    12. Monitoring Tablespace Space Usage 9:00
    13. DBMS_SERVER_ALERT.SET_THRESHOLD example 11:00
    14. Reclaiming Wasted Space 7:00
    15. Segment Advisor 6:00
    16. Segment Advisor and shrink exercise 14:00
    17. Managing Resumable Space Allocation 13:00

  • Managing UNDO Data

    Video Name Time
    1. Undo Data Overview 8:00
    2. Transactions and Undo Data 9:00
    3. Comparing Undo Data and Redo Data 5:00
    4. Creating new pluggable for practice 8:00
    5. CREATE UNDO TABLESPACE 11:00
    6. Local Undo Mode Versus Shared Undo part 1 8:00
    7. Local Undo Mode Versus Shared Undo part 2 14:00
    8. Overview of Automatic Undo Management 6:00
    9. About the Undo Retention Period 8:00
    10. Categories of Undo 4:00
    11. Flashback table and Flashback Version Query 14:00
    12. Automatic Tuning of Undo Retention 1 8:00
    13. Automatic Tuning of Undo Retention 2 16:00

  • Moving Data

    Video Name Time
    1. SQL*Loader part 1 8:00
    2. SQL*Loader part 2 10:00
    3. External Tables Part 1 17:00
    4. External Tables Part 2 10:00
    5. Moving Data from One PDB to Another 1 15:00
    6. Moving Data from One PDB to Another 2 8:00
    7. Moving Data from One PDB to Another 3 19:00
    8. Exporting schema (using user has DBA role) 8:00
    9. SQL loader Discard file Example 10:00
    10. Conventional Load Part 1 9:00
    11. Conventional Load Part 2 15:00
    12. Direct Path Load part 1 13:00
    13. Direct Path Load part 2 15:00
    14. SQL*Loader express mode 20:00
    15. External table with PARTITIONS 15:00

  • Backup and Recovery Concepts

    Video Name Time
    1. DBA Responsibilities 5:00
    2. Categories of Failure 8:00
    3. incomplete vs. complete recovery 5:00
    4. redo logs and archived redo logs 6:00
    5. Prerequisites of point-in-time-recovery 4:00
    6. Oracle Backup Technologies 9:00
    7. Enabling ARCHIVELOG mode 5:00
    8. Configuring fast recovery area 6:00
    9. Make free space by dropping some pluggables 4:00
    10. Doing full backup for CDB and restoring 18:00
    11. Doing backup for pluggable db 8:00
    12. point-in-time recovery of the CDB 9:00
    13. point-in-time recovery of pluggable 7:00
    14. Deleting backup 6:00

Student Feedback

  1. 48%
  2. 52%
  3. 0%
  4. 0%
  5. 0%

Good Overall Rating

4.5

Add Comment

Rate Course *

Secure Code
Please enter security code exactly as shown

Log into your CertBolt Account

* Only Registered Members can Download Exam Questions & Answers

Create New CertBolt Account

or Login