- Course
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.
Advanced
- Course
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.
Advanced
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
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.
PostgreSQL: Advanced SQL Queries
Advanced
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
Pinal Dave is a Pluralsight Developer Evangelist.