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 |
