Free SQL Resources, Shortcuts, Tutorials, & Guides

Mar 11, 2025 17 min read

Views in SQL

Ever wondered how to securely share your best queries and keep sensitive data private? Learn how database views simplify querying, protect information, and make…

Dan Rodney

Feb 21, 2025 19 min read

Exercise - Outer Join and NULL in SQL

Explore SQL joins and master handling NULL values effectively in your queries. Discover practical techniques and tackle coding challenges to sharpen your…

Dan Rodney

Feb 12, 2025 2 min read

Finding Datasets in SQL

Finding interesting datasets online is easy—but how do you turn them into a usable database? Discover the challenges and solutions for transforming datasets…

Dan Rodney

Dec 24, 2024 4 min read

Filtering with WHERE in SQL

Ever wondered why your database isn't providing helpful code hints? Explore essential tips to ensure you're connected correctly and master price filtering…

Dan Rodney

Nov 14, 2024 11 min read

Joins - Combining Data from Multiple Tables in SQL

Unlock the power of SQL joins by discovering how tables connect using inner joins. Learn how table aliases simplify queries, saving you time and streamlining…

Dan Rodney

Oct 3, 2024 4 min read

Date Functions in SQL

Dates and timestamps can be tricky, but mastering their functions unlocks powerful SQL capabilities. Learn how to manipulate and extract date and time data…

Dan Rodney

Sep 8, 2024 28 min read

Solution - Outer Join and NULL in SQL

Mastering database joins can seem tricky at first, but it's all about understanding how tables connect. Discover how to easily spot products that haven't sold…

Dan Rodney

Aug 31, 2024 13 min read

Basics of Learning the SQL Language

Mastering SQL means understanding the language's structured order and why repetition is key to building fluency. Explore practical SQL techniques like column…

Dan Rodney

Jul 28, 2024 6 min read

Aggregate Functions in SQL

Aggregate functions can transform your SQL queries from simple lists of data into meaningful insights. Learn how functions like SUM, AVG, MIN, MAX, and COUNT…

Dan Rodney

Jul 16, 2024 12 min read

Cast Function in SQL

Data types control how information is stored in databases—so what happens when you need numbers stored as text to behave like numeric data? Learn how the CAST…

Dan Rodney

Jun 19, 2024 8 min read

String Functions in SQL

Ever wondered how to quickly manipulate strings in your databases or queries? Discover powerful SQL string functions that simplify tasks like formatting zip…

Dan Rodney

Jun 9, 2024 14 min read

Conditionals in SQL

SQL doesn't do if-else logic like other programming languages—but it does have something just as powerful: the CASE statement. Discover how you can easily…

Dan Rodney

Jun 7, 2024 15 min read

Exercise - Inner Join in SQL

Ever wondered how to connect employee names with department details in SQL? Explore the magic behind INNER JOIN statements and learn to combine tables…

Dan Rodney

May 14, 2024 15 min read

Exercise - 2.0 Date Functions in SQL

Mastering date functions in SQL can streamline your queries and unlock powerful data insights. Discover practical tips like extracting date parts, converting…

Dan Rodney

May 9, 2024 18 min read

Solution - Subqueries in SQL

Wondering when to use JOINs versus subqueries in SQL? Learn why JOINs often outperform subqueries—and how choosing the right method simplifies your database…

Dan Rodney

Apr 26, 2024 13 min read

Connecting to a SQL Database

Unlock the power of databases by mastering connections with DBeaver. Learn how to effortlessly navigate, manage, and explore your data with this step-by-step…

Dan Rodney

Apr 9, 2024 1 min read

Views Solution in SQL

Discover how simple filtering can unlock powerful insights from user spending data. Learn quick ways to pinpoint high-value customers using straightforward…

Dan Rodney

Apr 8, 2024 10 min read

Solution - AI and SQL

Unlock the power of ChatGPT to effortlessly create accurate SQL queries—but learn how specificity is key. Discover how AI can help you craft robust SQL…

Dan Rodney

Apr 2, 2024 18 min read

Inner vs. Outer Joins in SQL

Unlock the power of SQL joins by mastering inner and outer joins, and discover how to effectively combine data from multiple tables. Learn when to use left and…

Dan Rodney

Mar 31, 2024 4 min read

Combining Filters and Aliases in SQL

Ready to master SQL logic and simplify your queries? Discover how AND, OR, and NOT can powerfully shape your data results!

Dan Rodney

Learn SQL