-
Course
- Data
PostgreSQL: Advanced SQL Queries
In this course, we will discuss advanced queries for PostgreSQL. We will learn about functions and operators, type conversions, and transactions.
What you'll learn
PostgreSQL is commonly known as Postgress. It is often referred to as the world’s most advanced open source database. In this course, we will discuss advanced queries for PostgreSQL. We will learn about functions and operators, type conversions, and transactions.
Table of contents
- Introduction | 1m 53s
- Operators and Functions | 1m 6s
- Real World Scenarios | 1m 27s
- Logical Operators | 1m 25s
- Scenario 1: Logical Operators | 59s
- Demo 1: Logical Operators | 5m 9s
- Scenario 2: Comparison Operators | 1m 8s
- Demo 2: Comparison Operators | 3m 32s
- Scenario 3: Mathematical Operators & Functions | 2m 10s
- Demo 3: Mathematical Operators & Functions | 5m 26s
- Scenario 4: Mathematical Advanced Operators & Functions | 1m 1s
- Demo 4: Mathematical Advanced Operators & Functions | 1m 40s
- Scenario 5: String Operators & Functions | 1m 45s
- Demo 5: String Operators & Functions | 7m 50s
- Scenario 6: Date Time Operators & Functions | 3m 35s
- Demo 6: Date Time Operators & Functions | 6m 50s
- Scenario 7: Aggregate Functions | 1m 45s
- Demo 7: Aggregate Functions | 3m 50s
- Summary | 1m 36s