The Complete SQL Course

Mastering SQL is a fundamental skill in almost any enterprise software solution. From accessing databases from within code as a developer, to querying data as an analyst, the ability to write and execute SQL is critical.

Complete SQL, covers everything you need to master this critical skill.

The course is broken down into seven sections. Here’s what you’ll learn:

Section 1 – Introduction

In this introductory section, you ll see a quick overview of relational databases, and see an example of how relational databases are comprised of tables, columns, rows, and how tables can relate to one another.

Section 2 – Set Up Training Environment

This section steps you through the software needed to set up your training environment that you ll use throughout the course. You ll see step–by–step demonstrations on how to install Oracle Database Express and Oracle SQL Developer, and you ll create your own database.

Section 3 – SQL Fundamentals

These are the fundamental skills every SQL writer needs to know. You ll learn how to:

You ll learn about

Section 4 – Subqueries

In this section, you ll learn how to use query from the results of a subquery. You ll learn how to write:

Section 5 – Keys and Indexes

In this section, you will learn how: