Cookies on NWTC's Website

SQL Programming Advanced

Class Number: WEB 10152151-2 - SQL Programming Advanced
Offering Status: Open
Academic Level: Post_Secondary
Back

Course Description

10-152-151 SQL PROGRAMMING ADVANCED ...write advanced SQL statements, design robust databases and explore performance issues and solutions at the server-level and query-level. Additional topics include database transformations (SSIS), and reporting options (SSRS). (Prerequisite: 10-152-184, SQL Programming).

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.

What will I learn?

  1. Translate complex information needs into accurate SQL statements to generate results that meet business requirements.
  2. Construct multiple-table queries and subqueries to meet complex data needs.
  3. Distinguish appropriate uses for custom user-defined functions.
  4. Determine appropriate uses for advanced triggers and stored procedures.
  5. Create database table indexes with emphasis on usage and table/query performance
  6. Utilize the SQL Server Query Optimizer to optimize queries.
  7. Differentiate appropriate uses for alternative database management systems.
  8. Improve database robustness and usability to accommodate complex business needs.
  9. Produce a lossless database environment through the use of Data Backups, Snapshots, and Transaction Log Files.
  10. Analyze and Modify database performance.
  11. Plan data analysis and data integration using SQL SSIS tools.
  12. Manage database security at levels appropriate to business and data needs.

Class Details

Class Number:
WEB 10152151-2 - SQL Programming Advanced
Date:
-
Delivery:
Online Live
Term:
2026 Spring Session 2

Class Notes

This class is taught through a combination of online-live and online instruction. A portion of the class must be attended live virtually during the scheduled dates and times, and the remaining instruction accessed online by the student any time. For more information regarding this delivery and how to access your class, see www.nwtc.edu/onlinelivefaq.

Meetings Times

Dates Day(s) / Time Location
3/26/2026 - 5/19/2026 Online
12:00 AM - 12:00 AM
3/26/2026 - 5/19/2026 Online Live Thursday
12:30 PM - 4:20 PM

* Cost displayed is based on in-state residency. Back to cost