SQL Basics

Name: SQL Basics
Availability: InStock
Author: FreeAcademy

Beginner

No prior knowledge required. Starts from basics.

Master the fundamentals of SQL from scratch. Learn to query, manipulate, and design databases using PostgreSQL. Build real-world database systems through hands-on exercises and a capstone project. No prior database experience required.

Please sign in to enroll in this course

Course Content

8 modules • 44 lessons

Module 1: Understanding SQL and Databases

4 lessons

1.1

SQL Basics

Course Content

Module 1: Understanding SQL and Databases

What is SQL and Why Learn It?

Understanding Databases - How Data is Stored on Disk

SQL vs NoSQL vs Vector Databases

Why SQL Databases Dominate

Module 2: Writing Your First SQL Queries

Setting Up Your SQL Environment (PostgreSQL)

Your First SQL Query - SELECT Basics

Filtering Data with WHERE

Sorting Results with ORDER BY

Module 3: Working with Data

INSERT - Adding New Data

UPDATE - Modifying Existing Data

DELETE - Removing Data

Data Types in SQL

Working with NULL Values

Best Practices for Data Manipulation

Module 4: Querying Multiple Tables

Understanding Relationships and Keys

INNER JOIN - Combining Related Data

LEFT JOIN and RIGHT JOIN

FULL OUTER JOIN

Self Joins and Multiple Joins

When to Use Which Join

Module 5: Aggregate Functions and Grouping

COUNT, SUM, AVG, MIN, MAX

GROUP BY - Organizing Results

HAVING - Filtering Groups

Combining Aggregates with Joins

Common Aggregation Patterns

Module 6: Advanced Query Techniques

Subqueries in SELECT, FROM, and WHERE

Common Table Expressions (CTEs)

CASE Statements for Conditional Logic

DISTINCT and Removing Duplicates

LIMIT and Pagination

String Functions and Pattern Matching (LIKE, ILIKE)

Module 7: Database Design Fundamentals

Creating Tables with CREATE TABLE

Primary Keys and Constraints

Foreign Keys and Referential Integrity

Indexes - Making Queries Faster

Basic Normalization (1NF, 2NF, 3NF)

Schema Design Best Practices

Module 8: Practical SQL Projects (Capstone)

Project Overview - Building a Business Database

Designing Your Schema

Loading Sample Data

Common Business Queries

Creating Reports with SQL

Performance Optimization Basics

Next Steps in Your SQL Journey