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