SQL Tutorials

Learn how first normal form (1NF) can improve your database design by enforcing atomicity in your tables.

Discover how to master SQL subqueries to enhance your database queries. Learn about correlated, non-correlated, and recursive subqueries. Learn about execution order and how to combine SQL subqueries with other SQL features.

Understand how to exploit SQL’s CASE statement to create categorical columns.

Understand how to use SQL String Functions to clean and process text data efficiently.

Discover SQL transactions, their importance, and how to implement them for reliable database management.

Discover the fundamentals of Cartesian products in SQL. Learn when and how to use them effectively, and explore best practices to optimize performance.

Understand how materialized views improve query performance in SQL databases. Learn the limitations and best practices of materialized views in different databases.

Learn how to effectively join three tables in SQL. Discover practical methods and examples to enhance your data manipulation skills. Master SQL joins with ease.

Learn the basics of SQL stored procedures and how to implement them in different databases, including MySQL and SQL Server.

Learn how second normal form (2NF) can improve your database design by eliminating partial dependencies.

Learn the art of pivoting rows into columns in SQL in Oracle, MySQL, and SQL Server. Explore practical methods with detailed examples to boost your data engineering skills.

Understand how to use common table expressions to simplify complex queries for improved readability. Learn the difference between non-recursive and recursive CTEs.