Data Analytics

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).

Data Analytics

The best program in the market, now even got better

169+ 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, May 05, 2018 2 days a week Saturdays 9:00 AM-1:00 PM CST Tuesdays 6:30 PM-9:30 PM CST
Program Fee $1,999.00
Online Enroll
Saturday, May 05, 2018 2 days a week Saturdays 9:00 AM-1:00 PM CST Tuesdays 6:30 PM-9:30 PM CST
Program Fee $1,999.00
Irving TX Enroll
Saturday, May 12, 2018 2 days a week Saturdays 9:00 AM-1:00 PM CST Tuesdays 6:30 PM-9:30 PM CST
Program Fee $1,999.00
Plano TX Enroll

Democratizing careers.

At a hackathon

Students rejoice

Join the 11000+ Community on Facebook


Program Media

Pictures, videos and brochures

Alumni Presentations (Silicon Valley Cohort)

Alumni Presentations (Silicon Valley Cohort)