SQL Server Business Intelligence Developer Bootcamp
4-course track: $4,800
Veterans Discount: We offer a 20% discount to Veterans.
Location: Courses may be taken at home or the workplace, via a combination of on-demand video lectures and facilitated hands-on labs.
The SQL Server Business Intelligence Developer bootcamp includes coverage of relational database fundamentals, SQL programming, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), and Power BI.
Our unique approach combines on-demand training with personal facilitation and comprehensive hands-on exercises to assure successful training and competence in the IT workplace. Our support staff provides personal setup assistance, guidance and lab equipment setup for each student. An instructor is assigned to each student to assist in completing lab exercises and to help with any questions about the course content. Our classes are designed to be 50% lecture and 50% hands on exercises. Lab exercises are performed via direct high-speed access to a dedicated lab machine, providing responsive interaction and anywhere/anytime accessibility by the lab facilitator as well as the student.
The SQL Server Business Intelligence bootcamp provides a solid understanding of relational database design concepts, coding and utilizing SQL queries and database management tools. It includes comprehensive coverage of SQL syntax including complex queries, as well as creating and using stored procedures, functions, views and triggers. In the SQL Business Intelligence courses, you will learn how to deploy and manage Reporting Services, create and customize reports including Table, Matrix, Parameterized and Linked reports. You’ll be introduced to the design and use of data warehouses and the use of SSIS to import/export data. The thorough introduction to SSAS includes creation of data cubes to support business analytics, and syntax for extracting information including the use of MDX to develop Multidimensional models. Students will learn to use Microsoft's Power BI suite of products to import, analyze, and visualize business data, and to share business intelligence.
Upon completion of the SQL Business Intelligence program, students will have developed an appropriate knowledge base for a variety of positions related to database programming, data reporting, and data analysis. Students will have gained a robust skillset to pursue an entry level database reporting or business intelligence position at companies which use Microsoft SQL Server. The skills and flexibility gained from the program will also allow students to pursue a data analyst position or technical support position at companies which utilize SQL Server as the database for their software.
Take advantage of quality content and personal service to assure your success. Curriculum Advisors are available at 978.250.4983 to answer any questions you may have regarding the programs of interest to you.
If you would like to enroll in this bootcamp, click here.
SQL Server Business Intelligence Program Highlights:
- Designing normalized table structures for relational databases
- Creating databases and tables
- Writing SQL queries
- Using subqueries
- Using triggers and stored procedures
- Programming features of T-SQL
- Creating, deploying and configuring SQL Server Reporting Services
- Rendering reports as Excel, Word or PDF files
- Adding charts and gauges to reports
- Using Report Builder to create reports
- Using SSIS to create import/export routines between SQL Servers and many other data sources
- Designing and building data warehouses
- Creating cubes using SSAS
- Implementing data mining algorithms against cubes to support predictive and trending analysis
- Shaping, transforming, and combining data from diverse sources to create useful reports in Power BI
- Choosing and creating the data visualizations that are best suited for various types of analysis
Required Courses in the SQL Business Intelligence Bootcamp:
Note: The Microsoft SQL Server 2019 curriculum is listed below, but if you prefer to take courses for SQL Server 2016 or SQL Server 2017, corresponding courses for those versions are also available.
|Microsoft Transact-SQL Programming||35 hours|
|SQL Server 2019 Reporting Services||21 hours|
|SQL Server 2019 Business Intelligence: Integration Services and Analysis Services||35 hours|
|Analyzing and Presenting Data with Power BI||21 hours|
Optional Extension of Required Course (No Additional Cost):
|Analyzing Data Using DAX and M Power Query||14 hours|
Students wishing to opt out of first-level courses will be evaluated one-on-one by a technical instructor. Track price will be adjusted accordingly.
50% Lab Time
Call us today to set up a free demonstration of our on-demand platform. We know that you will see the benefits of our self-paced training platform.