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