NWTC logo

SQL Programming

Credits: 3
Course Number: 10-152-184

Home » Academics And Training » Courses » Sql Programming » 10152184 2248 83238

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

How can I use this course to achieve my career goals?

This course is associated with the following programs:

What will I learn?

  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.

Class Details

Class Number:
83238
Delivery:
My Way
Term:
Fall 2024
Session:
8W2
Instructors:
Karen Krejcie
Date Range:
-
Estimated Cost:
$496.55 *

Class Notes

  • My Way learning is a choice of attending class in-person (live in the classroom) or online live (web conference). Each week, you choose to attend the classroom or online live at the scheduled time. In addition to live sessions, there will be online activities as part of the weekly requirements. For more information, please visit https://nwtc.libanswers.com/Eagle/faq/339440.

Meeting Times

Dates Day(s) / Time Location(s)
10/23/24 - 12/18/24 W
8:30 AM - 12:20 PM
Web Conference or BT253

* Cost displayed is an estimate and may be discounted if attendees are residents of Northeast Wisconsin Back to cost