Skip to content
Northeast Wisconsin Technical College
NWTC logo

SQL Programming

Course Number: 10152184
Credits: 3.00

Home » Academics And Training » Courses

Course Description

10-152-184 SQL PROGRAMMING ...write queries in a relational database: creating tables, setting primary/foreign keys, populating tables, manipulating data and reporting. Explore join types, stored procedures, functions, and database administration SQL statements. (Prerequisite: 10-154-125, Database Development)

Course Typically Offered

  • Fall
  • Spring

Most NWTC classes are offered in 8-week sessions. Learn more about how our class schedule can help you succeed.

Credit for Prior Learning

Course Competencies

  1. Translate information needs into accurate SQL statements to generate results that meet business requirements.
  2. Produce basic SQL statements with appropriate uses of each type.
  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 functions.
  9. Generate data to populate reports to satisfy business requirements.