ANA660 Advanced SQL Programming
Lead Faculty: Dr. Jodi Reeves
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.
- 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.