Microsoft training & certification    SQL Server 2016 Training & Certification

Upgrade Your Skills to SQL Server 2016

The power of data is transforming the world. To meet the growing and evolving demands, they are being asked to do more with less, and to drive business results with new technologies. With advanced analytics from Microsoft SQL Server 2016, you can not only see your data, but also understand and make business decisions. With so many companies now relying on the data analytics, employees with SQL skills are highly sought after by employers.

Boost your value in the workplace by earning yourself Microsoft SQL Server certifications. From the product exploration to deep training and certification, these learning opportunities can help you master the required skills.

Deliver faster data insights that drive business transformations with these popular Microsoft SQL Server Certifications.

MCSA: SQL 2016 Database Administration

MCSA: SQL 2016 Database Administration

This certification demonstrates your skill with database installation, maintenance, configuration and provisioning tasks. It qualifies you for a position as a database administrator or infrastructure specialist.

Take and pass 2 required courses:

20764: Administering a SQL Database Infrastructure

- This course provides knowledge and skills to administer a SQL server database infrastructure. It will be useful to individuals who develop applications that deliver content from SQL Server databases.

- This course is also available as Microsoft On-Demand (MOC On Demand) to help you build Microsoft technology skills at your own schedule.

20765: Provisioning SQL Databases

- This course teaches students how to provision SQL Server databases both on premise and in SQL Azure. This course is suitable for individuals who administer and maintain SQL Server databases, as well as those who develop applications that deliver content from SQL Server databases.

MCSA: SQL 2016 Database Development

MCSA: SQL 2016 Database Development

This certification determined your skills as a database professional, for both on-premises and cloud-based databases. It qualifies you for a position as a database developer.

Take and pass 2 required courses:

20761: Querying Data with Transact-SQL

- 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 such as: Database Administration, Database Development and Business Intelligence. As such, this course is suitable for Database Administrators, Database Developer and BI professionals.

20762: Developing SQL Databases

- This course provides students with knowledge and skills to develop a Microsoft SQL Server database. This course focuses on teaching individuals on the method of using SQL Server product features and the relevant tools to develop a database.

MCSA: SQL 2016 BI Development

MCSA: SQL 2016 BI Development

This certification validates your extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes. It qualifies you for the position as BI developer.

Take and pass 2 required courses:

20767: Implementing a SQL Data Warehouse

- This course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install. This course is recommended to Business Intelligence Developer that will need to focus on hands-on work to create BI solutions which including Data Warehouse implementation, ETL and data cleansing.

20768: Developing SQL Data Models

- This course focuses on creating managed enterprise BI solutions. It describes the implementation of both multidimensional and tabular data models, as well as the method to create cubes, dimensions, measures and measure group. It is suitable for BI developer to create enterprise BI solutions.

MCSA: BI Reporting

MCSA: BI Reporting

This certification indicates your expertise in analysing data with both Power BI and Excel. It is the first step on your path to becoming a Data Management and Analytics Microsoft Certified Solutions Expert (MCSE).

Take and pass 2 required courses:

20778: Analyzing Data with Power BI

- From this course, you can expect to gain knowledge and skills of analysing data using Power BI. It is suitable for those who need to utilize Power BI for data analysis and audiences who are technically proficient business users.

20779: Analyzing Data with Excel

- From this course, you’ll be able to master the ability of adding BI techniques to Excel data analysis. This course is intended for those who are interested in adding BI techniques on their data analysis with Excel and also who are interested in presenting data with alternate methods.

Get started with these E-books

SQL Server Performance: Faster Querying with SQL Server

SQL Server performance: Faster querying with SQL Server

This eBook covers tools and features like columnstore indexes and Adaptive Query Processing, with technical details on how to put these capabilities into practice.

SQL Server on Linux: A guide to re-platforming and modernising your data worloads

SQL Server on Linux: A guide to re-platforming and modernising your data workloads

By reading this eBook, you’ll learn how SQL Server on Linux enables you to harness the latest capabilities of SQL Server on your choice of platform – not only Windows and Linux, but containers, too.

 © Info Trek Sdn Bhd 2019