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

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

  • Lesson 1: Mastering Text-Based Queries in PostgreSQL
  • Lesson 2: Mastering Subqueries for Data Analysis
  • Lesson 3: Creating New Columns and Mathematical Operations in PostgreSQL
  • Lesson 4: Complex Queries and Conditional Logic in PostgreSQL

Reviews

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

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.