Overview
Learn advanced data analysis with SQL, and master topics like subqueries, CTEs, window functions, and more
Syllabus
-
- Introduction to Advanced SQL Concepts
-- Review of the "Big 6" Clauses (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY)
-- Overview of Advanced SQL Topics
- Advanced Join Techniques
-- Inner and Outer Joins in Complex Queries
-- Self Joins and Recursive CTEs
-- Intersection and Exclusion Joins
- Subqueries and Derived Tables
-- Correlated and Uncorrelated Subqueries
-- Using Subqueries in SELECT, FROM, and WHERE Clauses
-- Derived Tables and Inline Views
- Advanced Aggregation and Analytical Functions
-- Window Functions (ROW_NUMBER, RANK, DENSE_RANK)
-- Using PARTITION BY and ORDER BY in Analytics
-- Advanced Grouping: GROUPING SETS, CUBE, and ROLLUP
- Set Operations
-- Union, Intersect, and Except
-- Combining Results from Multiple Queries
-- Practical Use Cases for Set Operations
- Advanced Filtering and Searching
-- Using Regular Expressions in SQL
-- Full-Text Search Capabilities
-- Advanced Pattern Matching Techniques
- Performance Optimization
-- Query Execution Plans
-- Indexing Strategies for Complex Queries
-- Caching and Materialized Views for Faster Results
- Managing Data with Advanced SQL
-- Advanced INSERT, UPDATE, DELETE Operations
-- Implementing Transactions and Error Handling
-- Data Security and Access Control
- Hands-On Project: Real-world Data Analysis
-- Designing a comprehensive analytical SQL project
-- Applying advanced querying techniques to business scenarios
-- Presenting and interpreting SQL query results
- Conclusion and Further Learning
-- Summary of Key Concepts
-- Resources for Continued Study in SQL and Data Analysis
Taught by
Maven Analytics and Alice Zhao
Tags
On-Demand
