ANA660 Advanced SQL Programming

Lead Faculty: Dr. Jodi Reeves

Course Description

An in-depth treatment of data manipulation with Structured Query Language (SQL). This course covers views, triggers, sequences, reporting, sub-queries, query optimization and how to use SQL for data warehouse manipulation.

Learning Outcomes

  • Synthesize complex SQL queries.
  • Develop SQL scripts for developer reports and security features.
  • Evaluate SQL analytical functions and operators for data warehouse manipulation.
  • Analyze query execution performance.