List of lectures for the course SQL, 32 quest level on JavaRush

Rounding and Trimming Temporal Data: DATE_TRUNC()
SQL SELF
32 level,0 lecture
The DATE_TRUNC() function lets you trim temporal values down to the time unit you need — year, month, day, hour, etc. It's an essential tool for analyzing and grouping temporal data in SQL. On this page, you'll learn how to use DATE_TRUNC() in practice, see some examples, and break down common mistakes.
Open
Working with Unix Time: EPOCH
SQL SELF
32 level,1 lecture
Learn what Unix time (EPOCH) is, how to convert dates to and from this format in PostgreSQL, and how to use it for storing and analyzing time data. Real-life examples, tips, and common mistakes.
Open
Working with Time Zones: TIMEZONE
SQL SELF
32 level,2 lecture
Learn how to properly handle time zones in PostgreSQL: the difference between TIMESTAMP and TIMESTAMPTZ, converting time between time zones, practical examples, and tips to avoid common date and time mistakes.
Open
Window Functions for Time Data: LEAD(), LAG()
SQL SELF
32 level,3 lecture
Learn how to use window functions LEAD() and LAG() to analyze time data in SQL: comparing events, calculating time differences, grouping by users, and common mistakes when working with time series.
Open
Common Mistakes When Working with Dates and Time
SQL SELF
32 level,4 lecture
Working with dates and time in databases and apps often leads to unexpected bugs: from picking the wrong data type to getting confused with time zones and formats. In this material, we’ll check out the most common mistakes related to handling dates and time, and give you some practical tips on how to avoid them.
Open