SQL Programming Advanced
Credits: 3
Course Number: 10-152-151
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.
- 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
0 classes found
No classes available
Registration is not currently available for this course. Learn more about registration dates and how to register.
Return to search