NWTC logo

SQL Programming

Credits: 3
Course Number: 10-152-184

Home » Academics And Training » Courses » Itweb Programming Sql

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.
Filter by
Clear

3 classes found

Class Number: 83238

Date:
-
Delivery:
My Way
Term:
Fall 2024
Session:
8W2
Web Conference or BT253
10/23/2024 - 12/18/2024
W — 8:30 AM - 12:20 PM
$496.55

Class Number: 83237

Date:
-
Delivery:
Online
Term:
Fall 2024
Session:
8W2
Online
10/23/2024 - 12/20/2024
$496.55

Class Number: 83236

Date:
-
Delivery:
Online
Term:
Fall 2024
Session:
8W1
Online
8/19/2024 - 10/14/2024
$496.55