SQL Programming Advanced
Class Number: WEB 10152151-1 - SQL Programming Advanced
Offering Status: Open
Academic Level: Post_Secondary
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
Most NWTC classes are offered in 8-week sessions. Learn more about how our class schedule can help you succeed.
What will I learn?
- Translate complex information needs into accurate SQL statements to generate results that meet business requirements.
- Construct multiple-table queries and subqueries to meet complex data needs.
- Distinguish appropriate uses for custom user-defined functions.
- Develop triggers and stored procedures.
- Create database table indexes with emphasis on usage and table/query performance.
- Utilize SQL Server Query Optimizer to optimize queries.
- Improve database robustness and usability to accommodate complex business needs.
- Produce a lossless database environment through the use of Data Backups, Snapshots, and Transaction Log Files
- Analyze database performance.
- Plan data analysis and data integration using the SQL SSAS and SSIS tools.
- Manage database security at levels appropriate to business and data needs.
- Develop reports utilizing SQL Server Reporting Services (SSRS) that meet business requirements
Class Details
- Class Number:
- WEB 10152151-1 - SQL Programming Advanced
- Location:
- 1301
- Date:
- -
- Delivery:
- Blended
- Term:
- 2025 Fall Session 1
Meetings Times
| Dates | Day(s) / Time | Location |
|---|---|---|
| 8/18/2025 - 10/13/2025 |
Monday
5:30 PM - 9:20 PM |
Green Bay Campus Room BT251
|
| 8/18/2025 - 10/13/2025 |
Online
12:00 AM - 12:00 AM |
* Cost displayed is an estimate and may be discounted if attendees are residents of Northeast Wisconsin Back to cost