NWTC logo

SQL Programming Advanced

Credits: 3
Course Number: 10-152-151

Home » Academics And Training » Courses » Sql Programming Advanced

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, alternate database technologies, emerging database trends and database administration/security. (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.

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 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. Develop triggers and stored procedures.
  5. Create database table indexes with emphasis on usage and table/query performance.
  6. Utilize SQL Server Query Optimizer to optimize queries.
  7. Improve database robustness and usability to accommodate complex business needs.
  8. Produce a lossless database environment through the use of Data Backups, Snapshots, and Transaction Log Files
  9. Analyze database performance.
  10. Plan data analysis and data integration using the SQL SSAS and SSIS tools.
  11. Manage database security at levels appropriate to business and data needs.
  12. Develop reports utilizing SQL Server Reporting Services (SSRS) that meet business requirements
Filter by
Clear

2 classes found

Class Number: 82234

Date:
-
Delivery:
Online Live
Term:
Fall 2024
Session:
8W1
Online
8/19/2024 - 10/14/2024
Web Conference
8/19/2024 - 10/14/2024
M — 5:30 PM - 9:20 PM
$496.55

Class Number: 82233

Date:
-
Delivery:
Blended - Less than 50% Online
Term:
Fall 2024
Session:
8W1
Online
8/19/2024 - 10/14/2024
Green Bay Campus Room BT251
8/19/2024 - 10/14/2024
M — 5:30 PM - 9:20 PM
$496.55