Course Content
A Tour of SQL Server 2008
- SQL Server 2008 Editions, Components, and Tools
- Using SQL Server Management Studio (SSMS)
- Working with Tables, Queries, and Views
- Business Intelligence Services
Designing and Creating a Database
- Relational Database Design Principles
- Implementing the Design
Working with SQL Server Management Studio
- Getting Started with Management Studio
- Exploring the Object Explorer
- Working with the Query Editor
- Using SQL Server Books Online
Transact-SQL Programming
- Overview of Transact-SQL
- Using Built-In Functions
- Controlling Flow
- Ranking Results
Transactions and Error Handling
- Transaction Concepts
- Applications and Transactions
- Creating Explicit Transactions
- Using TRY/CATCH Error Handling
Data Selection Queries
- Understanding Transact-SQL
- The SELECT Statement
- The WHERE Clause
- Using ORDER BY to Sort Data
- The GROUP BY Clause
- Joining Tables
Advanced Data Types
- Introduction
- The HierarchyID Data Type
- Sparse Columns and Column Sets
- FILESTREAM Storage
- Spatial Data
Complex Querying
- Working with NULL Values
- Ranking Grouped Data
- Writing Correlated Subqueries
- Using Common Table Expressions
Modifying Data
- Modifying Data with Transact-SQL
- Inserting Data
- Updating Data
- Deleting Data
- Understanding Transaction Isolation
Working with XML
- The XML Data Type
- XML Schema Collections
- Querying XML
- Best Practices
Creating Views
- What Is a View?
- Creating Views
- Updating Data Using a View
- Using Computed Columns
- Indexed Views
- Partitioned Views
Implementing SQL Server Partitions
- Overview of Table-Based Partitions
- Creating Partitioned Tables
- Querying Partitions
- Managing Partitions
Creating User-Defined Functions
- User-Defined Function Overview
- Scalar Functions
- Inline Table-Valued Functions
- Multi-Statement Table-Valued Functions
- Using Functions, Views, and Stored Procedures
Creating Stored Procedures and Triggers
- Creating Stored Procedures
- Creating Triggers
Advanced Query Techniques
- Full-Text Search
- Advanced T-SQL Techniques
- Executing Dynamic SQL
Advanced Techniques
- Complex Data and Structures
- Writing More Efficient Queries
- Working with Complex Queries
- Maintaining Query Files