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