SQL Server Features & Tools

collapse

Course Details

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

Get Program Details

About this Course


This course will advance your T-SQL programming and problem-solving skills. You'll learn how to build more advanced SQL queries and work with reporting data. You’ll also create dashboard reports, automate tasks and apply advanced techniques and tools to real-world problems. As a final project, you’ll use development best practices to complete a SQL development project using advanced SQL server features and techniques.

What You'll Learn

  • How to use SQL Server to work with reporting data structures
  • How to perform data processing and migrations using Integration Services  
  • How to create tabular databases using Analysis Services 
  • Techniques for developing an administrative dashboard using Reporting Services  
  • How to automate administrative tasks using PowerShell and secure relational data using permissions and encryption  

Get Hands-On Experience

  • Create automation tasks using multiple technologies  
  • Design, transform and manage various data formats and structures  
  • Develop data-driven reports for database management  
  • Design strategies for data quality and management  

 

Program Overview

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

  Get our email newsletter with career tips, event invites and upcoming program info.       Sign Up Now