0800 699 0033 ~ info@jrny.org.uk

Microsoft MCSA: SQL 2016 BI Development - jrny-training

Microsoft MCSA: SQL 2016 BI Development

Regular price
£1,194.00
Sale price
£995.00
Tax included.

Earning an MCSA: SQL 2016 Business Intelligence Development certification qualifies you for a position as a BI developer.

This certification validates your extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes.

Our MCSA Courses include all of the training and exams required to achieve your MCSA certification.

Whats included:

Exam 70-767 - Implementing a SQL Data Warehouse

About this course
This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

Audience profile
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

At course completion
After completing this course, students will be able to:

Authenticate and authorise users
Assign server and database roles
Authorise users to access resources
Protect data with encryption and auditing
Describe recovery models and backup strategies
Backup SQL Server databases
Restore SQL Server databases
Automate database management
Configure security for the SQL Server agent
Manage alerts and notifications
Managing SQL Server using PowerShell
Trace access to SQL Server
Monitor a SQL Server infrastructure
Troubleshoot a SQL Server infrastructure
Import and export data

     

    Exam 70-768 Developing SQL Data Models

    About this course

    The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.

    Audience profile

    The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions.  
    Primary responsibilities will  include:
    • Implementing multidimensional databases by using SQL Server Analysis Services
    • Creating tabular semantic data models for analysis by using SQL Server Analysis Services

    At course completion

    After completing this course, students will be able to:

    • Describe the components, architecture, and nature of a BI solution
    • Create a multidimensional database with Analysis Services
    • Implement dimensions in a cube
    • Implement measures and measure groups in a cube
    • Use MDX syntax
    • Customize a cube
    • Implement a tabular database
    • Use DAX to query a tabular model
    • Use data mining for predictive analysis