Advanced SQL
Master of Science in Computer Science · University · Database Systems
This unit delves into advanced SQL concepts, empowering you to master subqueries, joins, aggregation functions, and window functions. By the end, you'll possess a comprehensive understanding of these techniques and their applications in real-world database scenarios.
What's included
- Subqueries
- Types of subqueries
- Using subqueries to solve complex queries
- Joins
- Types of joins
- Using joins to combine data from multiple tables
- Aggregation Functions
- Common aggregation functions
- Using aggregation functions to summarize data
- Window Functions
- Types of window functions
- Using window functions to perform calculations on a set of rows
Keywords
- Query Optimization
- Database Design
- SQL Server
- MySQL
- PostgreSQL
- Oracle