SQL Basic Course Outline

Data Management in SQL (Basic) – Course Outline
2 Sessions, 8 Hours

Next program begins January 24, 2025

Registration closes January 17, 2025.

REGISTER NOW

Location:

Mercer University School of Business
Room 004
3001 Mercer University Drive
Atlanta, GA 30341

Session 1: Friday, January 24, 2025 (1:00-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: Friday, January 31, 2025 (1:00-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