Restricted Operations Due to Coronavirus Outbreak

For the safety of our community, UWPCE has restricted operations due to the coronavirus outbreak.

For more information, see our FAQ

Non-relational SQL Server Features & Tools

collapse

Course Details

This course can only be taken as part of the Certificate in SQL Server Development.

Get Program Details

About this Course


In this course, advance your skills in programming and problem solving with T-SQL. Learn how to build more advanced SQL queries, work with non-relational data and hierarchies, and do advanced reporting in SQL Server Reporting Services. Apply these concepts to real-world problems. Use development best practices to complete an integrated SQL development project.

Topics include:

  • Database programming using the SQLCLR (.NET)
  • Secure sensitive data w/ encryption
  • Beyond Relational (XML, JSON, Schema-less DB models)
  • Building data access solutions w/ Entity Framework
  • Automating Database tasks w/ Powershell
  • Data movement and management using SSIS
  • Building dynamic reports using SSRS
  • Understanding Data quality & Master data management
  • High Performance SQL Server
  • SQL Server & Business Intelligence

Program Overview

This course is part of the Certificate in SQL Server Development.

  Stay up to date with emails featuring career tips, event invitations and program updates.       Sign Up Now