Intermediate SQL in R
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:
- Query data across multiple tables.
- Answer business questions using SQL.
- Understand table relations and how to create and modify databases.
Intermediate SQL in R Lessons List
Learn how to use joins to query data across two tables.
Learn how to join data from more complex databases and write more complex queries.
Learn techniques to organize your queries to make them easier to read and understand.
Learn and practice the SQL data analysis workflow.
Learn how to create and modify databases.
Learn how to design, create, and populate a normalized SQL database.