Course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass databse elements. The course describes fundamental database concepts including databse types, database languages, and database design.
This course looks at various options that provide the ability of business users to analyze and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources
This course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.
The main purpose of this course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
This 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.
This course provides students with the knowledge & 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.
Students will learn how to create a data warehouse with Microsoft� SQL Server� 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services.
Learn the technical skills 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 is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. Students will learn to implement multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models.
In this course, students will continue their learning on the foundations of report writing with Microsoft� SQL Server� Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data.