Lecture 33: Advanced Subqueries
This lecture covers more advanced uses of subqueries. In the last lecture, we saw how subqueries can be used in the WHERE clause. Now let’s explore two… Read More »Lecture 33: Advanced Subqueries
Mini-Project
Lecture 32: Introduction to Subqueries
This lecture introduces the concept of subqueries. We are now moving into Part 4 of our series: Advanced Concepts. The first of these is the subquery,… Read More »Lecture 32: Introduction to Subqueries
Lecture 31 – Combining Results with UNION
This lecture covers the UNION and UNION ALL operators. So far, we have only worked with the results from a single SELECT statement at a time (even… Read More »Lecture 31 – Combining Results with UNION
Lecture 30: Mini-Project – Querying the Blog
This lecture covers querying the blog database with joins. Our blog database is designed, created, and populated. Now we get to the payoff: asking complex… Read More »Lecture 30: Mini-Project – Querying the Blog
Lecture 29 – Mini-Project: Populating the Blog
This lecture covers populating the blog database with sample data.Our blog database structure is built, but it’s an empty shell. To make things interesting, we… Read More »Lecture 29 – Mini-Project: Populating the Blog
Lecture 28: Mini-Project – Creating the Blog Tables
Learn Databases: Lecture 28 – Mini-Project: Creating the Blog Tables.This lecture covers the SQL implementation of the blog database design. In the last lecture, we… Read More »Lecture 28: Mini-Project – Creating the Blog Tables
Lecture 27: Mini-Project – Blog Database Design
This lecture begins the design of a multi-table blog database. It’s time for our most ambitious project yet. We are going to design a database… Read More »Lecture 27: Mini-Project – Blog Database Design