Data Management in SQL (Advanced) – Course Outline
2 Sessions, 8 Hours
Next program begins Summer 2025
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 Sessio
|
| 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
|