Preparation Oracle 11g DBA online

SQL

·         SELECT Statements

·         Restricting and Sorting Data

·         Single-Row Functions

·         Aggregate Functions

·         Joining Tables

·         Manipulating Data

·         Creating Tables

·         Creating Objects

·         Security

·         Schema Objects

·         Advanced DML Operations

PL/SQL

·         Create and debug stored procedures and functions

·         Design PL/SQL anonymous blocks that execute efficiently

·         Use the Oracle supplied PL/SQL packages to generate screen output, file output and

·         mail output

·         Write dynamic SQL for more coding flexibility

·         Describe the features and syntax of PL/SQL

·         Use PL/SQL programming constructs and conditionally control code flow (loops, control

·         structures, and explicit cursors)

·         Manage dependencies between PL/SQL subprograms

·         Handle runtime errors

·         Create triggers to solve business challenges

·         Design PL/SQL code for predefined data types, local subprograms, additional pragmas,

·         standardized constants and exceptions

Introduction to database management systems and Database

·         What is a database?

·         Popular database management system (DBMS) software and why Oracle DBMS

·         History and Current trends of DBMS and Database Administration

·         Tasks of a Database Administrator

·         Installation of Oracle database software (Oracle DBMS)

Oracle Database Architecture

·         Creation of the first Oracle database.

·         Startup and Shutdown of a database

·         Components of an Oracle database and detailed architecture

·         Advance Startup and Shutdown Scenarios

Database storage

·         Tablespaces and allocation types

·         Create tablespaces

·         Create datafiles with fixed size and autoextend option

·         Control files

·         How to rename datafiles in a controlfile

·         Redolog groups and members

·         Archivelog mode for a database

Oracle Networking

·         Introduction

·         Oracle listener configuration

·         Oracle database connections from other computers

·         Oracle listener administration and TNS_ADMIN environment variable

·         Database Links

Used Managed (Manual) Backup and Recovery

·         Introduction

·         Cold Backup

·         Database in Archive Log mode

·         Hot Backup

·         How to clone a database using Cold Backup

·         How to clone a database using Hot Backup

·         How to recreate source database from backups

Database Objects

·         Introduction

·         Tables and Columns

·         Indexes

·         Packages, Stored procedures and Functions

·         Database links

·         Views and Synonyms

·         Oracle Data Dictionary

·         Popular Data Dictionary views and accessing them

Oracle Utilities

·         Introduction

·         SQL*Plus Worksheet

·         Data Pump Export

·         Data Pump Import

·         Introduction to Oracle SQL* Loader

User Management, Roles and Privileges

·         Introduction

·         Create databases users

·         User roles and privileges

·         User profiles and tablespace quotas

·         OS authentication vs database authentication

Performance Tuning

·         Introduction

·         How to handle performance issues in the real world

·         V$ views for performance monitoring and analysis

·         How to size the Oracle database and memory for optimal performance

·         Oracle database wait events

·         Explain Oracle UNDO management internals and sizing.

·         Explain Oracle TEMP space internals and sizing.

·         SQL Query tracing using TKPROF

·         Database wide tracing for Oracle Errors (Event Tracing)

·         Index Monitoring and internals of index maintenance by Oracle

·         Gather optimizer statistics using DBMS_STATS