SQL Basics

Name: SQL Basics
Availability: InStock
Author: FreeAcademy

61 estudiantes

44Lecciones

BeginnerNivel

GratisCertificado

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.

Contenido del Curso

8 módulos • 44 lecciones

Module 1: Understanding SQL and Databases

4 lecciones

1.1

Why SQL Databases Dominate

Module 2: Writing Your First SQL Queries

4 lecciones

2.1

Setting Up Your SQL Environment (PostgreSQL)

2.2

Your First SQL Query - SELECT Basics

2.3

Filtering Data with WHERE

2.4

Sorting Results with ORDER BY

Module 3: Working with Data

6 lecciones

3.1

INSERT - Adding New Data

3.2

UPDATE - Modifying Existing Data

3.3

DELETE - Removing Data

3.4

Data Types in SQL

3.5

Working with NULL Values

3.6

Best Practices for Data Manipulation

Module 4: Querying Multiple Tables

6 lecciones

4.1

Understanding Relationships and Keys

4.2

INNER JOIN - Combining Related Data

4.3

LEFT JOIN and RIGHT JOIN

4.4

FULL OUTER JOIN

4.5

Self Joins and Multiple Joins

4.6

When to Use Which Join

Module 5: Aggregate Functions and Grouping

5 lecciones

5.1

COUNT, SUM, AVG, MIN, MAX

5.2

GROUP BY - Organizing Results

5.3

HAVING - Filtering Groups

5.4

Combining Aggregates with Joins

5.5

Common Aggregation Patterns

Module 6: Advanced Query Techniques

6 lecciones

6.1

Subqueries in SELECT, FROM, and WHERE

6.2

Common Table Expressions (CTEs)

6.3

CASE Statements for Conditional Logic

6.4

DISTINCT and Removing Duplicates

6.5

LIMIT and Pagination

6.6

String Functions and Pattern Matching (LIKE, ILIKE)

Module 7: Database Design Fundamentals

6 lecciones

7.1

Creating Tables with CREATE TABLE

7.2

Primary Keys and Constraints

7.3

Foreign Keys and Referential Integrity

7.4

Indexes - Making Queries Faster

7.5

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

7.6

Schema Design Best Practices

Module 8: Practical SQL Projects (Capstone)

7 lecciones

8.1

Project Overview - Building a Business Database

8.2

Designing Your Schema

8.3

Loading Sample Data

8.4

Common Business Queries

8.5

Creating Reports with SQL

8.6

Performance Optimization Basics

8.7

Next Steps in Your SQL Journey

Reseñas

Inicia sesión para dejar una reseña

SQL Basics

Contenido del Curso