SQL Server 2005 Topics Covered |
|
~ 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. |
~ 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 |
|
~ Operators |
~ Scalar Functions |
~ User Information Functions |
~ Data-Time Functions |
~ String Functions |
|
~ 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 |
|
~ Using Unions |
~ Intersection Union |
|
~ Simple Subqueries |
~ Using Scalar Subqueries |
~ Using Subqueries as Lists |
~ Using Subqueries as Tables |
~ Simple Aggregation |
~ Basic Aggregations |
~ Grouping within a Result Set |
~ Simple Groupings |
~ Aggravating Queries |
|
~ Why Use Views? |
~ Working with Views |
~ Creating Views with DDL Code |
~ Order By and Views |
~ View RestrictionsView Restrictions |
~ Executing Views |
|
~ 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 |
|
~ DDL Triggers |
~ Creating and Altering DDL Triggers |
~ EventData() |
~ Enabling and Disabling DDL Triggers |
~ Implementing Trigger |
|
~ XML Data Type |
~ Querying XML Data |
~ Merging XQuery with Select |
~ Reading XML into SQL Server |
~ Creating XML with SQL Server 2005 |