Learn SQL step-by-step and from the ground up.

This class assumes no prior knowledge of the Structured Query Language (SQL) and is an absolute necessity if you have not had any background with SQL or relational databases.

The class presents an overview of databases and of the Relational Database Model and the foundations of database design. It covers the foundations of SQL and how to use the language to create a database, tables, indexes, constraints, views, and to manipulate the data structure.

Level: Beginner
Prerequisites: None

This interactive SQL class introduces the two areas of the Structured Query Language (SQL): The Data Definition Language (DDL) and the Data Manipulation Language (DML).

The class covers the main components of a SQL statement and provides multiple examples on how to use SQL to access and modify data.

The class is hands-on and students will be engaged to test knowledge and to solve SQL problems.

Level: Beginner
Prerequisites: SQL101

This interactive SQL class focuses on the different ways we can join multiple tables using basic and advanced SQL queries. You will learn all about Inner Joins, Outer Joins, Self Joins, Unions and Correlated and Non-Correlated Subqueries.

The class covers these topics step-by-step and in great details, and provides multiple examples on how to use SQL to access and modify data using one or multiple tables.

The class is hands-on and students will be engaged to test knowledge and to solve SQL problems.

Level: Intermediate
Prerequisites: SQL101, SQL102

This interactive SQL class focuses on Views, Temporary Tables and advanced database queries. Views will be covered step-by-step, beginning with the most basic concepts to the creation of advanced views. The class will provide multiple examples on how to use Views and Temporary Tables in real-life scenarios. You will learn how to analyze the data requirements and avoid serious logical errors in the structuring of your queries.

The class is hands-on and students will be engaged to test knowledge and to solve SQL problems.

Level: Intermediate
Prerequisites: SQL101, SQL102, SQL201

10 hours of Delphi Support

Delphi Support means that you have the peace of mind of knowing that you have somewhere to go if you have any Delphi questions while you work on your projects. Now you can submit your questions by email or by phone and receive quick answers to help you with your projects.

30 hours of Delphi Support

Delphi Support means that you have the peace of mind of knowing that you have somewhere to go if you have any Delphi questions while you work on your projects. Now you can submit your questions by email or by phone and receive quick answers to help you with your projects.