SQL Basics

Name: SQL Basics
Availability: InStock
Author: FreeAcademy

44Aulas

BeginnerNível

GratuitoCertificado

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.

Conteúdo do Curso

8 módulos • 44 aulas

Module 1: Understanding SQL and Databases

4 aulas

1.1

Why SQL Databases Dominate

Module 2: Writing Your First SQL Queries

4 aulas

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 aulas

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 aulas

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 aulas

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 aulas

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 aulas

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 aulas

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

Avaliações

Faça login para deixar uma avaliação

SQL Basics

Conteúdo do Curso