NWTC logo

SQL Programming

Credits: 3
Course Number: 10-152-184

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

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:
83237
Delivery:
Online
Term:
Fall 2024
Session:
8W2
Instructors:
Karen Krejcie
Date Range:
-
Estimated Cost:
$496.55 *

Class Notes

  • This is an Online class that can be accessed anywhere using internet. For more information regarding this delivery and how to access your class, see www.nwtc.edu/onlinefaq.

Meeting Times

Dates Day(s) / Time Location(s)
10/23/24 - 12/20/24 Anytime
Anytime
Online

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