Data Management in SQL (Basic) – Course Outline
2 Sessions, 8 Hours
Next program begins Fall 2025
Location:
Mercer University School of Business
Room 004
3001 Mercer University Drive
Atlanta, GA 30341
Session 1 – March 21, 2025 (1:00 p.m. – 5:00 p.m.) |
Module |
Topics |
|
Module One |
- Welcome and Introduction
- Introduction to Databases
- Categorization of Databases
|
|
Module Two |
- Data Models
- Data Model Basic Building Blocks
- Business Rules
|
|
Module Three |
- Relational Database Model (Part 1)
- A Logical View of Data
- Keys and Dependencies
- Integrity Rules
|
|
Module Four |
- Relational Database Model (Part 2)
- Relational Algebra
- Relationships within Relational Databases
|
Session 2 – March 28, 2025 (1:00 p.m. – 5:00 p.m.) |
Module |
Topics |
|
Module Five |
- Entity-Relationship (ER) Modeling
- The Entity Relationship Model
- Developing ER Diagram
|
|
Module Six |
- Normalization of Database Tables
- The Need for Normalization
- Normalization Process
|
|
Module Seven |
- Introduction to Structured Query Language (SQL)
- Basic SQL Framework
- How It Works in MySQL
|
|
Module Eight |
- Hands-on Workshop
- Troubleshooting
- Q&A Session
|