Loading...

Data Analytics

280 learners

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.

PostgreSQL

See path

4 lessons

21 practices

1 hour

Data Analysis for Insights

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

Meet Cosmo:

The smartest AI guide in the universe

Our built-in AI guide and tutor, Cosmo, prompts you with challenges that are built just for you and unblocks you when you get stuck.

From our community

Hear what our customers have to say about CodeSignal Learn

I'm impressed by the quality and can't stop recommending it. It's also a lot of fun!

Francisco Aguilar Meléndez

Data Scientist

+11

I love that it's personalized. When I'm stuck, I don't have to hope my Google searches come out successful. The AI mentor Cosmo knows exactly what I need.

Faith Yim

Software Engineer

+14

It's an amazing product and exceeded my expectations, helping me prepare for my job interviews. Hands-on learning requires you to actually know what you are doing.