SQL Server 2005 / 2008

Course details

Module One: SQL SERVER OVERVIEW

• Understanding Client Server Architecture
• Creating Sample Databases

Module Two: USING MANAGEMENT STUDIO

• Arranging the Workspace
• Registering Servers
• Explaining Items in the Object Explorer
• Explaining the Database Properties Dialog
• Explaining the Columns Properties Dialog
• Continuing with Object Explorer Items
• Using the Query Editor

Module Three: DESIGNING RELATIONAL DATABASES

• Understanding Normalization
• Avoiding Over Complexity
• Creating Physical Keys
• Using the Database Diagram Tool

Module Four: WORKING WITH SINGLE TABLE QUERIES 

• Understanding Query Flow
• Filtering Data with the Where Clause
• Columns, Expressions & Scalar Functions
• Using Case Expressions
• Working with Nulls

Module Five: Selecting Environment Functions

• Working with Dates & Times
• Parsing Strings
• Converting Data
• Sorting Data

Module Six: MERGING DATA WITH JOINS & UNIONS

• Working with Inner Joins
• Using Left Outer Joins
• Multiplying Data with Cross Joins
• Referencing Self-Joins
• Working with Complex Joins
• Finding the Set Difference
• Stacking Data with Unions

Module Seven: WORKING WITH SUBQUERIES

• Using Subqueries as Expressions
• Including Subqueries as Lists
• Adding Subqueries as Derived Tables

Module Eight: AGGREGATING DATA

• Using Aggregate Functions
• Grouping a Data Set
• Nesting Aggregations
• Filtering Groups & Adding Grand Totals
• Calculating Cumulative Sums

Module Nine: SELECTING DATA THROUGH VIEWS

• Creating Views
• Nesting Views

Module Ten: MODIFYING DATA

• Inserting Data
• Updating Data
• Deleting Data

Module Eleven: T-SQL & STORED PROCEDURES

• Introducing T-SQL
• Working with Variables
• Introducing Stored Procedures
• Passing Parameters
• Returning Parameters
• Handling Errors

Module Twelve: USER-DEFINED FUNCTIONS

• Creating Scalar Functions
• Working with Functions

Module Thirteen: INDEXING FOR PERFORMANCE (2 hours)

• Introducing Indexes
• Creating Indexes