78374-01000, 78374-02000, 78374-03000       Whatsapp 78374-04000
Toll Free : 1800-200-6147
  info@thinknext.co.in           Locate Us
PayTM 7837433597
* ThinkNEXT organizes 9th Mega Job Fair on 30th December 2017.  Register Now    |     * Free 6 Months Industrial Training with reward money of about Rs. 4500/-, Laptop Bag, Books, T-shirt, Diary, ID Card, Lanyard, Card Holder to each student under Government Scheme and ThinkNEXT. Dual Certification of ThinkNEXT and Govt. of India.
*ThinkNEXT organizes 9th Mega Job Fair on 30th December 2017.  Register Now
*Free 6 Months Industrial Training with reward money of about Rs. 4500/-, Laptop Bag, Books, T-shirt, Diary, ID Card, Lanyard, Card Holder to each student under Government Scheme and ThinkNEXT.
Members Members

SQL Server Database Training in Chandigarh Mohali Panchkula

SQL Server Database Training - Course Contents

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

SQL Server Database Training in Chandigarh
Arrange a Call Back
Book My Free Demo Class Now!
Career Counselling
Java
Speak to the Munish Mittal to know what's the best course for your career. Just call us on Munish Mittal personal number for free career guidance.

Thankyou!
+91 8360 052 717


Other Popular Courses/Training Programs


Book My Free Demo Class Now!