SQL Basic Course Outline

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

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

Module Topics
Module Five Entity-Relationship (ER) Modeling

  • The Entity Relationship Model
  • Developing ER Diagram
Module Six Entity-Relationship (ER) Modeling

  • The Entity Relationship Model
  • Developing ER Diagram
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