Courses

SQL Intermediate

course

SQL Intermediate

If you ask the right questions when looking at data you’ll get powerful insights. Take your database query skills to the next level with this second SQL course. Often, you need multiple tables in order to keep data integrity and avoid duplication. In this course, we’ll teach you how to easily deal with more than one table. Master the process of data manipulation and work with more complex interrelated multi-table databases. This course follows our Introduction to SQL course. Take a quick look at what it covers and if you’re comfortable with those concepts, then dive into Intermediate SQL!

What you'll learn

Manipulate data
Use aggregations and string functions to manipulate data.
Work with multi-table databases
Extract data from databases consisting of multiple tables.
Join data from different tables
Merge data from different interrelated tables with the join query.
illustration
SQL Intermediate
SQL Intermediate
If you ask the right questions when looking at data you’ll get powerful insights. Take your database query skills to the next level with this second SQL course. Often, you need multiple tables in order to keep data integrity and avoid duplication. In this course, we’ll teach you how to easily deal with more than one table. Master the process of data manipulation and work with more complex interrelated multi-table databases. This course follows our Introduction to SQL course. Take a quick look at what it covers and if you’re comfortable with those concepts, then dive into Intermediate SQL!

Data Manipulations

Table Constraints

Working with Data

certificate

Your Certificate is close

You are doing great! Keep learning to unlock your certificate!

Blog

blog
How Marketers Use SQL
By using SQL to analyze your databases and follow a data driven marketing strategy, you can be much more effective at organizing, analyzing, and applying data to your marketing campaigns.
Continue reading on our blog
blog
CHEAT SHEET: What Is A SQL Injection?
One of the most common web hacking techniques, an SQL injection is a method for attacking and manipulating underlying databases. From providing access to protected data, to gaining access to manipulate the database of the targeted application, this tool is a common threat for most website and application managers. Our guide walks you through this widespread threat so you can protect your own applications from it.
Continue reading on our blog
blog
What Is SQL Used For?
SQL is the commonly used acronym for Structured Query Language, the standard language for relational database management systems. SQL traces its origins all the way back to 1973, when it was initially created by a team at IBM to manipulate and retrieve the data stored in their system at the time.
Continue reading on our blog