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: 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.
