Developing BI/EDW Applications with MS SQL Server

The BI and analytics platform market is in the midst of rapid expansion. Microsoft delivers competitive and expanding set of BI and analytics capabilities with SQL Server at the core of the solution and demand for skilled SQL BI developers has been growing rapidly.

Upon completing this course, you will be comfortable 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-461).

  • Online
  • 12 Weeks
  • $1,699.00
Register Now

Taught By Architects

Taught by practising Data Architects with practical real world scnearios.

Totally Hands-on

This intensive bootcamp rely on principles of growth mindset and deep learning.

Gamified Learning

Revolutionary goal based learning platform built with gamification and behavioral analytics.

Developing BI/EDW Applications with MS SQL Server

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

THE GOAL

This intensive boot camp is prepared to jump start your career in Business Intelligence and Data Analytics with focus on Microsoft SQL Server. 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-461).


PRE-REQUISITES

A This program is quite intensive and hands-on. It requires that you must be able to spend about 15-20 hours a week at home. This is in addition to attending classes twice a week.

B No previous programming experience or data analytics background is necessary. In our earlier programs, aspirants without any IT background were also able to sucessfully complete the program and jumpstarted their careers.


WHAT YOU WILL LEARN

Here is a list of key concepts and technologies you will learn in the 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

Program Cost : $1,699.00

We currently offer scholarships for veterans, members of the US Military and select applicants qualified by our non-profit partners.

Get latest updates and stay connected


Upcoming Classes

Saturday, March 18, 2017

Class meets ONLINE 2 days a week Saturdays 8AM-12PM CST Tuesdays 6:30PM-9:30PM CST

Register Now

Saturday, March 18, 2017

Class meets in PLANO 2 days a week Saturdays 9:30AM-1:30PM CST Tuesdays 6:30PM-9:30PM CST

Register Now

Saturday, May 6, 2017

Class meets ONLINE 2 days a week Saturdays 8AM-12PM CST Tuesdays 6:30PM-9:30PM CST

Register Now

Saturday, May 6, 2017

Class meets in IRVING 2 days a week Saturdays 9:30AM-1:30PM CST Tuesdays 6:30PM-9:30PM CST

Register Now

What the alumni says about the program

This amazing school made my dreams come true! Colaberry School of Data Analytics gave me the tools and skills I needed...

Posted by Mechale Morpheus on Thursday, May 21, 2015

"The Colaberry School of Data Analytics training is one of the most rewarding experiences that I have encountered post high school. The instructors present the course-work in a manner that one can relate to and understand even without prior Information Technology experience. I am a firm believer in “No Reward without Effort” and the benefits within the industry are certainly worth the challenge Colaberry prepares you for, boot-camp style. I have never gone through a program that is not only focused on your comprehension and capacity to retain information but also on your problem solving and business logic skills which ultimately makes you a resource in any professional environment. This course is a must for anyone who has a drive and passion to succeed. This is for anyone who is tired of being expendable within the job market, weighed down by corporate glass ceilings and wants to be recognized as a true asset or resource. This course is like none other, which is mandatory for an industry that is so highly in demand."

Alex G // Class of October 2012 // ARMY VETERAN currently MICROSOFT BI DEVELOPER

"Attending the BI training class at Colaberry School of Data Analytics was the best career move that I have ever made. I had the opportunity to learn from instructors that are also industry professionals with many years of experience. The evening and weekend classes ensured that I could easily fit the class into my schedule, and the curriculum was taught in a way that I, (someone with ZERO I.T. background), was able to easily follow. With the knowledge that I obtained from the Colaberry School of Data Analytics team, I not only obtained my Microsoft BI Certification, I am also employed at a great company, utilizing the skills that I learned in the class. I changed my future in a matter of months and secured both professional and financial growth. My only wish is that I had taken the class sooner!"

Krystal T // Class of July 2014 // Currently Microsoft BI Developer

Frequently Asked Questions

Here is a list of most frequently asked questions about this program. If you have a question and you can't find an answer in this list, feel free to contact us right away.

Is this enough to get a job?

Yes, this program trains you on key concepts, tools, frameworks and techniques required to build real world BI applications.

Is this the right time?

The BI and analytics platform market is in the midst of rapid expansion. This is one of the best times to be a Microsoft SQL BI Developer.

How to signup?

Register for the bootcamp here. once you signup for an account, you will be able to select a particular class if multiple classes are available.

Once you enroll in to a class, you will be provided with a unique URL of the class. The same URL will be used for the entire duration of the program. If there be a change for any technical reasons, you will be notified at the earliest possible.
You can join the online class from any computer (Windows or Mac) and from most portable devices. However, it is MANDATORY to have a camera and microphone to communicate with the class. The online learning environment requires your active participation and engagement. So you must always be visible to the entire class via the camera and be able to participate in discussions.
Along with joining all classes in a week, we expect you to spend an additional 15-20 hours a week, working on your assignments, project and study the material provided.
Upon completing the program, you will be equipped with necessary knowledge and skills to apply for the following roles. Click on the Job Role to see current job market for the role. You will be able to search for a given location on the page.
Yes, we will help you find a job. If you qualify, you may join our Job Readiness Program/Internship Program to get exposure and experience of working on end-to-end projects. Contact us for more information on the Job Readiness Program/Internship Programs. To those that join our Job Readiness Program/Internship Programs, we assign a personal mentor to set up a game plan not only to start your career and get that first job in the field, but also create a career blue print to advance your career.
Yes, you can pay in 2 or more partial payments. Choosing a partial payment plan, will incur an additional processing fee of $51.00. So you will require to pay a total amount of $1750.00. Please note that you must finish all your payments within 4 weeks after the beginning of the course work. In case, if you may not be able to pay the total amount within 4 weeks, you may start your first payment well before the beginning of the program.
Ocassionally we do offer early bird discounts. But currently, we do not offer any discounts.
The full program fee is due on the first day of the course work. If full fee is not paid by the end of the first day of course work, it will be considered as opting for a partial payment plan and will incur an additional processing fee of $51.00.
You can pay with your bank account, debit card, credit cards, cash or cheque. Please visit our Paypal page to make a payment using your bank account, debit card or credit cards. If you are attending a classroom session and want to pay by Cheque or Cash, please handover your payment to the class instructor. They will provide you a receipt for the payment received. If you are attending an online session, please send your cheques to our Richardson office address included at the bottom of the page. Please do write your name, email address and class you would like to attend on the back of the cheque.
Yes, we can send you an invoice if you need to arrange payment from your organization. Please contact Admissions@Colaberry.com for more details.
Any program fee that is paid is refundable after subtracting the Registration and Administration fee of $200.00 if the student notify the Colaberry Support Team by email or phone call within 30 days, calculated from the actual beginning of the class or date the student actually joined the class, whichever is earlier.
Yes. We do offer deep discounts on the program as well as scholarships that waive the entire program fee. Please send us an email to Admissions@Colaberry.com or call us at 972-992-1024 for more details.
Yes, We are giving away 25 scholarships to qualified NOSTOPS members in 2015.
You must be an active member of NOSTOPS organization in the USA.
Send your most recent profile to Admissions@Colaberry.com. One of our mentors will schedule a call to discuss and help you understand terms for qualification and take it forward.

Social Trends

See what we are tweeting about and what's trending on SQL Server and Business Intelligence

Get latest updates and stay connected