SQL Server Business Intelligence Developer Bootcamp
3-course track: $3,600 4-course track: $4,800
Veterans Discount: To inquire about discounts, please call 978.250.4983.
The SQL Server Business Intelligence Developer bootcamp includes coverage of relational database fundamentals, SQL programming, Reporting Services, Integration and Analysis Services.
Our unique approach combines on-demand streaming 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.
This 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. 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. A 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.
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.
- 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
|Microsoft Transact-SQL Programming||35 hours|
|SQL Server 2016 Reporting Services||21 hours|
|SQL Server 2016 Business Intelligence: Integration Services and Analysis Services||35 hours|
|Microsoft SQL Server 2016 Administration||35 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.