The 4 day M20467 course teaches delegates how to implement self-service Business Intelligence (BI) & Big Data analysis solutions using the Microsoft data platform. The rationale for self-service BI, how to use SQL Server Reporting Services, Excel, SharePoint, and Office 365 Power BI to create self-service data models & reports. Includes...
The M20464 5 day instructor led course introduces Microsoft 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,...
The focus of the 5 day M20466 course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.
This M20761 course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.
This 5-day instructor led course provides delegates with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.
The 5 day M20463 course describes how to implement a data warehouse platform to support a BI solution. Delegates will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
The M20462 5 day instructor-led course provides delegates 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.
This 5 day instructor-led M20764 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 5 day instructor-led M20765 course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.
This 5 day instructor led M20767 course on how to implement a data warehouse platform to support a BI solution. You will learn to create a data warehouse with SQL Server 2016 & Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, & validate and cleanse data with SQL Server Data Quality Services and SQLServer Master Data Services.
This 3 day instructor-led M20768 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 five-day M20762 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.