SQL Advanced Course Outline

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

Next program begins March 21, 2025.

Registration closes March 14, 2025.

REGISTER NOW

Location:

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

Session 1: Friday, March 21, 2025 (1:00-5:00 p.m.)
Module Topics
Module One
  • Database Design
    • Database Life Cycle
    • Conceptual Design
    • Logical Design
Module Two
  • Design Cases: Learning Flexible Database Online
    • Guided Exercises
    • Design Case Discussion
    • Best Practices
Module Three
  • Advanced SQL (Part I)
    • Integrating Data from Multiple Tables
    • Complex SQL Queries
Module Four
  • Hands-on Workshop on Advanced SQL
    • Troubleshooting
    • Q&A Sessio

 

Session 2: Friday, March 28, 2025 (1:00-5:00 p.m.)
Module Topics
Module Five
  • Advanced SQL (Part II)
    • Creating and Altering Table Structures
Module Six
  • Advanced SQL (Part III)
    • Conditional Logic and Temporary Tables
    • Procedural SQL
Module Seven
  • Big Data Analytics
    • Business Intelligence and Data Warehouses
    • Scalability and Automation
    • NoSQL
Module Eight
  • Hands-on Workshop
    • Guided Exercises
    • Troubleshooting
    • Q&A Session