5 Free AI Tools | No Tech Skills Needed
5 Free AI Tools That Can Help You Earn Extra Income in 2026 (No Tech Skills Needed) Let’s be honest: Everyone wants to make extra… Read More »5 Free AI Tools | No Tech Skills Needed
Tech
Lecture 26: Simplifying Queries with Table Aliases
This lecture covers using table aliases to simplify queries. In our last few lectures, we wrote queries that joined tables. You probably noticed that we… Read More »Lecture 26: Simplifying Queries with Table Aliases
Learn Databases: Lecture 25 – The LEFT JOIN
This lecture covers the LEFT JOIN. In the last lecture, we saw that an INNER JOIN only returns rows where a match is found in both tables.… Read More »Learn Databases: Lecture 25 – The LEFT JOIN
Lecture 24: Combining Tables with INNER JOIN
This lecture covers the INNER JOIN to combine data from multiple tables. We have created separate `Customers` and `Orders` tables and linked them with a… Read More »Lecture 24: Combining Tables with INNER JOIN
Lecture 23: Linking Tables with Foreign Keys
This lecture introduces the concept of Foreign Keys. If the primary key is the anchor of a table, the foreign key is the chain that links it… Read More »Lecture 23: Linking Tables with Foreign Keys
Lecture 22: The Importance of Primary Keys
This lecture introduces the concept of Primary Keys. Welcome to Part 3 of our series. So far, we have worked with single tables. But the… Read More »Lecture 22: The Importance of Primary Keys
Lecture 21: Mini-Project – Student Grades Part 2
This lecture concludes the student grades mini-project with data analysis. Welcome back. In the last lecture, we created our `Grades` table and filled it with… Read More »Lecture 21: Mini-Project – Student Grades Part 2
Lecture 20: Mini-Project – Student Grades Part 1
This lecture begins a mini-project to analyze student grades. Let’s begin our second mini-project. This time, we will create a database to store student grades… Read More »Lecture 20: Mini-Project – Student Grades Part 1
Lecture 19: Grouping Data with GROUP BY
This lecture introduces the GROUP BY clause. So far, our aggregate functions have given us one single result for the entire table (or a filtered… Read More »Lecture 19: Grouping Data with GROUP BY
Lecture 18 – Finding Minimum and Maximum Values
This lecture covers the MIN() and MAX() aggregate functions. To round out our introduction to aggregate functions, we will look at two simple but very… Read More »Lecture 18 – Finding Minimum and Maximum Values