| |
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 |
