reed.co.uk Courses

Header

MCSA: SQL Server 2016 Business intelligence (BI)

|Hands-On Training|Pay Monthly|Great Discounts on First-Come First-Serve Basis|Offer Ends Soon|


London Training

Summary

Price
Enquire to get more info on pricing
Payment options

|Pay All At Once| OR |Pay Monthly|

Take advantage of our one-year interest-free repayment plan!

Study method
Classroom
Duration
4 Days, Part-time/Full-time
Qualification
MCSA: SQL 2016 Business Intelligence Development
Professional What's this?
Additional info
  • Exam(s) / assessment(s) not included in price & must be purchased separately
  • Tutor is available to students

3 students enquired about this course

Add to basket or enquire

Location & dates

Location
Address
Wilson Street
City Of London
London
EC2M2SJ

Overview

London Training is a leading IT training company teamed up with the IT industry experts who have gained vast knowledge in the field of Information Technology. Boost your skills and get certified. An Authorized Training Center by Microsoft.

|Training Facilities|

  • Authorized Training Center
  • Hands-on Training
  • Tutor Led Classroom
  • Small Class Size 5-7 max
  • Central London Locations
  • Price includes Tuition Fee, VAT, and Course Material
  • Expert and Certified Trainers
  • Classes on Week Days, Evening or Weekends
  • Free Re-training
  • Modern Training Facilities
  • Inclusive Books / Materials
  • Mock Exams / Projects
  • Course Attendance Certificate

|Course Schedule|

Learn on your flexible hours. Classes in Fast Track, Week Days, Weekend, Evenings to suit your work and social life.

|Course Highlights| {Request Us For Full Brochure}

MCSA SQL BI Exam 70-767: Implementing a Data Warehouse using SQL (SSIS)

Overview of Data warehouse SQL Server

Data Warehouse Infrastructure

Designing and Implementing a Data Warehouse

Physical Design for a Data Warehouse

Columnstore Indexes

Implementing an Azure SQL Data Warehouse

Creating an ETL Solution

Implementing Control Flow in an SSIS Package

Debugging and Troubleshooting SSIS Packages

Implementing a Data Extraction Solution/Incremental ETL

Enforcing Data Quality

Using Master Data Services

Extending SQL Server Integration Services (SSIS)

Deploying and Configuring SSIS Packages

Consuming Data in a Data Warehouse

MCSA BI Exam 70-768 - Developing SQL Data Models (SSAS)

Business Intelligence and Data Modelling

Creating Multidimensional Databases

Working with Cubes and Dimensions

Working with Measures and Measure Groups

Introduction to MDX

Customizing Cube Functionality

Implementing a Tabular Data Model by Using Analysis Services

Data Analysis Expression (DAX)

Creating Calculated Columns and Measures by using DAX

Performing Predictive Analysis with Data Mining

Qualification

MCSA: SQL 2016 Business Intelligence Development
Awarded by Microsoft

Course media

Description

|COURSE INFORMATION|

Get trained in Microsoft Certified Solutions Associate (MCSA) Certification - SQL Server 2016 and gain the essential skills needed in all aspects of the Microsoft's premier database system – suitable for all sizes of businesses.

MCSA SQL Server 2016 will enable you to establish your technical skills required to build a sustainable career in IT. Be equipped with the skills that would facilitate you to demonstrate the ability to provide innovative solutions across multiple technologies to your clients. By achieving MCSA SQL 2016 certification you will quite simply be an expert in database technology and can provide solutions for complex business environments.

Microsoft SQL Server has become the most popular, secure, reliable and robust database platform in the IT industry currently. On achieving SQL Server 2016 certification, you will maximise your chances of becoming more employable and more marketable in the current competitive IT job market.

|How we deliver this course|

Our MCSA: Data Platform course is delivered by certified, industry expert and experienced trainers who have over 12 years of experience in Database Technologies. We provide hands-on, tutor-led and classroom-based training in Central London.

|Price Info|

  • Hands-on Tutor Led Training
  • Classroom-Based Practical Training
  • Unlimited Practice Lab Access
  • Small Size Class and Interactive Sessions
  • Lab Exercises
  • Project Work
  • Completion Certificate
  • Free Re-training
  • Cost is calculated at 70 percent Tuition Vatable and 30 percent Training Book(s) with 0 rated Vat

|Learning Facilities|

We have immaculate learning facilities with state of art technology, fully equipped with high specs latest servers, workstations and software.

|General Facilities|

We also provide Free Wifi Internet, Refreshment, Water, Tea and Coffee Facilities.

|Pay In Instalments|

You can also take advantage of our one-year interest-free repayment plan! Join the course today with confidence and pay as little as £108.00 per month for 12 months.

|Registration Process|

Speak with our Course Advisor

Who is this course for?

SQL Server 2016 can perform 1 million commands in just 1 second which makes it the fastest, reliable and robust solution for small to large enterprises. SQL Server 2016 also provides higher productivity for DBAs, System Admins and Application Developers. It is also capable to avoid mission critical outages or data loss and the Excellent BI and reporting tools, large-scale data warehousing capabilities, make SQL Server 2016 stands out in the market.

Requirements

Basic Knowledge of IT

Career path

|CAREER PROSPECT|

Boost your skills and get certified Database administrators, Software Developers, Project Managers etc.

Package Offers:

GREAT SAVINGS!!

Giveaway Price £3000+VAT for 3 courses / Save £600

  1. MCSA: SQL Server 2016 Develop - £1200
  2. MCSA: SQL Server 2016 Admin - £1200
  3. MCSA: SQL Server 2016 BI Develop - £1200

Request Us For More Packages Info

LEARN THE SKILLS YOU NEED TO SUCCEED TODAY!!

Questions and answers

Rating and reviews

There haven't been any reviews for this course yet.

Please sign in to review this course.