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:
- Query data from tables
- Sort query results
- Group query results
- Query from multiple tables, combining results
You’ll learn about
- String functions
- Numeric functions
- Date functions
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:
- In-Condition Subqueries
- Correlated Subqueries
- Uncorrelated Subqueries
- Exists Condition Subqueries
Section 5 - Keys and Indexes
In this section, you will learn how:
- Primary Keys can insure you can find specific data, and prevent duplicate information
- Indexes can help in query performance
- Foreign Keys can maintain the data integrity of your database
Section 6 - Unions and Outer Joins
In this section, you will learn how to combine query results using the UNION operator, and how to query multiple tables that don’t necessarily have complete information.
Section 7 - Updates, Deletes, and Inserts
Besides querying data, you may need to update, delete, and insert data into your database. In this section, you’ll learn the techniques surrounding these operations, as well as an understanding of committing and rolling back your changes.