10990B: Analyzing Data with SQL Server Reporting Services

This three-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

Description

At Course Completion

After completing this course, students will be able to: 
• Describe key database concepts in the context of SQL Server 2016
• Describe database languages used in SQL Server 2016
• Describe data modelling techniques
• Describe normalization and denormalization techniques
• Describe relationship types and effects in database design
• Describe the effects of database design on performance
• Describe commonly used database objects

Prerequisites

In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:
• 20761A/B: Querying Data with Transact-SQL

Target audience

The primary audience for this course is database professionals who need to fulfil a BI developer role to create reports. Primary responsibilities will include implementing reports and mobile reports.
The secondary audiences for this course are power information workers.

Similar courses

This two day class is designed for information workers or power users who serve as SharePoint Site Owners or Site Collection Administrators. Students should take this course if they need to know how to manage the team collaboration, document management and social features of Microsoft SharePoint 2013 sites.

More Information

Are you ready to learn how to administer a SQL Server database? This course will equip you with the skills you need to manage databases with confidence. In this course, you’ll learn the ins and outs of database administration and gain hands-on experience automating, backing up, restoring and troubleshooting SQL Server. With expert guidance from New Horizons’ certified instructors, you’ll master the modern database techniques companies are desperately seeking out.

More Information

A one-day, hands-on workshop for business analysts that covers the full capabilities of Power BI.

More Information

Students will learn key elements of Microsoft 365 Identity job role.

More Information

This course teaches IT Professionals how to manage core Windows Server workloads and services using on-premises, hybrid, and cloud technologies. The course teaches IT Professionals how to implement and manage on-premises and hybrid solutions such as identity, management, compute, networking, and storage in a Windows Server hybrid environment.

More Information