Advanced Query Techniques and Conditional Logic in PostgreSQL | CodeSignal Learn

Data Science & Analytics

1,700 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

4 lessons

21 practices

Less than 2 hours

Data Analysis for Insights

Course details

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

Previous Course

Turn screen time into skills time

Practice anytime, anywhere with our mobile app.

Sign up

Join the 1M+ learners on CodeSignal

Be a part of our community of 1M+ users who develop and demonstrate their skills on CodeSignal

Scan to download

Company

About Careers Leadership Talent Science Newsroom

Collections

Generative AI Business & Leadership Interview Prep AI & Machine Learning Learn to Code Data Science & Engineering

Platform

Platform Overview Skills Assessments Live Tech Interviews AI Interviewer AI Role-Play AI Tutoring with Cosmo

Roles

Talent Acquisition Engineering Leaders Sales Leaders CS & Support Leaders IO Psychologists Individuals

Resources

Resource Library Blog Customer Stories Interview Prep API Docs

Support

Copyright © 2026 CodeSignal

Privacy Terms Compliance & Trust

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.

Alex Bush

Full Stack Engineer

+9

I'm really impressed by the AI tutor Cosmo's feedback about my code. It's honestly kind of insane to me that it's so targeted and specific.

Abbey Helterbran

Tech consultant

+8

I tried Leetcode but it was too disorganized. CodeSignal covers all the topics I'm interested in and is way more structured.

Jonathan Miller

Senior Machine Learning Engineer

+12

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

name

Francisco Aguilar Meléndez

Data Scientist

+11