In our SQL Intermediate in R course, you'll extend on the SQL skills you learned in the SQL Fundamentals course. By the end of this course, you'll feel confident in your ability to answer business questions using SQL.
In our hands-on, interactive lessons, you’ll learn concepts such as the different types of joins and how to combine joins with subqueries to answer business questions. You will also learn how to write queries using three or more tables, how to perform recursive joins and pattern matching, and how to control what the data will look like with CASE statements.
As you progress further, you’ll learn how to build and organize complex queries to make them more readable with the WITH clause, and how to use set operations such as UNION, UNION ALL, EXCEPT, and INTERSECT to combine tables. You'll also learn relational database concepts such as normalizing a table, designing and creating a database, and more.
Because our focus is always on real-world application, you’ll learn how to frame business questions as advanced SQL queries and how to write analysis to communicate the results of your work. When you’ve finished the final guided project, you have a great showcase of your SQL skills to present to potential future employers.
By the end of this course, you'll be able to:
Learn Intermediate SQL Techniques
Joining Data in SQL
Learn how to use joins to query data across two tables.
Intermediate Joins In SQL
Learn how to join data from more complex databases and write more complex queries.
Building and Organizing Complex Queries
Learn techniques to organize your queries to make them easier to read and understand.
Answering Business Questions Using SQL
Learn and practice the SQL data analysis workflow.
Table Relations And Normalizations
Learn how to create and modify databases.
Designing And Creating A Database
Learn how to design, create, and populate a normalized SQL database.