Development and Training - SQL Server 2008
 
+
SQL Server 2008- Syllabus


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