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!