
SQL Programming
Course Number: 10152184
Credits: 3.00
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
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
- Translate information needs into accurate SQL statements to generate results that meet business requirements.
- Produce basic SQL statements with appropriate uses of each type.
- Develop single-table queries.
- Construct multiple-table queries.
- Construct sub-select SQL statements.
- Program triggers to accomplish a stated business process.
- Produce database views.
- Distinguish appropriate uses for stored procedures and functions.
- Generate data to populate reports to satisfy business requirements.