Clinical Professor, School of Information
Introduction to Structured Query Language (SQL)
What You'll Learn
- Learn about the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation.
- Learn to model many-to-many relationships like those needed to represent users, roles, and courses.
4 Modules
16 Hours
4 hrs per module (approx.)
Rating
About Introduction to Structured Query Language (SQL)
In this course, you'll walk through installation steps for installing a text editor, installing MAMP or XAMPP (or equivalent) and creating a MySql Database. You'll learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation. Lastly, you'll learn to model many-to-many relationships like those needed to represent users, roles, and courses.
Skills You'll Gain
- Geospatial Databases
- MySQL
- NoSQL
- PHPMyAdmin
- PL/pgSQL
- SQL (Programming Language)
- Structured Query Language Procedural Language (SQL PL)
What You'll Earn
- Certificate of Completion:
- Certificates of completion acknowledge knowledge acquired upon completion of a non-credit course or program.
Welcome Message
Welcome to Introduction to Structured Query Language (SQL), a course that builds foundational skills in working with relational databases. You will learn how to install and configure a database environment, write SQL queries, design multi-table databases, and model complex relationships. By progressing from basic queries to joins and many-to-many relationships, this course, the second in the Web Applications for Everybody Specialization, prepares you to design and query databases used in real-world applications.
This abbreviated syllabus description was created with the help of AI tools and reviewed by staff. The full syllabus is available to those who enroll in the course.
Course Schedule
Module 1: Installing PHP and SQL
- Reading: Textbook & Course Resources
- Reading: Help Us Learn More About You!
- Reading: Syllabus
- Video: Welcome to the Course
- Video: Installing MAMP on a Macintosh
- Video: Installing MAMP on Windows 10
- Video: Installing XAMPP on Windows 10
- Reading: Installing LAMP On Linux
- Discussion Prompt: Your Database Experience
- Reading: Assignment Specifications: Installing PHP/MySQL
- App Item: Peer Graded: Installing PHP/MySQL
- Video: Bonus: Office Hours in the Hague
Module 2: Introduction to Structured Query Language (SQL)
- Video: Overview of Databases
- Video: Basic SQL Operations
- Video: Data Types in SQL
- Video: Database Keys and Indexes
- Reading: Assignment Specifications: Single-Table SQL
- Video: Bonus: Liz Fong - Standardizing SQL
- Graded Assignment: SQL Queries
- Video: Bonus: Office Hours Orlando, Florida
- Graded: Autograder: Single-table SQL (Users)
Module 3: Database Design
- Video: Relational Database Design
- Video: Normalization and Foreign Keys
- Video: Building a Physical Data Schema
- Video: Relational Database Design #4
- Graded Assignment: Database Models
- Reading: Assignment Specifications
- App Item: Peer Grader: Multi-Table Databases (Tracks)
- Video: Bonus: Office Hours Houston, TX
- Video: Fun: Dr. Chuck gets a Educational Technology Tattoo
Module 4: Many-to-Many Relationships
- Video: Many-to-Many Relationships
- Reading: Assignment Specifications: Many-to-Many Databases
- Video: Bonus: Office Hours Portland, Oregon
- Reading: Post-Course Survey
- Reading: Keep Learning with Michigan Online
- Graded: Autograder: Many-to-Many Databases
Grading Policy
Course materials and assignments are self-paced and remain open throughout the course. Learners must earn an overall grade of 80% to pass and receive a certificate. There are two assignments, each worth 50% of your final grade.
Course content developed by U-M faculty and managed by the university. Faculty titles and affiliations are updated periodically.
Intermediate Level
Some related experience required
