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