Oracle / SQL Server

MODULE 1: SQL & SQL

• Configuring of SQL SERVER 2008 
•   Hardware requirement for SERVER 2008 
•   Software requirement for SERVER 2008 
•   Introduction to RDBMS System Database 
•   E-R Diagrams 
•   Normalization 
•   Introduction to TSQL 
•   Select Command 
•   DDIs 
•   DMIs 
•   Sub-Queries 
•   Working with Tables 
•   Correlated Sub queries 
•   Transactions 
•   Constraints 
•   Views 
•   Stored Procedures 
•   Functions 
•   Triggers 
•   Cursors 
•   Indexes 

MODULE 2: ADMIN & ARCHITECTURE

• Introduction to Admin & Architecture 
•   Memory Architecture 
•   Storage Architecture 
•   Database Creation 
•   Database Creation with wizard and & with T-SQL 
•   Up grading Database 
•   Migration of Database 
•   Introduction to Managing Filegroups 
•   Datafiles 
•   Logfiles 
•   Managing Logins & Users 
•   System Tables and Views & Linked Servers 
•   Using System Stored Procedure and DBCC Commands 
•   Import & Export 
•   Attach and Detach Databases 
•   BCP Command

MODULE 3: BACKUP AND RECOVERY, HIGH AVAILABILITY CONFIGURATION, DISASTER RECOVERY OPTIONS

• Introduction to Database Backup 
•   Partial Backup 
•   Full Backup 
•   Differential Backup 
•   Data Encryption 
•   Managing Database Snapshots 
•   Jobs and Alerts 
•   Restoration and Recovery ( with all Options) 
•   Managing Log Shipping (Wizard and scripting) 
•   Managing Database Mirroring (Wizard and scripting) 
•   Managing Replication

MODULE 4: OPTIMIZATION

• Introduction to Locking 
•   Dead Locks 
•   Transaction Isolation Levels 
•   Introduction to Tuning 
•   SQL Tuning 
•   Index tuning 
•   Performance Tuning Goals 
•   Tuning Methodology 
•   SQL Profiler 
•   Resourse Governer. Policy Management 
•   Introduction to Views 
•   Dynamic Management Views 
•   Instance Tuning 
•   I/O tuning 
•   OS Tuning