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 2m
- Operators and Functions 1m
- Real World Scenarios 1m
- Logical Operators 1m
- Scenario 1: Logical Operators 1m
- Demo 1: Logical Operators 5m
- Scenario 2: Comparison Operators 1m
- Demo 2: Comparison Operators 4m
- Scenario 3: Mathematical Operators & Functions 2m
- Demo 3: Mathematical Operators & Functions 5m
- Scenario 4: Mathematical Advanced Operators & Functions 1m
- Demo 4: Mathematical Advanced Operators & Functions 2m
- Scenario 5: String Operators & Functions 2m
- Demo 5: String Operators & Functions 8m
- Scenario 6: Date Time Operators & Functions 4m
- Demo 6: Date Time Operators & Functions 7m
- Scenario 7: Aggregate Functions 2m
- Demo 7: Aggregate Functions 4m
- Summary 2m
About the author
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 81 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.