Chapter 15: Advanced SQL
After getting comfortable with SQL basics and diving deep into its querying functionalities in the previous chapters, it's now time to take another step forward into the world of Advanced SQL. This chapter is designed to expose you to the more complex capabilities of SQL, which will help you master the art of managing and manipulating data.
As you move through this chapter, you will uncover the power and flexibility that SQL provides for manipulating and analyzing data on a deeper level. You will learn how to use subqueries to extract data from one or more tables, and how to use advanced joins to combine data from multiple tables based on common columns.
In addition to that, you will be introduced to transactions and ...
Get Python and SQL Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
