SQL, ETL, Data Warehousing and BI

Enterprise companies now need immediate, dynamic data. We need to make conclusions based on summary data derived from databases from different sources and structures. We need to consolidate our data and from it generate reports quickly and effortlessly.

Here at MBIT we have been delivering database training for decades and have seen the growth of BI first-hand. We now support T-SQL, PL/SQL, database management, ETL data transforms, the creation of ROLAP and MOLAP data cubes as well as SQL Server Analysis, Integration and Reporting services. This culminates in complete BI solutions and the creation of reports using SSRS, PowerPivot PowerBI and other Microsoft solutions. 

Our training courses cover all aspects of database usage and management from the sinmple relationational database through to a complete Enterprise cloud solution, expertly training your team to be competent and expert.

Microsoft SQL Server training

If you're ready to learn how to harness Microsoft SQL Server to deliver mission-critical performance, gain faster insights on data or drive your hybrid cloud strategy, you're in the right place. These learning opportunities can help you get started quickly — from product exploration to deep training and certification.

Sort by
Display
per page
View as

Course: Updating Your SQL Server Skills to Microsoft SQL Server 2014 (10977)

10977
This five-day instructor-led course teaches students how to use the enhancements and new features that have been added to SQL Server and the Microsoft data platform since the release of SQL Server 2008. The course focuses on teaching individuals how to use SQL Server 2014 product features and other Microsoft data platform components.
£1,550.00 (GBP)

Course: Administering a SQL Database Infrastructure (20764 part of MCSA SQL 2016 DA)

20764
This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.
£1,950.00 (GBP) £1,790.00 (GBP)

Course: Administering Microsoft SQL Server Databases (20462)

20462
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.
£1,850.00 (GBP)

Course: Analyzing Data with Excel (20779)

20779
The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.
£1,390.00 (GBP)

Course: Analyzing Data with Power BI (20778)

20778
The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.
£1,390.00 (GBP)

Course: Designing a Data Solution with Microsoft SQL Server (20465)

20465
The focus of this five-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions.
£1,950.00 (GBP)

Course: Designing Business Intelligence Solutions with Microsoft SQL Server 2014 (20467)

20467
This training course teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server 2014 and other Microsoft BI technologies.
£1,950.00 (GBP)

Course: Developing Microsoft SQL Server Databases (20464)

20464
This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course.
£1,950.00 (GBP)

Course: Developing SQL Data Models (20768 part of MCSA SQL 2016 BI)

20768
This three-day instructor-led course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS.
£1,950.00 (GBP) £995.00 (GBP)

Course: Developing SQL Databases (20762 part of MCSA SQL 2016)

20762
This four-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.
£1,950.00 (GBP) £1,290.00 (GBP)