sql server 2008 training

sql server 2008 training Course Content

Getting Started with Databases & Transact-SQL in SQL Server 2008
  • Overview of SQL Server 2008
  • Overview of SQL Server Databases
  • Overview & Syntax Elements of T-SQL
  • Work with T-SQL Scripts
  • Using T-SQL Querying Tools
Querying & Filtering Data
  • Using the SELECT Statement
  • Filtering Data
  • Work with NULL Values
  • Formatting Result Sets
  • Performance Considerations for Writing Queries
Grouping & Summarizing Data
  • Summarizing Data by Using Aggregate Functions
  • Summarizing Grouped Data
  • Ranking the Grouped Data
  • Creating Crosstab Queries
Joining Data from Multiple Tables
  • Querying the Multiple Tables by Using Joins
  • Applying Joins for Typical Reporting Needs
  • Combining & Limiting Result Set
Working with Subqueries
  • Writing the Basic Subqueries
  • Writing Correlated Subqueries
  • Comparing Subqueries with Joins & Temporary Tables
  • Using Common Table Expressions
Modifying Data in Tables
  • Inserting Data into Tables
  • Deleting Data from Tables
  • Updating Data in Tables
  • Overview of Transactions
Querying Metadata, XML, & Full-Text Indexes
  • Querying Metadata
  • XML Overview
  • Querying XML Data
  • Overview of Full-Text Indexes
  • Querying Full-Text Indexes
Using Programming Objects for Data Retrieval
  • Overview of Views
  • Overview of User-Defined Functions
  • Overview of Stored Procedures
  • Triggers Overview
  • Writing the Distributed Queries
Using Advanced Querying Techniques
  • Considerations for Querying Complex Data
  • Working with the Data Types
  • Cursors and Set-Based Queries
  • Dynamic SQL
  • Maintaining Query Files