Corporate Training in Microsoft SQL Database Server 2005

Module 1:
Understanding Query Flow
Syntactical Flow of the Query Statement
Logical Flow of the Query Statement
From Clause Data Sources
Possible Data Sources
Named Ranges
[Table Name]
Four-Part Table Names

Module 2:
Where Conditions
Using the Between Search Condition
Using the In Search Condition
Using the Like Search Condition
Multiple Where Conditions
Select...Where
Ordering the Result Set
Specifying the Order by Using Column Names
Specifying the Order by Using Expressions
Order by and Collation
Select Distinct

Module 3:
Operators
Scalar Functions
User Information Functions
Data-Time Functions
String Functions

Module 4:
Inner Joins
Creating Inner Joins within SQL Code
Number of Rows Returned
Multiple Table Joins
Outer Joins
Outer Joins and Optional Full Outer Joins
Placing the Conditions within Outer Joins
Self-Joins
Multiple-Condition Joins

Module 5:
Using Unions
Intersection Union

Module 6:
Simple Subqueries
Using Scalar Subqueries
Using Subqueries as Lists
Using Subqueries as Tables
Simple Aggregations
Basic Aggregations
Grouping within a Result Set
Simple Groupings
Aggravating Queries

Module 7:
Why Use Views?
Working with Views
Creating Views with DDL Code
Order By and Views
View Restrictions
Executing Views

Module 8:
Inserting Data
Inserting One Row of Values
Inserting the Result Set from a Stored Procedure
Updating Data
Updating a Single Table
Deleting Data
Creating Tables
Creating Primary Keys
Primary Keys
Creating Foreign Keys

Module 9:
DDL Triggers
Creating and Altering DDL Triggers
EventData()
Enabling and Disabling DDL Triggers
Implementing Triggers

Module 10:
XML Data Type
Querying XML Data
Merging XQuery with Select
Reading XML into SQL Server
Creating XML with SQL Server 2005
ql