|Check-in Time:||8:30 am|
|Start Time:||9:00 am|
|Location:||Result Data Training Room 1|
This one day course is designed to help SQL users obtain a higher degree of expertise in using ANSI SQL. It provides a valuable learning opportunity for programmers, DBA’s, Reporting Specialists and others who use SQL to perform advanced database and query operations. It is focused on more complex and powerful features of the SQL Languages including things like CASE, COALESCE and WHILE loops. It also covers Database Views, Stored Procedures, Triggers and User Defined Functions. The course provides hands-on SQL experience with sample databases and data and a student workbook with reference and narrative. It is recommended that students take both Levels 1 and 2 before attending this course as certain key SQL knowledge is required.
- IF-THEN-ELSE Conditions
- CASE Structures
- Stored Procedures
- Database Views
- WHILE Loops
- User Defined Functions
- Windowing Functions
- Mathematical Functions
- Date Manipulation
Slides and other course materials are available to students in electronic format (via download).
WHO SHOULD ATTEND:
Students with experience in writing SQL Statements and/or those who have attended SQL Level 1 and SQL Level 2 training
A solid undertsanding of how write and use common SQL SELECT, UPDATE and INSERT statements including such items as join syntax, aggregate usage, grouping and sub-query usage. This class is based on Transact-SQL syntax from Microsoft.
Call us at 614.505.0770 for more information.