Intro to SQL with PostgreSQL

Kick off your data analysis journey by diving into SQL, leveraging the powerful features of PostgreSQL. This course is designed to help you ask the right questions to a database, find specific information, and comprehend basic data relationships. Perfect for beginners, all you need is curiosity about data and an interest in PostgreSQL's unique capabilities.

Lessons and practices

Lesson 1: Introduction to Databases, SQL, and Writing First Query

Listing Database Tables

Listing Movies: First Five Entries

Identifying SQL Query Errors

List Only a Few Characters

Simple SQL Query

Lesson 2: Exploring SELECT Statements

Select Data from Movies Table

Select a Single Column

Fix the SQL Query

Using Aliases in SQL Queries

Renaming Columns with Aliases

Lesson 3: Application of WHERE Clause

Fetching Phase 1 Movies

Filtering Phases

Fix the SQL Query

Filtering Movies by Release Year

Fetching Pre-2010 Movies

Lesson 4: SELECT Statements with Logical Operators

Querying Movies with Logical Operators

Combining Logical Operators

Fixing SQL Logical Conditions

Query Movies Released in 2022

Advanced Filtering with Logical Operators

Lesson 5: Understanding the ORDER BY Clause for Sorting Data

Fetching Movie Names and Dates

Sort Movie Releases by Date

Fix the SQL Query

Sort Movie Data by Ratings

Sorting Data by Budget

Interested in this course? Learn and practice with Cosmo!

Practice is how you turn knowledge into actual skills.