jai
27-09-13 1 Hits


Module 1: SQL Server 2008 Tool sets
• SQL Server Management Studio
• SQLCMD Utility
• Business Intelligence Development Studio (BIDS)
• SQL Profiler
• Bulk Copy
• Adventure Works Sample Database
• Data Definition Language
Module 2: Data Types and New T-SQL Language Features
• SQL Server Data Types
• New Data Types
• Hierarchyid Data Type
• Spatial Data
• Date and Time
• FileStream Storage
• Grouping Sets
Module 3: Single Table Queries
• Logical Query Processing
• Query Clauses (Listed in Logical Processing Order)
• FROM
• WHERE
• GROUP BY
• HAVING
• SELECT
• ORDER BY
• CASE
• NULLS
Module 4: Joining Multiple Tables
• Normalization
• Old Style vs. New Style
• Cross Join
• Inner Join
• Outer Join
• Self Join
• Joining Multiple Tables
Module 5: Subqueries, Common Table Expressions and Ranking Functions
• Subqueries
• Self-Contained Subqueries
• Correlated Subqueries
• EXISTS
• Views
• Derived Tables
• Common Table Expressions
• Analytic Ranking Functions
Module 6: Indexing
• Understanding Execution Plans
• Table and Index Structures
• Syntax
• Clustered Index
• Non Clustered Index on Heap
• Non Clustered Index on Clustered Index
• Syntax
Module 7: Query Tuning
• System Performance Analysis
• Query Analysis
• Database Engine Tuning Advisor
• Bookmark Lookup
• Statistics Analysis
• Query Design
• Performance Monitor
• Dynamic Management Views
• SQL Profiler
• Database Engine Tuning Advisor
• Query Design
Module 8: Data Modification, Transactions and Error Processing
• Modifying Data INSERT
• Modifying Data UPDATE
• Modifying Data DELETE
• Transactions
• Error Processing
• Debugging in SQL Server 2008
Module 9: Stored Procedures and Triggers
• Stored Procedures
Module 5: Subqueries, Common Table Expressions and Ranking Functions
• Subqueries
• Self-Contained Subqueries
• Correlated Subqueries
• EXISTS
• Views
• Derived Tables
• Common Table Expressions
• Analytic Ranking Functions
Module 6: Indexing
• Understanding Execution Plans
• Table and Index Structures
• Syntax
• Clustered Index
• Non Clustered Index on Heap
• Non Clustered Index on Clustered Index
• Syntax
Module 7: Query Tuning
• System Performance Analysis
• Query Analysis
• Database Engine Tuning Advisor
• Bookmark Lookup
• Statistics Analysis
• Query Design
• Performance Monitor
• Dynamic Management Views
• SQL Profiler
• Database Engine Tuning Advisor
• Query Design
Module 8: Data Modification, Transactions and Error Processing
• Modifying Data INSERT
• Modifying Data UPDATE
• Modifying Data DELETE
• Transactions
• Error Processing
• Debugging in SQL Server 2008
Module 9: Stored Procedures and Triggers
• Stored Procedures


  Send Message   Phone: 26675891


Report this ad