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

Intro to SQL with PostgreSQL

Go to class Write review

Overview

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.

Syllabus

Unit 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

Unit 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

Unit 3: Application of WHERE Clause

Fetching Phase 1 Movies
Filtering Phases
Fix the SQL Query
Filtering Movies by Release Year
Fetching Pre-2010 Movies

Unit 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

Unit 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

Reviews

Start your review of Intro to SQL with PostgreSQL