Oracle Database Administration I Video Course

1z0-082: Oracle Database Administration I

Your Oracle 1z0-082 exam is just around the corner, right? So, it's high time to find an effective preparation tool! Our training course is what you really need! This is a series of videos led by the experienced IT instructors who will provide you with a detailed overview of the 1z0-082 certification test. Ace your Oracle 1z0-082 at the first attempt and obtain the Oracle Database Administration I credential with ease.

# of Students
106
# of Lectures
202
Course Length
3 h
Course Rating
4.5
Price $32.99
Today $29.99

Curriculum for 1z0-082 Video 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
  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
  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
  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
  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
  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
  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
  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
  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
  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
  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
  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
  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

5 Stars
4 Stars
3 Stars
2 Stars
1 Star
4.5
Rating: 4.5
Overall Rating: Good.

Similar Courses

Only Registered Members can View Training Courses

Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.

  • Trusted by 1.2M IT Certification Candidates Every Month
  • Hundreds Hours of Videos
  • Instant download After Registration

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

1200+ IT Certification Exams available: Get a free sample of any exam right now!
Try Free Demo

Try Free Demo

  • ABA
  • ACAMS
  • ACFE
  • ACI
  • ACSM
  • Adobe
  • AHIMA
  • AHIP
  • AHLEI
  • AICPA
  • AIWMI
  • Alfresco
  • AMA
  • Amazon
  • AndroidATC
  • APBM
  • API
  • APICS
  • Apple
  • Arista
  • Aruba
  • ASIS
  • ASQ
  • Atlassian
  • Autodesk
  • Avaya
  • Axis Communications
  • BACB
  • BCS
  • BICSI
  • Blockchain
  • Blue Coat
  • Blue Prism
  • C++ Institute
  • CA Technologies
  • Checkpoint
  • CIMA
  • Cisco
  • Citrix
  • CIW
  • Cloudera
  • CNCF
  • CompTIA
  • CSA
  • CWNP
  • CyberArc
  • Dell
  • DMI
  • DSCI
  • EMC
  • Esri
  • Exin
  • Extreme Networks
  • F5
  • FileMaker
  • FINRA
  • Fortinet
  • GAQM
  • GARP
  • Genesys
  • GIAC
  • Google
  • Guidance Software
  • H3C
  • HFMA
  • HIPAA
  • Hitachi
  • HP
  • HRCI
  • Huawei
  • IAPP
  • IBM
  • IFPUG
  • IIA
  • IIBA
  • Informatica
  • Isaca
  • iSAQB
  • ISC
  • iSQI
  • ISTQB
  • ITIL
  • Juniper
  • Lenovo
  • Linux Foundation
  • Logical Operations
  • LPI
  • Magento
  • Marketo
  • McAfee
  • Microsoft
  • Mulesoft
  • NACVA
  • NCMA
  • Network Appliance
  • NI
  • Nokia
  • Novell
  • Nuage Networks
  • Nutanix
  • OMG
  • Oracle
  • Palo Alto Networks
  • Pegasystems
  • PEOPLECERT
  • PMI
  • PRINCE2
  • Python Institute
  • QlikView
  • RedHat
  • Riverbed
  • RSA
  • Salesforce
  • SANS
  • SAP
  • SAS Institute
  • Scrum
  • SDI
  • ServiceNow
  • Six Sigma
  • SNIA
  • SOA
  • Software Certifications
  • SolarWinds
  • Splunk
  • SpringSource
  • Symantec
  • Teradata
  • Test Prep
  • The Open Group
  • Tibco
  • Unity Certification
  • VCE
  • Veeam
  • Veritas
  • Vmedu
  • VMware
  • WatchGuard
  • WorldatWork
  • Zend
Next Step
Next Step

Try Free Demo

  • Oracle
Next Step
Next Step

Summer Sale! Get 25% Discount on All Your Purchases!

Passguide Products

Enter Your Email Address to Receive Your 25%
OFF
Discount Code Plus... Our Exclusive Weekly Deals

* We value your privacy. We will not rent or sell your email address