SQL COURSE DETAILS

In 5 weeks, you will take an interactive, beginner friendly, and hands-on course designed to teach you SQL Data Analysis from scratch.

Learn Relational Databases, Database and Table creation and modification, Data Manipulation, Simple to Complex Select Queries, Joins and Unions, Nested Queries, Views & More.

NO PRIOR EXPERIENCE NEEDED!!!

COURSE CURRICULUM >

Payment can be submitted in full or using a Bi-weekly Payment Plan. Click below to open the payment plan option.

Payment can be submitted via Zelle or Cashapp if preferred. Contact 540-429-3940 for more details.

ENROLL IN SQL ONLY

BUY SQL CLASS RECORDINGS ONLY

SQL COURSE CURRICULUM

Week 1 – Getting Started with SQL

Introduction to databases and SQL concepts
Installing/connecting to SQL environment (MySQL, PostgreSQL, or SQL Server)
Understanding databases, tables, rows, and columns
Writing your first queries: SELECT, FROM, WHERE

Week 2 – Querying and Filtering Data

Using DISTINCT, ORDER BY, and LIMIT
Filtering with comparison operators, BETWEEN, IN, LIKE
Combining conditions with AND, OR, NOT
Sorting and cleaning query outputs

Week 3 – Aggregation and Joins

Aggregate functions: COUNT, SUM, AVG, MIN, MAX
Grouping and summarizing data with GROUP BY and HAVING
Understanding relationships between tables
Writing different types of joins: INNER, LEFT, RIGHT, FULL

Week 4 – Intermediate to Advanced SQL Features

Subqueries and nested queries
Common Table Expressions (CTEs)
Window functions (ROW_NUMBER, RANK, PARTITION BY)
Data modification: INSERT, UPDATE, DELETE
Introduction to database design concepts (keys, constraints, normalization)
Creating and managing views (CREATE VIEW, ALTER VIEW, DROP VIEW)
Benefits of views for security, abstraction, and simplifying complex queries

Week 5 – Real-World Projects & Reporting

End-to-end project: querying a business dataset
Building reports from SQL queries
Exporting and connecting SQL queries to BI tools (Excel, Power BI, Tableau)
Best practices for query writing and optimization