BASIC · UNDERGRADUATE SQL COURSE
CIS SQL Essentials
A complete 16-chapter SQL course designed for undergraduate study. Covers everything from schema design to stored procedures, triggers, and a cybersecurity-focused capstone project. Combines instructional markdown, SQL scripts, Jupyter notebooks, and lab assignments. Primary platform: MySQL — with PostgreSQL and T-SQL comparisons.
COURSE OUTLINE — 2 CHAPTERS FREE
16 CHAPTERS + CAPSTONE1
Database Fundamentals & Schema Design
FREE2
Data Retrieval — SELECT, WHERE, ORDER BY
FREE3
Joins — INNER, LEFT, CROSS, SELF
4
Aggregation — COUNT, SUM, GROUP BY, HAVING
5
Subqueries and Correlated Subqueries
6
Data Manipulation — INSERT, UPDATE, DELETE
7
Views, Indexes, and Query Optimization
8
Stored Procedures and Functions
9
Transactions, Locks, and Concurrency
10
Triggers and Scheduled Events
11
Administration — Users, Roles, Permissions
12
Backup, Recovery, and Security Hardening
13
MySQL vs PostgreSQL vs T-SQL Syntax
14
Window Functions and CTEs
15
Database Design Patterns and Normalization
16
Capstone — Cybersecurity Database Project
14 locked chapters + capstone unlock with BASIC.
UNLOCK — $25/MO Chapters
16 + Capstone
SQL Platform
MySQL + PostgreSQL
Format
Markdown + Notebooks
Level
Undergraduate
BASIC — $25/mo
CIS SQL Essentials · CISSQLexe Console · Opt-Out Manual · Intel Feed · Private Discord