Oracle 12c Database Administration
Oracle Training

Oracle 12c Database Administration

Apply to Course Now

About the Course

Oracle Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of Oracle databases across organizations today.

The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers. Oracle DBAs are also known as Database Architects in some organizations.

All the above tasks are performed with the help of a Relational Database Management System (RDBMS) and the leading and most widely used RDBMS across the world today are the Oracle Database, Microsoft SQL Server, MySQL database etc.

However, out of all the RDBMS available, Oracle Database is the most popular and widely used database in the world today.

If you are looking to build a career in database administration for Oracle, this is the course designed for you. Our experts are extremely knowledgeable and experienced in database administration across platforms and our course is built to give you practical experience on taking control of every aspect of Oracle Database Administration.


Who Should Attend

Anybody whose ambition is to build a career in Oracle Database Administration field is a good candidate for this course in general. However, if you have a fair understanding of basic SQL concepts or have knowledge of other databases and want to have in-depth knowledge about Oracle database internals and advance concepts, this is a great course for you.

If you are a data warehousing professional or an aspiring Data Architect, you are required to have a solid understanding of the database you are working on. If you are a Data Architect (or aspiring to be one) on Oracle platform, this course is for you as well.


Course Curriculum

Serial# Topic Description
1. Introduction Introduction to RDBMS and Oracle concepts and database administration concepts. Responsibilities of DBAs and basic concepts around SQL & PL/SQL.
2. Installing Oracle Database Understand pre-requisites for a successful Oracle RDBMS software installation, Installation of Oracle 11g R2 database software, Installation of Oracle 12c database software.
3. Oracle Database Configurations Oracle database creation and configurations, Creating an Oracle database using the MANUAL method, Creating an Oracle database using Database Configuration Assistant, Startup and Shutdown of Oracle databases, Components of an Oracle database and detailed architecture and more…/td>
4. Oracle Database Storage Organization Working with Oracle Tablespaces, Oracle datafiles, Control files and advance concepts. Rename datafiles in a controlfile, Understanding Redo log files and best practices, Enabling/Disabling Archivelog mode, Temporary tablespaces and temporary tablespace groups.
5. Oracle Network Concepts Oracle listener configuration (Dynamic and Static Listeners), Dynamic Service Registration and Naming Methods configuration in sqlnet.ora, Using Network Configuration Assistant, Understanding tnsnames.ora, Oracle listener administration and TNS_ADMIN environment variable, Database Links and more…
6. User Administration & Security Creating & managing database users, Setting database profile limits, Locking/Unlocking user accounts, password management, Understanding & managing privileges, Working with database roles, Database jobs & DBMS_SCHEDULER and more…
7. Database Backup & Recovery Planning for a robust Backup and Recovery Strategy, Taking database backup in offline mode (COLD BACKUP), Database backup in online mode (HOT BACKUP), Cloning a database using Cold & Hot Backup methods, Understanding RMAN method of backup, Working with RMAN in normal and compressed mode, Database backup using Recovery catalog (RMAN Catalog), Cloning a database using RMAN duplicate (11g R2 new feature: Backup based duplication), Restoring and Recovering a database and practical exercises.
8. Upgrading Oracle Database Understanding Oracle versions, Upgrading Oracle from a previous release to Oracle 12c, Upgrade from one patchset to another patchset within the same release, One-off/interim patches, Cumulative Patches, Working with Oracle Interim Patch Installer (OPATCH) and more…
9. Oracle 12c Advance Concepts Understnding non-CDB (traditional database) using Oracle 12c dbca utility, Improvements in dbca utility with 12c, Working with Oracle Enterprise Manager Database Express, Understanding Container database (CDB) and Pluggable Database (PDB), How Oracle 12c CDB, PDB instance architecture differs from older architectures, How to create a CDB database in 12c (using the multitenant feature), How to move (plug) the non-CDB database into the CDB database as a pluggable database (PDB).
10. Performance Tuning & Advance Concepts Performance issues & practical examples, V$ views and using them, Understanding database memory structures, Database wait events, UNDO management internals and sizing, TEMP space internals and sizing, Tracing database sessions using DBMS_MONITOR and DBMS_SESSION, Tkprof utility, Working with Oracle Indexes and advance concepts of Index management.


I took classes on Data Modeling and I think I was amazed by depth of knowledge I received. Highly recommend Data Modeling classes from these awesome people!

Thank you for helping me learn Big Data and Hadoop platform at the time I needed this information when I was getting ready to start my career as Big Data architect. Especially grateful for support after classes were over. Thank you!

I wanted to learn SQL and PL/SQL and took classes. This was the best investment I made in myself. Truly, self-education is the best thing to do and with help is SmartBIExperts group, it was great experience.


Have Some Questions?

We believe in offering the highest quality courses, created by industry experts who share our commitment to excellence in teaching and learning, both online and in the classrooms.  Use the form below to ask your question.

Contact Us Today

Your email address will not be published. Required fields are marked *