MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


Take me to MyPage
I'm not curious

IT Career Development Platform

IT Career Development, Progression, Coaching, Jobs | MyTechLogy
You are here: Home / IT Courses / IT Course View

Oracle DBA Training

Intellipaat

Course Summary

Enroll today for Oracle DBA Training and Certification Course and master the concepts of Database Administration.


  • +

    Course Syllabus

    Oracle DBA Course Content

    Database Introduction
    What is the Oracle database? How it functions? Installation of Oracle database 11g.
    Oracle Database Architecture
    The Architecture of Oracle server, the key components – Oracle Instance and Oracle Database, the various file types – data files, control files, redo log files.
    Oracle Storage Structures
    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”.
    Memory & Process Architecture
    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.
    Alert & Trace files
    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.
    Database Startup & User Requests
    The methodology of starting a database instance, initializing parameter files, preparing for startup, serving user requests, understanding of the Server process and user process.
    Database Security
    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.
    Database Schema Objects
    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.
    Deep dive into Schema Objects
    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.
    Oracle Network Environment
    Study the client/server Network Environment, configuring the network, connecting to the database, the Oracle Network Environment and database link.
    Oracle Backup & Recovery
    Understand how Oracle database ecosystem backup and recovery is deployed, the database testing, database standby, Media recovery options, backup in offline mode.
    Oracle Recovery Manager (RMAN)
    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.
    Data Dictionary & Dynamic Performance Tables
    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.
    Database Tuning
    Introduction to database tuning, ensuring higher throughput, lowering response time of time-critical applications, optimizing the storage space, SQL scripts, deploying Index Selectivity, Index Statistics and Table Statistics for tuning the database, understanding Oracle Chained Rows and Locks.
    Database Tuning Continued
    Deep diving into Oracle Database Tuning, shared pool tuning, improving performance using Data Dictionary, tuning of Data Dictionary, deploying PL/SQL code, code reuse, database buffer.
    Oracle DBA Project
    Project – Database TuningTopics – 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. Some of the tasks that you will perform are–
    • Space usage monitoring
    • SQL scripts monitoring
    • Database & SQL tuning
    • Table & Index Statistics
    • Chained Rows & Locks

Course Fee:
USD 132

Course Type:

 Self-Study

Course Status:

 Active

Workload:

 1 - 4 hours / week

This course is listed under Development & Implementations , Data & Information Management , Networks & IT Infrastructure , IT Security & Architecture , Project & Service Management , Quality Assurance & Testing and Server & Storage Management Community

Attended this course?

Best Practices of MySQL Encryption
Are you new to MyTechLogy?
Click here to learn more

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url