MIS 3220 / FALL 2026
Database
Management & Design.
Tuesday & Thursday · 2:00–3:15 PM · LSBE 265
YOUR CLASSROOM TOOLKIT
Choose how you want to work.
SQL playground
Switch databases, explore tables, and answer your printed lab questions.
Open workspace ↗02Learning modules
19 lessons with explanations, examples, and interactive SQL exercises.
Find a lesson ↗03Class challenges
Practice with 12 movie questions and check your query results.
Try a challenge ↗04Tables & cheat sheet
Table names, columns, data types, keys, join connections, and SQL syntax.
Open reference ↗YOUR CURRENT MATERIALS
THE FULL SQL LIBRARY
Learning modules.
19 interactive practice lessons recovered from the previous course. Work at your own pace; current assignments and assessment requirements are on Canvas.
SELECT Queries 101
Learn the fundamentals of SQL SELECT statements with the Pixar movies database.
Queries with Constraints (Pt. 1)
Master WHERE clauses and filtering data with basic conditions.
Queries with Constraints (Pt. 2)
Advanced filtering with LIKE, IN, BETWEEN, and text patterns.
Filtering and Sorting Query Results
Learn ORDER BY, LIMIT, and advanced result manipulation.
Simple SELECT Queries Review
Review and practice all single-table query concepts.
Multi-table Queries with JOINs
Combine data from multiple tables using INNER JOIN operations.
OUTER JOINs
Learn LEFT JOIN, RIGHT JOIN, and FULL JOIN to include unmatched rows.
A Short Note on NULLs
Handle NULL values in SQL queries with IS NULL and IS NOT NULL constraints.
Queries with Expressions
Use mathematical expressions, functions, and aliases to transform data in queries.
Queries with Aggregates (Pt. 1)
Summarize data using aggregate functions like COUNT, MIN, MAX, AVG, and SUM with GROUP BY.
Queries with Aggregates (Pt. 2)
Learn advanced aggregate techniques with the HAVING clause to filter grouped results.
Order of Execution of a Query
Understand how SQL processes queries step-by-step and master complex query construction.
Inserting Rows
Learn to add new data to databases using INSERT statements and understand database schemas.
Updating Rows
Learn to modify existing data in databases using UPDATE statements with proper WHERE conditions.
Deleting Rows
Learn to remove data from databases using DELETE statements with proper WHERE conditions and safety practices.
Creating Tables
Learn to create new database tables using CREATE TABLE statements and define table schemas with data types and constraints.
Altering Tables
Learn to modify existing table structures using ALTER TABLE statements to add columns, rename tables, and understand database limitations.
Dropping Tables
Learn to remove entire tables from your database using DROP TABLE statements and understand the implications of destructive operations.
SQL Mastery Challenge
Test your comprehensive SQL knowledge with advanced challenges covering all concepts from basic queries to complex joins and calculations.