Advanced Query Techniques and Conditional Logic in PostgreSQL

This course is designed to help you deepen your PostgreSQL expertise, focusing on mastering subqueries, AND/OR logical operators, and conditional statements like ILIKE, IN, and BETWEEN. Ideal for those with a basic understanding of SQL, looking to enhance their data querying capabilities using PostgreSQL's advanced features.

Lessons and practices

Lesson 1: Mastering Text-Based Queries in PostgreSQL

Filtering Marvel Movie Names

Exploring Case Sensitive Queries

Expanding Query Filtering

Finding Actor Names

Extracting Superhero Names by Suffix

Finding Alter Ego Names

Lesson 2: Mastering Subqueries for Data Analysis

Mastering Subqueries in PostgreSQL

Budget Subquery

Fix the SQL Query

Filtering by Multiple Subqueries

Advanced Subquery Practice

Lesson 3: Creating New Columns and Mathematical Operations in PostgreSQL

String Concatenation in SQL

Converting Minutes to Hours

SQL Super Bug

Calculating Movie ROI

Average IMDb Rating by Phase

Lesson 4: Complex Queries and Conditional Logic in PostgreSQL

Categorize Characters by Movie Count

Categorize Movies by Earnings

Categorizing Phase Lengths

Categorize Movies Freshness

Putting it All Together

Interested in this course? Learn and practice with Cosmo!

Practice is how you turn knowledge into actual skills.