This course is aimed at introducing Transact-SQL students. It has been designed to allow students to learn the knowledge they need for other SQL Server curriculum courses for the first three days.

Fee: Contact Us For More Information

Duration: 5 days

This course provides participants with the knowledge and skills to develop a Microsoft SQL server database. This course is a five day instructor-led course

Fee: Contact Us For More Information

Duration: 5 days

This course last five-day and led by instructor, this course will provides participants who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure.

Fee: Contact Us For More Information

Duration: 5 days

This course is designed to teach participants how to provision SQL Server databases both on premise and in SQL Azure.

Fee: Contact Us For More Information

Duration: 5 days

This course last five-day and is led by instructor, this course will provides participants with the knowledge and skills to provision a Microsoft SQL Server database.

Fee: Contact Us For More Information

Duration: 5 days

This course is a 3-day instructor-led course that is focused on creating managed enterprise BI solutions

Fee: Contact Us For More Information

Duration: 3 days

This course is a 5-day instructor course, where participants learn how to use a reporting services solution from SQL Server 2016 for an organisation’s data analysis.

Fee: Contact Us For More Information

Duration: 5 days

This course four-day training provides students with the expertise and ability to perform and optimise their databases, who control and manage SQL Server databases.

Fee: Contact Us For More Information

Duration: 4 days

This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.

Fee: Contact Us For More Information

Duration: 4 days

This course will enable the students to understand Azure SQL Database, and educate the students on what is required to migrate MySQL and PostgreSQL workloads to Azure SQL Database.

Fee: Contact Us For More Information

Duration: 1 day

This two-day instructor-led course provides candidates with the knowledge and skills needed to use PowerShell and SMO components for SQL Server administration on SQL Server 2016, 2014 or 2012. Students will learn how to manage day-to-day and scheduled maintenance tasks. The main focus will be administration of the database engine, but optional material & exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.

If all the optional lab exercises are included, the class may need to be taught in three days instead of two.

Fee: Contact Us For More Information

Duration: 2 days

This course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling, and DAX.

Fee: Contact Us For More Information

Duration: 2 days

This course is designed to give the right amount of Internals knowledge, and wealth of practical tuning and optimization techniques, that you can put into production. The course offers a comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimize transaction log operations, tempdb and data file configuration, transactions and isolation levels, and locking and blocking. The course also teaches how to create baselines and benchmark SQL Server performance, how to analyze workload and figure out where performance problems are, and how to fix them. Coverage of in-memory tables and stored procedures along with an introduction to this exciting new technology is included.

Fee: Contact Us For More Information

Duration: 5 days