Database Architect Training

 >>  Database Architect Training

Database Architect Training


 (4.9) | 750 Ratings


Introduction


Database Architect Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

Database Architect Modules

Module 1:- Introduction to Database

Topics : Introduction, What is database, definition, how Oracle DB works, Unix Kernel.

Module 2:- Physical Database Structure

Topics : Introduction, What is Physical Database Structure, Control files, Key information of files, Redo log files.

Module 3 :-Oracle Storage Structures

Topics : Introduction, Oracle Database Structures, Table Statements, How to check create table, schemas and schema objects, Data blocks, extents, segments.

Module 4 :- Memory and Process Architecture

Topics : Overview, Memory & Process architecture, Instance/ Memory Structures, Shared Pool, Buffer Cache, Redo Log Buffer, Process Architecture, Background process.

Module 5 :- Background Process, Alert & Trace files

Topics : Background Process, Alert & Trace Files, Alert, Trace files concept.

Module 6 :- Database Start up & Serving user Requests

Topics : Introduction, Database Start Up & Serving User Requests, Database Start Up, User Process, Server Process.

Module 7:- Database Security

Topics : Database Security, Process of “Create User”, How to Alter and Drop User, Resources Limits & Profiles, Auditing.

Module 8 :- Schema Objects

Topics : Schema Objects, Types of Schema Objects, How table data is stored, Temporary Tables, External Tables.

Module 9:- Schema Object Continued

Topics : Schema Object Continued, Materialized Vies, Sequence Generator, Indexes, B-Tree Index Structure, Cluster/ Hash Cluster, Data Concurrency & Consistency, Locking, Deadlocks.

Module 10:- Oracle Network Environment

Topics : Oracle Network Environment, How to connect your Database, Network Environment of Oracle, Database Link.

Module 11:- Oracle Backup & Recovery Concepts

Topics : Introduction, Oracle Backup and Recovery Concepts, Standby Database, Testing, Media Recovery Options, Offline Backup, Standby Database.

Module 12:- Oracle Recovery Manager (RMAN)

Topics : Oracle Recovery Manager (RMAN), Data pump export & import, SQL Loader, External Table.

Module 13 :- Data Dictionary & Dynamic Performance Tables

Topics : Data Dictionary & Dynamic Performance Tables, What are dynamic performance tables, Typical day Oracle DBA.

Module 14 :- Introduction to Database Tuning

Topics : Database Tuning Introduction, Monitor Space Usage, Monitor SQL Scripts, Database Tuning, SQL Tuning, Table Statistics, Index Statistics, Index Selectivity, Chained Rows, Locks.

Module 15 :- Introduction to Database Tuning Continued

Topics : Introduction of Database Tuning Continued, Tuning Shared Pool, Data Dictionary Performance, Data dictionary tuning, PL/ SQL Code, Code reuse, Database Buffer, Buffer Cache hit Ratio, Code Reuse.

 

Exam & Certification

0

Course Review

(4.9)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

Database Architect Modules

Module 1:- Introduction to Database

Topics : Introduction, What is database, definition, how Oracle DB works, Unix Kernel.

Module 2:- Physical Database Structure

Topics : Introduction, What is Physical Database Structure, Control files, Key information of files, Redo log files.

Module 3 :-Oracle Storage Structures

Topics : Introduction, Oracle Database Structures, Table Statements, How to check create table, schemas and schema objects, Data blocks, extents, segments.

Module 4 :- Memory and Process Architecture

Topics : Overview, Memory & Process architecture, Instance/ Memory Structures, Shared Pool, Buffer Cache, Redo Log Buffer, Process Architecture, Background process.

Module 5 :- Background Process, Alert & Trace files

Topics : Background Process, Alert & Trace Files, Alert, Trace files concept.

Module 6 :- Database Start up & Serving user Requests

Topics : Introduction, Database Start Up & Serving User Requests, Database Start Up, User Process, Server Process.

Module 7:- Database Security

Topics : Database Security, Process of “Create User”, How to Alter and Drop User, Resources Limits & Profiles, Auditing.

Module 8 :- Schema Objects

Topics : Schema Objects, Types of Schema Objects, How table data is stored, Temporary Tables, External Tables.

Module 9:- Schema Object Continued

Topics : Schema Object Continued, Materialized Vies, Sequence Generator, Indexes, B-Tree Index Structure, Cluster/ Hash Cluster, Data Concurrency & Consistency, Locking, Deadlocks.

Module 10:- Oracle Network Environment

Topics : Oracle Network Environment, How to connect your Database, Network Environment of Oracle, Database Link.

Module 11:- Oracle Backup & Recovery Concepts

Topics : Introduction, Oracle Backup and Recovery Concepts, Standby Database, Testing, Media Recovery Options, Offline Backup, Standby Database.

Module 12:- Oracle Recovery Manager (RMAN)

Topics : Oracle Recovery Manager (RMAN), Data pump export & import, SQL Loader, External Table.

Module 13 :- Data Dictionary & Dynamic Performance Tables

Topics : Data Dictionary & Dynamic Performance Tables, What are dynamic performance tables, Typical day Oracle DBA.

Module 14 :- Introduction to Database Tuning

Topics : Database Tuning Introduction, Monitor Space Usage, Monitor SQL Scripts, Database Tuning, SQL Tuning, Table Statistics, Index Statistics, Index Selectivity, Chained Rows, Locks.

Module 15 :- Introduction to Database Tuning Continued

Topics : Introduction of Database Tuning Continued, Tuning Shared Pool, Data Dictionary Performance, Data dictionary tuning, PL/ SQL Code, Code reuse, Database Buffer, Buffer Cache hit Ratio, Code Reuse.

 

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry