Northeast Wisconsin Technical College
10-152-184 056346 IT:Web:Programming-SQL
Outline of Instruction

Course Information
Total Credits3
Prior Learning Assessments
  1. Credit by Exam
Course Competencies
  1. Translate information needs into accurate SQL statements to generate results that meet business requirements.
  2. Analyze the types of basic SQL statements and produce examples of appropriate uses of each type of SQL statement.
  3. Develop single-table queries.
  4. Construct multiple-table queries.
  5. Construct sub-select SQL statements.
  6. Program triggers to accomplish a stated business process.
  7. Produce database views.
  8. Distinguish appropriate uses for stored procedures and user-defined functions.
  9. Generate reports to extract information to satisfy business requirements.
  10. Evaluate options for database administration tasks.