Northeast Wisconsin Technical College
10-152-151 059925 IT:Program:SQL-Advanced
Outline of Instruction

Course Information
Description10-152-151 IT:PROGRAM:SQL-ADVANCED ...write advanced SQL statements, design robust databases and write Extract, Transfer, Load (ETL) processes. Additional topics include database transformations, alternate database technologies, emerging database trends and database administration/security. (Prerequisite: 10-152-184, IT:Web:Programming-SQL)
Total Credits3
Prior Learning Assessments
None
Course Competencies
  1. Translate complex information needs into accurate SQL statements to generate results that meet business requirements.
  2. Construct multiple-table queries and subqueries to meet complex data needs.
  3. Distinguish appropriate uses for custom user-defined functions.
  4. Determine appropriate uses for advanced triggers and stored procedures and create those triggers and stored procedures.
  5. Create database table indexes with emphasis on usage and table/query performance.
  6. Utilize the SQL Server Query Optimizer to optimize queries.
  7. Differentiate appropriate uses for alternative database management systems (DBMS).
  8. Improve database robustness and usability to accommodate complex business needs.
  9. Produce a lossless database environment through the use of Data Backups, Snapshots, and Transaction Log Files
  10. Analyze and Modify database performance.
  11. Plan data analysis and data integration using the SQL SSAS and SSIS tools.
  12. Manage database security at levels appropriate to business and data needs.