Oracle 12C database Administration - Oracle dba

Name: Oracle 12C database Administration - Oracle dba
Rating: 3.5 (29 reviews)

Oracle 12C Administration | Oracle database Administration for Oracle DBA

Created byAnkush Thavali

Last updated 12/2018

English

What you'll learn

Oracle 12C Multi-tenant architecture
Oracle DBA
Oracle 12c database management
Oracle 12c Database Administrator

Course content

5 sections • 26 lectures • 3h 50m total length

Create pluggable database by a plug-in operation15:05
Create pluggable database using seed6:54
Create pluggable database using DBCA9:04
Create Pluggable database using existing pluggable database9:06

How to Change Sys & System password in Oracle 12C5:12
How to start,stop,connect to pluggable and container database9:31
Learn how to start and stop Oracle 12c databases, connect to container and pluggable databases, and perform essential administration tasks.
How to connect to pluggable database7:33
How to Migrate Non-container database to pluggable database -PART II37:16
How to Migrate Non-Container Database to Pluggable Database-PART I9:30
Learn how to migrate a non-container database to a pluggable database in Oracle 12c, including shutdown, compatibility checks, manifest creation, and data transfer steps.
Drop pluggable Database using SQL command.4:02
Learn how to drop a pluggable database in Oracle 12c using SQL*Plus and the DBCA utility, including connecting to the container database, verifying PDB status, and safely removing data files.

Datapump Introduction4:47
Table Export using Datapump13:15
Import Deleted table using IMPDP datapump6:15
Export Schema dump with EXPDP7:04
Import Schema dump using datapump utility8:34
Full database export9:06
Include and Exclude parameter in Datapump10:33
Parameter File Contents Written to Log File - Logtime parameter5:48
Demonstrates writing export details to both log file and console using the logtime parameter, capturing object names and time stamps for each exported database object.
Content Parameter9:57
Query parameter6:54
Explore how to query specific data from a table with where conditions using the query operator, and export either a full database or a single table.

Requirements

Students shoud have basic knowledge of SQL and Unix .
Laptop with Minimum 4GB RAM

Description

Oracle 12C is the latest version provided by the oracle which support multi tenant architecture. I have tried to cover all topic and again new topics will be uploaded by daily and weekly basis.

All examples are real time scenario.

simulated the issue first and then provided the solution.

Simple language

Provide real time example to understand the concept

Reach me vie email for topics

Who this course is for:

Beginner Oracle DBA
Students who want to start there carier as Oracle DBA
Emplyee who wants to Jump to Oracle DBA carier

Oracle 12C database Administration - Oracle dba

What you'll learn

Explore related topics

Course content

Installation of Pluggable database4 lectures • 40min

Pluggable database administration6 lectures • 1hr 13min

RMAN Backups5 lectures • 27min

User creation in oracle 12c1 lecture • 8min

Export Import Datapump Operation10 lectures • 1hr 22min

Requirements

Description

Who this course is for: