What is the Oracle database? How it functions? pre-requisites, oracle database, multiple non-CDB’s share nothing, oracle database 12c installation, multi-tenant architecture, non-CDB oracle system data mixed with user data, multitenant container database, pluggable database.
The Architecture of Oracle server, the key components – Oracle Instance and Oracle Database, the various file types – data files, control files, redo log files, benefits of CDB, easier management of database, support for oracle database resource manager, pluggable database (PDB), database instance, contents of CDB and pluggable DB, control files and redo log files, shared oracle supplied metadata, root container, data dictionary, creation of PDB’s, seed PDB, limit PDB
The basics of Oracle Storage structures, logical storage units like tablespaces, data blocks, extents and segments, database Schemas, Schema Objects, Operating System blocks, table statement and way to check “create table”, the instance, the CDB, containers, root containers, PDB, local user and common user, local privileges and common privileges, steps to create a container database, creating a container database using sqlplus, database configuration assistance
The Oracle Instance consists of background processes and memory structures, learn about the Oracle process and memory architecture, shared pool, redo log buffer, and buffer cache, different methods of creating PDB, steps involved in PDB, using PDB$SEED, without FILE_NAME_CONVERT, synchronization, plug a non-CDB to CDB, plug a non-CDB into CDB using DBMS_PDB, clone PDBS, plug and un-plug, plug unplugged CDB in to CDB
The Oracle background process errors can be monitored using the Trace Files and Alert Logs, learn how this can be deployed for Oracle Administration and support.
The methodology of starting a database instance, initializing parameter files, preparing for startup, serving user requests, understanding of the Server process and user process, administrative activities on PDB, new views associated with PDBS, determining which PDB you are in, four functions, opening, closing, and altering the open mode of PDBS, setting the default and temporary tables places for a PDB, using the alter system command from within a PDB, instance parameter change impact
Automatic data optimization, ILM components, ILM challenges, what is automatic data optimization, heat map and ADO, DBA heat map segment view, monitoring statistics, creating compression polices, creating storage tiering policy, preparing evolution and execution
Hands on Lab :- Automatic Data Optimization, Reduction Policies, Alter Policy
Learn about the powerful Oracle database security features, data privacy, regulatory compliance, “create user” process, altering and dropping users, generating profiles and limiting resources, auditing, activity monitoring and blocking.
Understanding of Database Schema objects, the various types available like views, tables, clusters, indexes, sequence, database links, packages and procedures, learning how data is stored in database tables, creating of temporary tables and external tables.
Resource manager. Resource manager and pluggable database, managing resource between PDBs, CDB resource plan basics:share, CDB resource plan basics:Limits, creating a CDB resource plan, creating a CDB resource plan:SQL example, enabling a CDBresource plan, managing PDB resource plan
Mastering the database Schema objects, learning Materialized View, deploying user-generated schema object for generating sequence, the balanced search tree index structure for placing and locating files, learn about data concurrency and data consistency in multi-user databases, the concepts of Locking and Deadlocks.
Study the client/server Network Environment, configuring the network, connecting to the database, the Oracle Network Environment and database link, starting up a instance, SHOUT DOWN, NOMOUNT, MOUNT, OPEN, PDB, OPEN, clone PDBS.
Understand how Oracle database ecosystem backup and recovery is deployed, the database testing, database standby, Media recovery options, backup in offline mode, CDB backup and recover, archiving challenges and solutions, in data base archiving, security and performance: audit architecture, consolidation: unique audit trail, extended audit information, data pump audit policy, new administrative privileges, new administrative privileges:SYSBACKUP, new administrative privileges:SYSDG, new administrative privileges:SYSKM
Learn the significance of Oracle Recovery Manager, how it deploys performance, management and restoration of entire databases, learn about SQL Loader, Oracle Data Pump for import and export and support for External Table.
The Oracle Data Dictionary contains information related to database privileges, objects, users, and roles, learn Dynamic Performance Table for identifying instance-level problems, get complete knowledge to work with Oracle DBA, connection access DBA, data dictionary views, after CDB creation, alert log file, provisioning new pluggable databases NOARCHIVELOG mode, media failure, flashback CDB, data dictionary views
Understanding what is database tuning, skills needed to lower response time, increase throughput for time-sensitive applications, how to optimize the storage space, deploy SQL scripts, Index Statistics and Selectivity, how to tune the database, what is a Chained Row and Lock in Oracle.
In-depth understanding of the Oracle database tuning, what is a shared pool tuning, how to improve the performance with the help of data dictionary, tuning the data dictionary, implementing the PL/SQL code and reusing the code and database buffer.
Project 1 : Tuning of the database
Industry : General
Problem Statement : how to optimize the Oracle database and perform database tuning on it.
Topics – This project is involved with working on the Oracle Database for deploying the database performance tuning which includes optimizing and homogenizing the database performance. It is associated with query tuning but also includes DBMS selection, and configuration of the database environment. There are multiple tasks that you will perform giving you a hands-on experience –
Project 2 – Building an airline ticketing website
Industry : Ecommerce
Problem Statement : How to build a website for online flight ticket booking powered by Oracle database.
Description : This project will extensively use the Oracle database administration tools and technologies for building the database system for such a website. You will access the data using the Java Database Connectivity (JDBC). You will learn about the security & monitoring features of Oracle database. You will aggregate data from multiple airline sites for the best prices, take request for flight booking from users using multiple browsers and devices & provide output as per the user query.
Project 3 – HR management powered by Oracle database
Industry : Human Resources
Problem Statement : A large multinational company wants to have a human resource database to simplify the process of employee management.
Description : This Oracle database administration project will help you manage an HR database of a large multinational powered by Oracle database system. You will ensure that every manager has data pertaining to his team readily accessible for proper management. The HR database will be connected to the finance, operations, and training departments’ database for streamlining the employee management process.
This Intellipaat Oracle DBA training will make you proficient in the end-to-end working of the Oracle Database Administration domain. You will master the Oracle DBA Architecture, the database structure, understanding the principles of database security, working with schema objects, and deploying data backup and recovery. This entire course content is in line with the requirements of clearing the Oracle Database Administrator Certified Associate Exam.
You will be working on real time Oracle DBA projects that have high relevance in the corporate world, step-by-step assignments and curriculum designed by industry experts. Upon completion of the training course you can apply for some of the best jobs in top MNCs around the world at top salaries. Intellipaat offers lifetime access to videos, course materials, 24/7 Support, and course material upgrading to latest version at no extra fees. Hence it is clearly a one-time investment.
This course is designed for clearing the Oracle Database Administrator Certified Associate Exam. The entire training course content is in line with the certification program and helps you clear the certification exam with ease and get the best jobs in the top MNCs. As part of this training you will be working on real time projects and assignments that have immense implications in the real world industry scenario thus helping you fast track your career effortlessly.
At the end of this training program there will be a quiz that perfectly reflects the type of questions asked in the certification exam and helps you score better marks in certification exam.
Intellipaat Course Completion certification will be awarded on the completion of Project work (on expert review)and upon scoring of at least 60% marks in the quiz. . Intellipaat certification is well recognized in top MNCs like Ericsson, Cisco, Cognizant, Sony, Wipro, Standard Chartered, TCS, Genpact, Tata Communication etc.
"PMI®", "PMP®" and "PMI-ACP®" are registered marks of the Project Management Institute, Inc.
The Open Group®, TOGAF® are trademarks of The Open Group.
The Swirl logoTM is a trade mark of AXELOS Limited.
ITIL® is a registered trade mark of AXELOS Limited.
PRINCE2® is a Registered Trade Mark of AXELOS Limited.
Certified ScrumMaster® (CSM) and Certified Scrum Trainer® (CST) are registered trademarks of SCRUM ALLIANCE®
Professional Scrum Master is a registered trademark of Scrum.org