Querying Data with Microsoft Transact-SQL
This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
Length (Days)
2
Price
$
1190
SQL-2016 AlwaysOn High Availability
This three-day instructor-led course is designed for database administrators and Windows engineers to familiarize them with the concepts in SQL AlwaysOn and High Availability. The course utilizes SQL 2016, but explains the differences from SQL 2012- SQL 2014.
Length (Days)
3
Price
$
1785
Introduction to SQL Databases
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.
Length (Days)
3
Price
$
1785
Analyzing Data with SQL Server Reporting Services
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.
Length (Days)
5
Price
$
2975
Provisioning SQL Databases
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.
Length (Days)
3
Price
$
2975
Implementing a SQL Data Warehouse
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.
Length (Days)
5
Price
$
2975
Developing SQL Data Models
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.
Length (Days)
3
Price
$
1785
Writing Reports with Report Builder and SSRS Level 2
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.
Length (Days)
2
Price
$
1190