SQL / BI

Microsoft SQL Server 2016 is the foundation to the cloud-ready OLTP and Business Intelligence platforms. It set new standards for mission critical OLTP, Enterprise Data Warehousing loads and peak performance capabilities (20+ TB production cubes) at an improved off the charts TCO. Further more, SQL Server 2016 also enabled self-service BI solutions. Upon completing this course, you will become proficient in developing Business Intelligence applications with Microsoft SQL Server 2016 using SSIS, SSRS and SSAS services. You will also be equipped to become a Microsoft SQL BI Developer (70-467).

  • Bootcamp
  • Gamified
  • Taught By Architects

Taught By Architects

Courses taught by experienced Architects in the field. Not academicians.

Totally Hands-on

Builds the muscle memory of a seasoned professional.

Best In The Market

Best in the market in career oriented bootcamp programs

Course Description

Microsoft SQL Server 2016 is the foundation to the cloud-ready OLTP and Business Intelligence platforms. It set new standards for mission critical OLTP, Enterprise Data Warehousing loads and peak performance capabilities (20+ TB production cubes) at an improved off the charts TCO. Further more, SQL Server 2016 also enabled self-service BI solutions. Upon completing this course, you will become proficient in developing Business Intelligence applications with Microsoft SQL Server 2016 using SSIS, SSRS and SSAS services. You will also be equipped to become a Microsoft SQL BI Developer (70-467).

SQL / BI

The best program in the market, now even got better

34 reviews

Course Description

Microsoft SQL Server 2016 is the foundation to the cloud-ready OLTP and Business Intelligence platforms. It set new standards for mission critical OLTP, Enterprise Data Warehousing loads and peak performance capabilities (20+ TB production cubes) at an improved off the charts TCO. Further more, SQL Server 2016 also enabled self-service BI solutions. Upon completing this course, you will become proficient in developing Business Intelligence applications with Microsoft SQL Server 2016 using SSIS, SSRS and SSAS services. You will also be equipped to become a Microsoft SQL BI Developer (70-467).


Course Prerequisites

Laptop with at least 4GB of RAM / Working Webcam


What is Covered

Course contents included in this program

SQL Server

  • SQL Server Development Tools
  • Query Editor Features
  • Working with Tables
  • Selecting and Grouping Data
  • Constraints
  • Limiting and Sorting Data
  • System Functions
  • Working with Variables
  • User Defined Function
  • Implementation and Best Practices for Temporary Data Structures
  • Combining Data from Multiple Sources - Joins
  • Developing and Implementing Stored Procedures
  • Creating and Managing View and Triggers
  • SQL Review

SSRS

  • Introduction to the SSRS Architecture
  • Charts and Graphs
  • Tables Matrix and Drilldowns
  • Parameters
  • Subreports and Drillthrough
  • Report Manager and Report Automation

SSIS

  • Extract, Transformation and Load Basics
  • Variables & Expressions
  • Data Profiling
  • Auditing & Error Handling
  • Package Design Considerations
  • Package Deployment & Storage
  • End of Class

Classes Open For Enrollment


Start Date Sessions Location
Saturday, November 11, 2017 2 days a week Saturdays 8AM-12PM CST Tuesdays 6:30PM-9:30PM CST
Program Fee $1,699.00
Online Enroll
Saturday, November 11, 2017 2 days a week Saturdays 9:30AM-1:30PM CST Tuesdays 6:30PM-9:30PM CST
Program Fee $1,699.00
Plano TX Enroll


Program Media

Pictures, videos and brochures

Student Presentations

Student Presentations