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