![NWTC logo](/getmedia/1a2b4659-1c9d-4f2c-bde3-2fc0e09b4025/default-image.png)
SQL Programming Advanced
Course Description
Course Typically Offered
Most NWTC classes are offered in 8-week sessions. Learn more about how our class schedule can help you succeed.
How can I use this course to achieve my career goals?
This course is associated with the following programs:
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:
- 22066
- Delivery:
- Online Live
- Term:
- Spring 2025
- Session:
- 8W2
- Date Range:
- -
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.
Meeting Times
Dates | Day(s) / Time | Location(s) |
---|---|---|
03/26/25 - 05/20/25 |
Anytime
Anytime |
Online
|
03/26/25 - 05/14/25 |
W
12:30 PM - 4:20 PM |
Web Conference
|
* Cost displayed is an estimate and may be discounted if attendees are residents of Northeast Wisconsin Back to cost