Lesson 1: SQL Server Overview
- What Is SQL Server
- SQL Server Integration
- SQL Server Databases
- SQL Server Security
- Working with SQL Server
Lesson 2: Overview of Programming SQL Server
- Designing Enterprise Application Architecture
- SQL Server Programming Tools
- The Transact-SQL Programming Language
- Elements of Transact-SQL
- Additional Language Elements
- Ways to Execute Transact-SQL Statement
Lesson 3: Creating and Managing Databases
- Creating Databases
- Creating Filegroups
- Managing Databases
- Introduction to Data Structures
Lesson 4: Creating Data Types and Tables
- Creating Data Types
- Creating Tables
- Generating Column Values
- Generating Scripts
Lesson 5: Implementing Data Integrity
- Types of Data Integrity
- Enforcing Data Integrity
- Defining Constraints
- Types of Constraints
- Disabling Constraints
- Using Defaults and Rules
- Deciding Which Enforcement Method to Use
Lesson 6: Planning Indexes
- Introduction to Indexes
- Index Architecture
- How SQL Server Retrieves Stored Data
- How SQL Server Maintains Index and Heap Structures
- Deciding Which Columns to Index
Lesson 7: Creating and Maintaining Indexes
- Creating Indexes
- Creating Index Options
- Maintaining Indexes
- Introduction to Statistics
- Querying the sysindexes Table
- Setting Up Indexes Using the Index Tuning Wizard
- Performance Considerations
Lesson 8: Implementing Views
- Introduction to Views
- Advantages of Views
- Defining Views
- Modifying Data Through Views
- Optimizing Performance by Using Views
- Performance Considerations
Lesson 9: Implementing Stored Procedures
- Introduction to Stored Procedures
- Creating, Executing, Modifying, and Dropping Stored Procedures
- Using Parameters in Stored Procedures
- Executing Extended Stored Procedures
- Handling Error Messages
- Performance Considerations
Lesson 10: Implementing User-defined Functions
- What Is a User-defined Function
- Defining User-defined Functions
- Examples of User-defined Functions
Lesson 11: Implementing Triggers
- Introduction to Triggers
- Defining Triggers
- How Triggers Work
- Examples of Triggers
- Performance Considerations
Lesson 12: Programming Across Multiple Servers
- Introduction to Distributed Queries
- Executing an Ad Hoc Query on a Remote Data Source
- Setting Up a Linked Server Environment
- Executing a Query on a Linked Server
- Managing Distributed Transactions
- Modifying Data on a Linked Server
- Using Partitioned Views
Lesson 13: Optimizing Query Performance
- Introduction to the Query Optimizer
- Obtaining Execution Plan Information
- Using an Index to Cover a Query
- Indexing Strategies
- Overriding the Query Optimizer
Lesson 14: Analyzing Queries
- Queries That Use the AND Operator
- Queries That Use the OR Operator
- Queries That Use Join Operations
Lesson 15: Managing Transactions and Locks
- Introduction to Transactions and Locks
- Managing Transactions
- SQL Server Locking
- Managing Locks
|