This lecture introduces Common Table Expressions (CTEs). As your SQL queries become more complex, especially with multiple subqueries or joins, they can become difficult to… Read More »Lecture 49: Organizing Complex Queries with CTEsv
This lecture covers common SQL date and time functions. Dates and times are a special type of data that often require specific functions for manipulation… Read More »Lecture 48: Working with Dates and Times
This lecture covers common SQL numeric functions. Just as we can manipulate text with string functions, SQL provides a variety of numeric functions to perform calculations, rounding,… Read More »Lecture 47: Working with: Numeric Functions
This lecture covers common SQL string functions. Data often comes in text format, and sometimes you need to clean it up, extract parts of it,… Read More »Lecture 46: Working with Text: String Functions
This lecture covers the HAVING clause and CASE statements. We’ve learned how to filter individual rows using `WHERE` and how to group rows using `GROUP… Read More »Lecture 45 – Filtering Groups with Statements
This lecture covers advanced queries with aggregate functions on the student enrollment system. Now that we’re comfortable with basic joins, let’s use our knowledge of… Read More »Lecture 44: Final Project – Advanced Queries
This lecture covers basic queries on the student enrollment system. Our Student Enrollment System is fully set up and populated. Now, let’s start extracting meaningful… Read More »Lecture 43: Final Project – Basic Queries
This lecture covers populating the student enrollment system with sample data. Our Student Enrollment System database is structured and ready. Now, let’s fill it with… Read More »Lecture 42: Final Project – Populating the Data
This lecture covers creating the tables for the student enrollment system. With our database schema designed, it’s time to translate it into SQL. We will… Read More »Lecture 41: Final Project – Creating the Tables
This lecture begins the design of a student enrollment system. Welcome to Part 5 of the series and our final project. We will build a… Read More »Lecture 40: Student Enrollment System