Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

CodeSignal

Advanced Query Techniques and Conditional Logic in PostgreSQL

via CodeSignal

Go to class Write review

Overview

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.

Syllabus

  • Unit 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
  • Unit 2: Mastering Subqueries for Data Analysis
    • Mastering Subqueries in PostgreSQL
    • Budget Subquery
    • Fix the SQL Query
    • Filtering by Multiple Subqueries
    • Advanced Subquery Practice
  • Unit 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
  • Unit 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

Reviews

Start your review of Advanced Query Techniques and Conditional Logic in PostgreSQL

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.