Curriculum For This Course

Introduction and foundations

14Lectures

Time 01:31:00

Download & installing + Basic Linux commands

14Lectures

Time 01:38:00

Database Startup,shutdown and connections

18Lectures

Time 02:08:00

Helpful queries to explore Oracle DB architecture

13Lectures

Time 01:21:00

Managing Database Instance

26Lectures

Time 02:59:00

Creating PDBs

12Lectures

Time 01:31:00

Configuring the Oracle Network Environment

11Lectures

Time 01:39:00

Administering User Security

22Lectures

Time 03:00:00

Creating and managing tablespaces

13Lectures

Time 01:54:00

Managing Storage Space

17Lectures

Time 02:33:00

Managing UNDO Data

13Lectures

Time 01:59:00

Moving Data

15Lectures

Time 03:12:00

Backup and Recovery Concepts

14Lectures

Time 01:40:00

Introduction and foundations
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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

Pass Oracle 1z0-082 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers!
30 Days Free Updates, Instant Download!

$6.50

$58.49 ~~$64.99~~

1z0-082 Premium Bundle

Premium File 178 Questions & Answers. Last update: Jan 14, 2025
Training Course 202 Lectures

Still Not Convinced?

Download 24 Sample Questions that you WILL see in your Oracle 1z0-082 exam.

Download 24 Free Questions

Guarantee your success by buying the full version which covers the full latest pool of questions.
(178 Questions, Last Updated on Jan 14, 2025)

Free 1z0-082 Exam Questions & Oracle 1z0-082 Dumps
Oracle.passit4sure.1z0-082.v2024-09-28.by.noah.57q.ete	Size: 171.53 KB Downloads: 120
Oracle.passit4sure.1z0-082.v2020-02-28.by.edward.54q.ete	Size: 320.2 KB Downloads: 1800

Student Feedback

4.4

Good

44%

56 %

Add Comments

Name:^*

E-mail:^*

Comment:^* Comment will be moderated and published within 1-4 hours

Verification:^*

Type the characters from the picture.

Rate Course:^*

Only Premium Members Can Access This Section!

Get Premium Membership

$0.00

Early Access to Exam Updates
Special Premium Discounted Offers On All Future Purchases
Access Over 300 Video Courses Special Section in Member Area
Valid for 12 Months!

Only Registered Members
Can View Online Video Courses

Please fill out your email address below in order to view Online 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

Email Address:

A confirmation link will be sent to this email address to verify your login. Already Member? Click to Login

Log into your Prepaway Account

Please Log In to view Online Course

E-mail:^*

Password:^*

Registration is free and easy - just provide your E-mail address.
Click Here to Register

Pass IT Certication
Exams Guaranteed!

1z0-082: Oracle Database Administration I

Curriculum For This Course

Pass Oracle 1z0-082 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers!
30 Days Free Updates, Instant Download!

1z0-082 Premium Bundle

Free 1z0-082 Exam Questions & Oracle 1z0-082 Dumps

Student Feedback

Add Comments

Pass IT Certication Exams Guaranteed!

1z0-082: Oracle Database Administration I

Curriculum For This Course

Pass Oracle 1z0-082 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers!30 Days Free Updates, Instant Download!

1z0-082 Premium Bundle

Free 1z0-082 Exam Questions & Oracle 1z0-082 Dumps

Student Feedback

Add Comments

Get Premium Membership

Pass IT Certication
Exams Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers!
30 Days Free Updates, Instant Download!