Course: SQL Level 2 – Advanced SQL

Date: 02-27-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 workshop is designed to provide students who have a basic understanding of SQL with more advanced skills. It includes a review of basic SQL skills, but quickly moves on to advanced topics including multi-table joins, the use of data definition language (DDL) for creating and altering data structures and data management techniques. In this course students will build new table structures and use SQL to populate and conditionally update them. Additional topics include the creation and maintenance of indexes, security, and the creation and use of database views and stored procedures. An experienced consultant with a SQL development and programming background and substantial real world exposure teaches the course.

TOPICS COVERED:

  • SQL Basics Review
  • Advanced Table Joins
  • Database Views
  • Data Definition Language
  • Table Creation
  • Table Altering
  • Table Population
  • Conditional Updating of a Table
  • Index Creation and Maintenance
  • Stored Procedures
  • SQL Security Overview

MATERIALS:
Slides and other course materials are available to students in electronic format (via download).

WHO SHOULD ATTEND:
Individuals with a basic understanding of, and some experience with, SQL. This course is targeted at users who will need to write, analyze and use more complex SQL statements and commands. It’s ideal for database administrators, analysts, consultants, programmers, business people or anyone seeking enhance their understanding of the SQL language.

PREREQUISITES:
A firm understanding of MS-Windows and Windows applications is mandatory. Students must also have a basic understanding of SQL and some experience with it. Students should know how to use SELECT, WHERE, ORDER BY, GROUP BY, HAVING, JOINS AND AGGREGATES. The course is best suited for people who have used SQL for a year or more or have attended the Introductory course.

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.