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