Course: SQL Level 3 – Expert

Date: 01-31-2020
Duration: 1 day
Check-in Time: 8:30 am
Start Time: 9:00 am
Location: Result Data Training Room 1
Fee: $485.00
Register for this Course

Course Outline

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.

TOPICS COVERED:

  • Variables
  • IF-THEN-ELSE Conditions
  • CASE Structures
  • Stored Procedures
  • Database Views
  • COALESCE
  • WHILE Loops
  • Triggers
  • User Defined Functions
  • Windowing Functions
  • Mathematical Functions
  • Date Manipulation
  • Cursors

MATERIALS:

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

PREREQUISITES:

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.

MORE INFORMATION:
Call us at 614.505.0770 for more information.

Registration

Request a seat for this Course

We'd love to have you in our class! Please fill out this form to request a seat.