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
Filtering Marvel Movie Names
Exploring Case Sensitive Queries
Expanding Query Filtering
Finding Actor Names
Extracting Superhero Names by Suffix
Finding Alter Ego Names
Mastering Subqueries in PostgreSQL
Budget Subquery
Fix the SQL Query
Filtering by Multiple Subqueries
Advanced Subquery Practice
String Concatenation in SQL
Converting Minutes to Hours
SQL Super Bug
Calculating Movie ROI
Average IMDb Rating by Phase
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.