India: +91 406677 1418

WhatsApp no. : +919100386313

USA: +1 909 233 6006

Telegram : +15168586242

Microsoft Sql Server 2008 Online Training

Microsoft Sql Server 2008 Course Content

Introduction to SQL Server 2008
  • What’s New in SQL Server?
  • SQL Server Editions
  • Installing SQL Server
Database Design Basics
  • Normalization & Denormalization
  • Tools for Normalization in SQL Server
  • Introducing SQL Server Management Studio
  • Database Creating
  • Tables Adding
  • Creating Indexes & Constraints
  • Building Relations
T-SQL Basics
  • What is T-SQL?
  • Syntax Convention
  • Introducing the AdventureWorks2008
  • Executing SQL Statements
  • Identifiers
  • Creating the Data Types
  • Operators
  • Variables
  • Functions
  • Using the T-SQL to Build & Alter Objects
SELECT Queries
  • The SELECT Clause
  • The FROM Clause
  • The WHERE Clause
  • The ORDER BY Clause
  • Using GROUP BY & HAVING
  • Using TOP N and TOP N PERCENT
  • UNION Queries
  • Full-Text Search
Action Queries
  • SELECT INTO queries
  • DELETE queries
  • TRUNCATE TABLE queries
  • INSERT queries
  • UPDATE queries
  • MERGE queries
Locking & Execution Plans
  • What is Locking?
  • Locks Monitoring
  • Tuning Locking
  • Deadlock
  • Tuning Queries
  • Management Data Warehouse
  • Performance Studio
Views, Stored Procedures & Functions
  • Using the Views
  • Using the Stored Procedures
  • Using the Functions
Advanced Transact-SQL
  • Transactions
  • Rowset Functions
  • Ranking Functions
  • Cursors
  • Structured Error Handling
XML & SQL Server
  • XML Columns & Indexes
  • Querying & Modifying XML Data
  • Using the OPENXML
  • Using the FOR XML
Triggers
  • Creating DML Triggers
  • Altering DML Triggers
  • Using Inserted & Deleted Tables
  • Checking Updated Columns
  • Recursive & Nested Triggers
  • Creating DDL Triggers
.NET inside of SQL Server
  • Creating the CLR User defined Functions
  • Creating the CLR Stored Procedures
  • Using the Sql Namespace
  • Creating the CLR Triggers
  • Creating the CLR User defined Types
  • Choose  When To Use CLR Objects
SMO & RMO Programming
  • Retrieving the Server Information
  • Work With Database Objects
  • Generating Scripts
  • Viewing & Modifying Server Configuration
  • Understanding RMO
Data Protection OR Tracking
  • Understanding the Change Data Capture
  • Data Capture Schema & Tables
  • Transparent the Data Encryption