SQL Advanced Course Outline

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

Next program begins Spring 2026

Location:

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

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 Session

 
Session 2

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