Website Updated On - #

Admission Query:0240-2375109/135/375

SQL Server 2008 Training
Syllabus
  • Introducing SQL Server 2008
    • What's New in SQL Server?
    • SQL Server Editions
    • Installing SQL Server
  • Basics of Database Design
    • Normalization
    • Denormalization
    • Introducing SQL Server Management Studio
    • Creating a Database
    • Adding Tables
    • Creating Indexes and Constraints
    • Building Relations
  • T-SQL Basics
    • What is T-SQL?
    • Syntax Conventions
    • Introducing AdventureWorks2008
    • Executing SQL Statements
    • Identifiers
    • Creating Data Types, Operators, Variables, Functions
    • Using T-SQL to Build and Alter Objects
  • SELECT queries
    • The SELECT / FROM/ WHERE / ORDER BY / GROUP BY AND HAVING Clause / Using TOP N and TOP N PERCENT
    • UNION Queries
    • Full-Text Search
  • Action Queries
    • SELECT / DELETE / TRUNCATE / INSERT / UPDATE / MERGE INTO queries
  • Locking and Execution Plans
    • What is Locking?
    • Monitoring Locks
    • Tuning Locking
    • Deadlocks
    • Tuning Queries
    • Performance Studio
  • Views, Stored Procedures, and Functions
    • Using Views
    • Using Stored Procedures
    • Using Functions
  • Advanced Transact-SQL
    • Transactions
    • Rowset / Ranking Functions
    • Cursors
    • Structured Error Handling
  • XML and SQL Server
    • XML Columns and Indexes
    • Querying and Modifying XML Data
    • Using OPENXML
    • Using FOR XML
  • Triggers
    • Creating / Altering Triggers
    • Using the Inserted and Deleted Tables
    • Recursive and Nested Triggers
  • SQL Server 2008 Integration Services
    • The Import and Export Wizard
    • Creating a Package
    • Saving and Running Packages
  • SQL Server 2008 Reporting Services
    • Using Report Designer
    • Publishing a Report
    • Using Report Builder / Report Manager
  • Security and SQL Server
    • Choosing Service Accounts
    • Authentication Modes
    • Roles / Users / Permissions / Object Ownership

Please contact Mr. Sachin Rajput at 0240-2375128 (Server Room, MIT) to know the schedule of the training and fee structure.