Best seller!
Best seller!
€41.65
€24.99
1z0-082: Oracle Database Administration I Certification Video Training Course
The complete solution to prepare for for your exam with 1z0-082: Oracle Database Administration I certification video training course. The 1z0-082: Oracle Database Administration I certification video training course contains a complete set of videos that will provide you with thorough knowledge to understand the key concepts. Top notch prep including Oracle 1z0-082 exam dumps, study guide & practice test questions and answers.
122 Students Enrolled
03:05:00 Hours
1z0-082: Oracle Database Administration I Certification Video Training Course Exam Curriculum
1
Introduction and foundations
14 Lectures
Time 01:31:00
2
Download & installing + Basic Linux commands
14 Lectures
Time 01:38:00
3
Database Startup,shutdown and connections
18 Lectures
Time 02:08:00
4
Helpful queries to explore Oracle DB architecture
13 Lectures
Time 01:21:00
5
Managing Database Instance
26 Lectures
Time 02:59:00
6
Creating PDBs
12 Lectures
Time 01:31:00
7
Configuring the Oracle Network Environment
11 Lectures
Time 01:39:00
8
Administering User Security
22 Lectures
Time 03:00:00
9
Creating and managing tablespaces
13 Lectures
Time 01:54:00
10
Managing Storage Space
17 Lectures
Time 02:33:00
11
Managing UNDO Data
13 Lectures
Time 01:59:00
12
Moving Data
15 Lectures
Time 03:12:00
13
Backup and Recovery Concepts
14 Lectures
Time 01:40:00
Introduction and foundations
-
11:00
1. Basic Introduction
-
0:00
2. Brief History of Oracle Database
-
5:00
3. Oracle DB editions
-
8:00
4. Database VS Database Instance
-
7:00
5. sever processes and the PGA
-
10:00
6. System Global Area Part 1
-
7:00
7. System Global Area Part 2
-
6:00
8. Background Processes
-
9:00
9. Database Files
-
5:00
10. Logical Storage Structure
-
7:00
11. Default tablespaces
-
6:00
12. Multitenant Database 12c /18c
-
6:00
13. DBA Tasks and tools
-
4:00
14. Installation Methods and OS
Download & installing + Basic Linux commands
-
5:00
1. Overview about installation steps
-
2:00
2. Downloading and installing Oracle Vbox
-
5:00
3. Downloading oracle Linux image
-
5:00
4. Creating our virtual machine for this course
-
12:00
5. Installing oracle Linux
-
7:00
6. Installing gust additions
-
3:00
7. Creating shared folder
-
10:00
8. Basic Linux commands part 1
-
5:00
9. Basic Linux commands part 2
-
10:00
10. Basic Linux commands part 3
-
11:00
11. Prerequisites for installing oracle DB 18c
-
3:00
12. Valuable information about the installation Prerequisites
-
9:00
13. OS configurations for oracle user
-
11:00
14. Downloading and installing oracle DB 18c
Database Startup,shutdown and connections
-
8:00
1. Database Startup part 1
-
7:00
2. Database Startup part 2
-
11:00
3. Shutdown database part 1
-
9:00
4. Shutdown database part 2
-
6:00
5. Understanding oracle listener and Listener.ora
-
5:00
6. Understanding service name
-
4:00
7. Understanding tnsnames.ora
-
3:00
8. How client connections work
-
7:00
9. Installing Putty and so connections
-
5:00
10. Installing winSCP and so connections
-
5:00
11. Installing Oracle SQL developer (client side)
-
4:00
12. Connecting sys user in many methods
-
7:00
13. Moving from container to pluggable
-
15:00
14. Starting and stopping the listener
-
10:00
15. Easy connect method
-
10:00
16. connecting using tnsnames
-
6:00
17. unlock the hr schema in the pluggable database
-
6:00
18. saving and runing scripts
Helpful queries to explore Oracle DB architecture
-
12:00
1. oracle data dictionary concept
-
4:00
2. Common uses VS local users part 1
-
8:00
3. Common uses VS local users part 2
-
8:00
4. Understanding Dynamic Performance Views
-
5:00
5. cdb_ & dba_ when you are inside a pluggable
-
8:00
6. query the data files
-
5:00
7. query the temps files
-
4:00
8. V$DATABASE / v$version / v$instance
-
5:00
9. V$CONTAINERS / cdb_PDBS
-
5:00
10. V$DATAFILE
-
5:00
11. cdb_tablespaces / V$TABLESPACE
-
6:00
12. v$logfile / V$CONTROLFILE
-
6:00
13. Pluggable Database Save state
Managing Database Instance
-
6:00
1. Initialization Parameters & Parameters Files
-
4:00
2. Search order for a parameter file
-
3:00
3. Uses of Initialization Parameters
-
11:00
4. Types of Initialization Parameters
-
5:00
5. About Modifying Initialization Parameters
-
8:00
6. Alter session example
-
7:00
7. v$parameter VS v$parameter2
-
8:00
8. v$system_parameter VS v$system_parameter2
-
7:00
9. example: Search order for a parameter file and creating pfile
-
3:00
10. Understanding the parameter spfile
-
10:00
11. creating non default name for pfile and startup
-
7:00
12. alter system example ( memory )
-
4:00
13. alter system example ( spfile )
-
5:00
14. alter system example ( both )
-
2:00
15. Default scope in alter statement part 1
-
9:00
16. Default scope in alter statement part 2
-
5:00
17. CONTAINER clause in alter system & Inheritance 1
-
11:00
18. CONTAINER clause in alter system & Inheritance 2
-
6:00
19. About Automatic Diagnostic Repository
-
7:00
20. The alert log Part 1
-
6:00
21. The alert log Part 2
-
9:00
22. View alert log using ADRCI
-
7:00
23. Trace files and Purging Part 1
-
15:00
24. Trace files and Purging Part 2
-
7:00
25. Enable DDL logging
-
7:00
26. V$SPPARAMETER
Creating PDBs
-
4:00
1. About creating PDBs
-
5:00
2. Creating PDB from seed part 1
-
15:00
3. Creating PDB from seed part 2
-
9:00
4. Connecting to the new PDB
-
6:00
5. Creating PDB from seed (DBCA)
-
4:00
6. Dropping pluggable using SQL
-
2:00
7. Dropping pluggable using DBCA
-
5:00
8. Cloning PDBs part 1
-
15:00
9. Cloning PDBs part 2
-
6:00
10. Unplugging and plugging in PDBs part 1
-
14:00
11. Unplugging and plugging in PDBs part 2
-
6:00
12. Unplugging and plugging in PDBs part 3
Configuring the Oracle Network Environment
-
4:00
1. Establishing a connection and session
-
11:00
2. The default listener
-
9:00
3. The default listener exercise
-
8:00
4. Using non-default port
-
8:00
5. creating dynamic listener example
-
15:00
6. creating static listener example
-
12:00
7. Oracle net configuration assistant (netca)
-
7:00
8. Oracle Net Manager (netmgr )
-
6:00
9. CREATE DATABASE LINK
-
6:00
10. CREATE DATABASE LINK example part 1
-
13:00
11. CREATE DATABASE LINK example part 2
Administering User Security
-
12:00
1. basic knowledge for controlling user access
-
8:00
2. System and objects privileges part 1
-
14:00
3. System and objects privileges part 2
-
11:00
4. Creating private roles examples
-
11:00
5. common users and common privileges
-
11:00
6. common roles
-
4:00
7. More About Users accounts
-
5:00
8. Oracle- supplied administrator accounts
-
4:00
9. Special system privileges for administrators
-
5:00
10. Oracle –supplied roles
-
13:00
11. Best practice to create user like SYS
-
6:00
12. Best practice to create pluggable admin
-
8:00
13. Role granted to another role
-
10:00
14. Understanding the role PDB_DBA (DBCA method)
-
4:00
15. system privileges with admin option
-
6:00
16. About user profile
-
7:00
17. Password Parameters
-
5:00
18. Oracle-supplied password verification functions
-
5:00
19. Resource parameters
-
13:00
20. Creating common profile example
-
5:00
21. Creating local profile example
-
13:00
22. Password verification full example
Creating and managing tablespaces
-
8:00
1. Review tablespaces basic information
-
5:00
2. How table data is stored
-
3:00
3. Database block content
-
4:00
4. About creating tablespace part 1
-
8:00
5. About creating tablespace part 2
-
4:00
6. About creating tablespace part 3
-
10:00
7. Creating new PDB for practice
-
18:00
8. Helpful queries for tablespaces
-
14:00
9. Create permanent tablespace example
-
14:00
10. managing tablespace using SQL developer wizard
-
15:00
11. Alter tablespace and datafile
-
8:00
12. Moving and Renaming Online Data Files
-
3:00
13. last tips for this chapter
Managing Storage Space
-
8:00
1. Space can be automatically managed by Oracle
-
15:00
2. Segments,Extents & blocks using SQL 1
-
6:00
3. Segments,Extents & blocks using SQL 2
-
7:00
4. Availability and Optimization of Free Space in a Data Block
-
4:00
5. Row Chaining and Migrating
-
10:00
6. Types of Segments
-
7:00
7. Controlling Deferred Segment Creation
-
8:00
8. Space-Saving Features (UNUSABLE index)
-
13:00
9. basic compression part 1
-
7:00
10. basic compression part 2
-
8:00
11. Advanced row compression
-
9:00
12. Monitoring Tablespace Space Usage
-
11:00
13. DBMS_SERVER_ALERT.SET_THRESHOLD example
-
7:00
14. Reclaiming Wasted Space
-
6:00
15. Segment Advisor
-
14:00
16. Segment Advisor and shrink exercise
-
13:00
17. Managing Resumable Space Allocation
Managing UNDO Data
-
8:00
1. Undo Data Overview
-
9:00
2. Transactions and Undo Data
-
5:00
3. Comparing Undo Data and Redo Data
-
8:00
4. Creating new pluggable for practice
-
11:00
5. CREATE UNDO TABLESPACE
-
8:00
6. Local Undo Mode Versus Shared Undo part 1
-
14:00
7. Local Undo Mode Versus Shared Undo part 2
-
6:00
8. Overview of Automatic Undo Management
-
8:00
9. About the Undo Retention Period
-
4:00
10. Categories of Undo
-
14:00
11. Flashback table and Flashback Version Query
-
8:00
12. Automatic Tuning of Undo Retention 1
-
16:00
13. Automatic Tuning of Undo Retention 2
Moving Data
-
8:00
1. SQL*Loader part 1
-
10:00
2. SQL*Loader part 2
-
17:00
3. External Tables Part 1
-
10:00
4. External Tables Part 2
-
15:00
5. Moving Data from One PDB to Another 1
-
8:00
6. Moving Data from One PDB to Another 2
-
19:00
7. Moving Data from One PDB to Another 3
-
8:00
8. Exporting schema (using user has DBA role)
-
10:00
9. SQL loader Discard file Example
-
9:00
10. Conventional Load Part 1
-
15:00
11. Conventional Load Part 2
-
13:00
12. Direct Path Load part 1
-
15:00
13. Direct Path Load part 2
-
20:00
14. SQL*Loader express mode
-
15:00
15. External table with PARTITIONS
Backup and Recovery Concepts
-
5:00
1. DBA Responsibilities
-
8:00
2. Categories of Failure
-
5:00
3. incomplete vs. complete recovery
-
6:00
4. redo logs and archived redo logs
-
4:00
5. Prerequisites of point-in-time-recovery
-
9:00
6. Oracle Backup Technologies
-
5:00
7. Enabling ARCHIVELOG mode
-
6:00
8. Configuring fast recovery area
-
4:00
9. Make free space by dropping some pluggables
-
18:00
10. Doing full backup for CDB and restoring
-
8:00
11. Doing backup for pluggable db
-
9:00
12. point-in-time recovery of the CDB
-
7:00
13. point-in-time recovery of pluggable
-
6:00
14. Deleting backup
About 1z0-082: Oracle Database Administration I Certification Video Training Course
1z0-082: Oracle Database Administration I certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.
Prepaway's 1z0-082: Oracle Database Administration I video training course for passing certification exams is the only solution which you need.
Pass Oracle 1z0-082 Exam in First Attempt Guaranteed!
Get 100% Real Exam Questions, Accurate & Verified Answers As Seen in the Real Exam!
30 Days Free Updates, Instant Download!
€36.66
1z0-082 Premium Bundle
€54.98
€91.64
- Premium File 96 Questions & Answers. Last update: Feb 24, 2021
- Training Course 202 Lectures
€91.64
€54.98
Still Not Convinced?
Download 24 Sample Questions that you WILL see in your Oracle 1z0-082 exam.
OR
Guarantee your success by buying the full version which covers the full latest pool of questions.
(96 Questions, Last Updated on Feb 24, 2021)
| Free 1z0-082 Exam Questions & Oracle 1z0-082 Dumps | ||
|---|---|---|
| Oracle.pass4sure.1z0-082.v2020-10-27.by.robyn.57q.ete |
Views: 104
Downloads: 36
|
Size: 171.53 KB
|
| Oracle.selftesttraining.1z0-082.v2020-02-28.by.zoe.54q.ete |
Views: 433
Downloads: 158
|
Size: 320.2 KB
|
Student Feedback
4.5
Good
Only Registered Members
Can View Online Video Courses
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
A confirmation link will be sent to this email address to verify your login.
Log into your Prepaway Account
Please Log In to view Online Course
Registration is free and easy - just provide your E-mail address.
Click Here to Register
