Sql Overview:

Basic Sql Statements, Where Clause, Order by clause, Operators, Sql  Functions, Join tables, Subqueries, DML , DDL, TCL Statements, Constraints, Views.

Linux Overview:

Linux Installation, Linux architecture, File System, creating files, Directories, changing permissions, ownerships, wildcard characters and redirections symbols, vi editor, search commands, linking files, process killing, cpu utilization.

Oracle Database:

Installation:

Checking the pre-requisite + Installing Oracle 9i Software

Architecture:

Explaining an Oracle Database Server, Database, Instance, Session

Defining Physical structure, logical structure

Execution plan of sql statement

Database creation:

Manual database creation, Creation spfile, Creating pfile, Database startup/shutdown commands, Monitoring alert and trace files, checking background process, Checking views (dynamic and data dictionary)

Managing Tablespaces and Datafiles:

Creating and altering tablespaces, adding resizing, renaming datafiles, renaming tablespaces

Putting tablespades in offline,online, readwrite modes, Creating locally managed tablespace and dictionary managed tablespace

User management:

Row chaining and row migration, Creating users, assingning privileges, profiles, roles

Managing export and imports:

Table export/import, Schema export/import, database export/import

Managing undo segments and temp tablespces:

Creating undo/temp tablespaces and the undo parameters

Networking overview:

Shared server environment and Dedicated server envinorment, Creating/managing listener.ora file, tnsnames.ora files

Backup and recovery:

Setting Datatbase in Archive log mode

User-managed:

Backup(cold and hot)

Recovery (normal datafile lost, system datafile lost, controlfile lost, redolog file lost, arhive log file lost….)

Rman backup and Recovery

Tuning:

Making/analyzing statspack report

Making/analyzing explain plan

Oracle 10g installation:

10g new Features:

Sysaux Tablespace + New Parameters, Data Pump, AWR Report, ADDM Report, Renaming Tablespace, Flashback Recovery, Transportable Tablespace

Oracle 11g Installation:

*** Applying Patches

*** Applying Patchset

*** Oracle Software Upgradation

*** Oracle Database Upgradation

*** Overview on Dataguard

*** Overview on RAC