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

Data Formatting
SQL SELF
5 level,0 lecture
Learn how to use SQL and PostgreSQL to make your data look nice and easy to read: format strings, numbers, dates, pull out unique values, and prep reports for people and systems.
Open
String Formatting: CONCAT(), UPPER(), LOWER()
SQL SELF
5 level,1 lecture
Learn how to join and change string case in SQL using the CONCAT, UPPER, and LOWER functions. Real-life examples for working with names and email addresses in your database.
Open
Date and Time Formatting: NOW(), CURRENT_DATE, DATE_PART()
SQL SELF
5 level,2 lecture
Learn how to work with dates and time in PostgreSQL: get the current date and time, extract date parts, filter and group by time. Real-life examples and common mistakes when working with dates.
Open
Data Type Conversion with CAST() and :: — Examples and Gotchas
SQL SELF
5 level,3 lecture
How and why to use CAST() and the :: operator for data type conversion in PostgreSQL: examples, syntax, common mistakes, and practical tips.
Open
Real-World Data Formatting Examples
SQL SELF
5 level,4 lecture
Practical examples of formatting and presenting data in SQL: joining fields, date conversion, number formatting, filtering, sorting, and working with unique values to create handy and good-looking reports.
Open