Advanced SQL Tutorials
Enhance SQL skills with CTEs, temp tables, string functions, stored procedures, and subqueries for advanced database management and analysis.
Using SQL Views in Databricks and Apache Spark - Lesson 12
Learn to create and utilize SQL views in Databricks for efficient data analysis and pipeline reuse. Explore common table expressions, aggregations, and case statements for advanced querying techniques.
Azure Databricks SQL Introduction and Deep Dive
Explore Azure Databricks SQL in notebooks, covering syntax, widgets, databases, and advanced techniques for efficient data manipulation and analysis.
MySQL 8 - A New Beginning
Explore MySQL 8's major redesign, including data dictionary, windowing functions, JSON enhancements, and optimizer improvements for a better database experience.
Common Table Expressions - Advanced
Explore advanced Common Table Expressions: recursive queries, hierarchical data, data manipulation, common use cases, performance considerations, and classic recursive algorithms in SQL Server.
A Game of Hierarchies - Graph Processing with SQL Server 2019
Explore hierarchies and graph processing in SQL Server 2019 using "Game of Thrones" examples. Learn best practices for transforming complex data structures into useful information.
Awesome SQL – Tips and Tricks for Application Developers
Discover advanced SQL techniques for modern application development, including window functions, CTEs, JSON handling, and efficient pagination methods to enhance query performance and functionality.
Modern SQL - Lecture 2
Explore advanced SQL concepts and techniques for efficient database management and querying in modern systems.