Lesson 1: Database Introduction And Oracle Database Architecture
o What is the Oracle database?
o How it functions? Installation of Oracle database 11g.
o The Architecture of Oracle server
o the key components – Oracle Instance and Oracle Database
o the various file types – data files
o control files
o redo log files.
Lesson 2: Oracle Storage Structures
o The basics of Oracle Storage structures
o logical storage units like tablespaces
o data blocks, extents and segments
o database Schemas
o Schema Objects
o Operating System blocks
o table statement and way to check “create table”.
Lesson 3: Memory & Process Architecture
o The Oracle Instance consists of background processes and memory structures, learn about the Oracle process and memory architecture
o shared pool
o redo log buffer
o buffer cache.
Lesson 4: Alert & Trace files
o The Oracle background process errors can be monitored using the Trace Files and Alert Logs
o learn how this can be deployed for Oracle Administration and support.
Lesson 5: Database Startup & User Requests
o The methodology of starting a database instance, initializing parameter files, preparing for startup
o serving user requests
o understanding of the Server process and user process.
Lesson 6: Database Security
o Learn about the powerful Oracle database security features, data privacy, regulatory compliance, “create user” process
o altering and dropping users
o generating profiles and limiting resources
o activity monitoring and blocking.
Lesson 7: Database Schema Objects And Deep dive into Schema Objects
o Understanding of Database Schema objects, the various types available like views, tables, clusters, indexes, sequence database links
o packages and procedures, learning how data is stored in database tables, creating of temporary tables and external tables.
o 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
o learn about data concurrency and data consistency in multi-user databases
o the concepts of Locking and Deadlocks.
Lesson 8: Oracle Network Environment
o Study the client/server Network Environment
o configuring the network
o connecting to the database
o the Oracle Network Environment and database link.
Lesson 9: Oracle Backup & Recovery And Oracle Recovery Manager (RMAN)
o Understand how Oracle database ecosystem backup and recovery is deployed
o the database testing, database standby
o Media recovery options, backup in offline mode.
o Learn the significance of Oracle Recovery Manager
o how it deploys performance
o management and restoration of entire databases, learn about SQL Loader
o Oracle Data Pump for import and export and support for External Table.
Lesson 10: Data Dictionary & Dynamic Performance Tables
o The Oracle Data Dictionary contains information related to database privileges, objects, users, and roles
o learn Dynamic Performance Table for identifying instance-level problems
o get complete knowledge to work with Oracle DBA.
Lesson 11: Database Tuning
o Introduction to database tuning
o ensuring higher throughput
o lowering response time of time-critical applications
o optimizing the storage space
o SQL scripts
o deploying Index Selectivity
o Index Statistics and Table Statistics for tuning the database
o understanding Oracle Chained Rows and Locks.
Lesson 12: Database Tuning Continued
o Deep diving into Oracle Database Tuning, shared pool tuning, improving performance using Data Dictionary
o tuning of Data Dictionary
o deploying PL/SQL code
o code reuse
o database buffer.
o Oracle is the market leader in the relational database with a 48.35% market share – Gartner
o An Oracle Database Administrator can earn $94,000 in the United States – indeed.com
o Being an Oracle Certified Professional (OCP)is crucial to work as an Oracle DBA – Oracle
o Software developers and IT professionals
o Database analysts and administrators
o SQL programmers and architects
o Project Managers
o Those aspiring for a career in Oracle DBA
o Online – Available life time
o Classroom – You can join classes in next batched for 6 months on prior notice.
o Yes, that is based on the exam conducted online/ class in our authorized center.
o Our exam patterns, coverage and criticality is similar to actual Cloudera/ Hortonworks one.
o WhatsApp - Will respond within 24 hours
o Phone call - Schedule a 15 minute phone call
o Skype - Schedule a face to face skype session
o Resume writing tip to showcase skills you have learnt in the course.
o Mock interview practice and frequently asked interview questions.
o Career guidance regarding hiring companies and open positions.