Intro To SQL (2 Days)
-
Intro
-
Select Statement
-
Select Clause
-
From Clause
-
Where Clause
-
Functions
-
Grouping
-
Having Clause
-
Order by Clause
-
Union Queries
-
Subqueries
-
Joins
-
Update/Delete Queries
-
Creating Tables
-
Adding Constraints
-
Procedures/Triggers Intro
Cost:
$375/person (Courseware Material Included)
Transact SQL (3 Days)
-
Review (Intro To SQL)
-
Variables
-
Temporary Tables
-
Transact-SQL Functions
-
Control of Flow Statements
-
Stored Procedures
-
Triggers
-
Transactions & Error Handling
Cost:
$575/person (Courseware Material Included)