April 17, 2026
Getting Started & Your First SQL Query
Explore a database and write SQL queries using dBeaver, adjusting preferences and viewing sample data. Watch this tutorial to learn the key concepts and...
Dan Rodney
Learn SQL: Tutorials, Guides & Career Resources
Free SQL Resources & Tutorials
76 articles in SQL
April 17, 2026
Challenge - AI and SQL
Use Chat2BT to generate SQL queries based on database screenshots and analyze your data. Watch this tutorial to learn the key concepts and techniques.
Dan Rodney
April 17, 2026
Solution - Like and Wildcards in SQL
Use wildcards sparingly and verify query results carefully to avoid false positives. Watch this tutorial to learn the key concepts and techniques.
Dan Rodney
April 17, 2026
Pattern Matching in SQL
Next topic. When we're doing these filters, sometimes we're looking for exact matches.
Dan Rodney
April 17, 2026
CASE Exercise in SQL
We want to create categories for, let's say, West Coast and Other. Of course, you can create whatever number of coasts or regions you want.
Dan Rodney
April 17, 2026
Coding Exercise in PostgreSQL
Practice SQL queries in exercise 1C using DBeaver and connect to the correct database. Watch this tutorial to learn the key concepts and techniques.
Dan Rodney
April 17, 2026
AI and SQL - Hands On Challenge - Solution
Okay, let's talk through the first challenge. Where did our revenue in 2021 come from? How much were we making in each state? So the first thing I need to do...
Dan Rodney
April 17, 2026
Solution- 2.0 Date Functions in SQL
Use SQL functions like DATE_PART, DISTINCT, WHERE, BETWEEN, MAX, and COUNT to filter, organize, and aggregate data based on dates and times. Watch this...
Dan Rodney
April 17, 2026
Benefits of Learning SQL
Learn to connect, navigate, and query databases using PostgreSQL with dBeaver. Watch this tutorial to learn the key concepts and techniques.
Dan Rodney
April 17, 2026
Database Terminology and Primary & Foreign Keys in SQL
To understand some things that we're going to learn in just a moment, we're going to learn about joins. Joins are a way to take two tables and put them...
Dan Rodney
April 17, 2026
Solution- Filtering with WHERE in SQL
Use SQL to filter, sort, calculate, and remove duplicates from query results. Watch this tutorial to learn the key concepts and techniques.
Dan Rodney
April 17, 2026
Like and Wildcards in SQL
Practice using LIKE and wildcards by completing the warmups and challenge questions in the file "2.0 like and wild cards.". Watch this tutorial to learn the...
Dan Rodney
April 17, 2026
Data Types and Filtering Results in SQL
When we think about columns, we think about a kind of data. And it's very important to understand that the columns are assigned a data type by the person who...
Dan Rodney
April 17, 2026
SQL Learning Resources
At the very last slide, I’ve got some learning resources for you. So there's sqlcourse.
Dan Rodney
April 17, 2026
Solution- Aggregate Function and ROUND in SQL
Approach SQL queries incrementally to ensure accuracy and clarity. Watch this tutorial to learn the key concepts and techniques.
Dan Rodney
April 17, 2026
How to Leverage AI in SQL
Use AI tools like ChatGPT to explain, rewrite, optimize, and debug SQL queries, and to convert SQL code between different database dialects. Watch this...
Dan Rodney
April 17, 2026
Solution- Inner Join in SQL
Use SQL JOINs to retrieve name and email information for users who purchased individual line items worth $700 or more. Watch this tutorial to learn the key...
Dan Rodney
April 17, 2026
Solution to PostgreSQL Coding Challenge
Explain SQL query basics, including SELECT, FROM, LIMIT, ORDER BY, and DISTINCT, using practical examples. Watch this tutorial to learn the key concepts and...
Dan Rodney
April 17, 2026
Solution WIndow Functions in SQL
Use window functions with partition by to retain detailed data while calculating group-based aggregates. Watch this tutorial to learn the key concepts and...
Dan Rodney
April 17, 2026
Grouping Data in SQL
Explain how to use SQL GROUP BY to perform aggregations on grouped data. Watch this tutorial to learn the key concepts and techniques.
Dan Rodney