Coronavirus (COVID-19) information: All courses at all locations are available as live online classes. Limited in-person classes in some locations. Our offices remain open. Learn more.

×

SQL Level 3

SQL Level 3

SQL Level 3: Course Description

Connect to external applications like Excel, automate workflows, and leverage temporary tables. Explore advanced conversion functions and schema binding. This advanced SQL class will teach you the skills you need for database management. Learn to create databases, import and export data, create database diagrams, and more. 

In this SQL class, you'll write advanced SQL code in hands-on exercises to take your skills up a level. By the end of the course, you will have built your own SQL database that you can continue to work with after the class. 

Prerequisites: This class builds off of our SQL Level 2 class which covers the advanced querying and views.

SQL Level 3 Course Dates

All classes are led by a live instructor. Class times listed are Eastern time.

 

Please call 800-851-9237 or 781-376-6044 to schedule a course.

Contact AGI to request course dates.

SQL Level 3: Full Overview

Importing and Exporting Data

1) Creating a Database and Tables in SQL

2) Importing and Exporting Data from and to Excel

3) Importing and Exporting Data from and to Access

4) Importing, Updating and Deleting Data via Code

Building Control Structures

5) Creating Primary Keys, Indexes and Constraints

6) Setting up Referential Integrity

7) Creating Database Diagrams

Optional

Protect Views with Schema binding

Data Conversion Functions

Temporary Tables

Stored Procedure

Prerequisites: This class builds off of our SQL Level 2 class which covers advanced querying techniques.

You will receive a training manual created by our experts for course review. 

Available Delivery Methods For This Class

CLASSROOM
LIVE ONLINE
PRIVATE
MY LOCATION