SQL Server Database Training

Wondering where to have your Microsoft SQL Server Training in Chandigarh? Well, you don’t need to wonder anymore. One of the most elite professional training Academies in Chandigarh, Thinknext training has brought you this excellent Microsoft SQL Server course that will brush up your basics and help you emerge as a valuable SQL-certified expert.But before this, you’ll need to know a couple of things first, such as:

Microsoft SQL Server is a relational database management system owned by Microsoft. The software is used for storing and managing data as requested by other apps.

There are at least 2 dozen editions of Microsoft SQL servers aimed at different audiences, ranging from single machines to multiple users. Each server differs as per the capacity.

Course Contents:

• MODULE NO.1 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 NO.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 NO.3 BACKUP AND RECOVERY
• 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 NO.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