No Prior knowlegde of SQL or any other database product is required for this training
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
Understanding Query Flow
:
091-22-23676218, 23679302, 23671772, Fax: 091-22-23671772