MODULE 1: SQL & TSQL   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   Defrential Backup   Data Encrypyion   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
Book My Free Demo Class Now!