Chapter 1
Advanced
- Window Functions: Learn how to use window functions to calculate aggregates over a sliding window of rows.
- Advanced Joins: Learn how to use advanced joins like LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN, as well as self-joins.
- Recursive Queries: Learn how to write recursive queries that enable you to traverse hierarchical data structures.
- Performance Tuning: Learn how to optimize your queries by using indexing, query hints, and other performance-tuning techniques.
- Transactions and Locking: Learn how to use transactions to ensure data consistency and avoid race conditions, and how to use locking to manage concurrency.
- Stored Procedures and Functions: Learn how to write stored procedures and functions to encapsulate complex SQL logic and improve application performance.
- Query Optimization: Learn how to use query optimization techniques such as query rewriting, query expansion, and query planning.
- Advanced Subqueries: Learn how to use correlated subqueries, inline views, and common table expressions (CTEs) to solve complex problems.
- Database Administration: Learn about database administration tasks such as backup and recovery, security, and database performance monitoring.
- Advanced Analytics: Learn how to use SQL to perform advanced analytics, such as time series analysis, forecasting, and predictive modeling.
Connect with me on LinkedIn: Himanshu Ramchandani