go backmicrosoft courses

τα επίσημα σεμινάρια εκπαίδευσης και πιστοποίησης για τον SQL Server

Ταξινόμηση με: Τίτλο | Κωδικό Σεμιναρίου

10985 - Introduction to SQL Databases

This course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.

Duration in hours : 24
Audience : IT Professionals
Level : Intermediate
Technology : SQL Server

10986 - Updating Your Skills to SQL Server 2016

This course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.

Duration in hours : 24
Audience : IT Professionals
Level : Advanced
Technology : SQL Server

10987 - Performance Tuning and Optimizing SQL Databases

This course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.

Duration in hours : 32
Audience : IT Professionals
Level : Advanced
Technology : SQL Server

10988 - Managing SQL Business Intelligence Operations

This three-day instructor-led course is aimed at database professionals who manage Business Intelligence (BI) operations. This course looks at various options that provide the ability of business users to analyze data and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources.

Duration in hours : 24
Audience : BI Professional
Level : Intermediate
Technology : SQL Server, BI

10990 - 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.

Duration in hours : 40
Audience : Data Professionals
Level : Advanced
Technology : SQL Server

10994 - Data Analysis Fundamentals using Excel

The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.This course is intended for anyone who wants to take the data analysis technologies in Excel beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships.

Duration in hours : 16
Audience : Information Worker, IT Professional, Data Professional
Level : Intermediate
Technology : SQL Server, Excel, Power BI

10998 - Updating Your Skills to SQL Server 2017

This instructor-led course is aimed at database professionals looking to update their skills to cover SQL Server 2017.
The primary audience for this course is existing database professionals with experience of SQL Server 2016 who want to update their skills to SQL Server 2017.
The secondary audience is existing SQL Server 2016 MCSAs who want to prepare for the Upgrade exam for SQL Server 2017 certification.

Duration in hours : 16
Audience : Data Professional
Level : Intermediate
Technology : SQL Server

10999 - SQL Server on Linux

This two-day instructor led training course is aimed at database professionals looking to implement SQL Server on Linux.
The primary audience for this course is existing database professionals with experience of database systems running on Linux.
The secondary audience is Linux professionals who are interested in adding database capabilities.

Duration in hours : 16
Audience : IT Professional, Data Professional
Level : Intermediate
Technology : SQL Server

20462 - Administering Microsoft SQL Server 2014 Databases

This instructor-led course provides students 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.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Duration in hours : 40
Audience : IT Professional, Data Professional
Level : Advanced
Technology : SQL Server

20463 - Implementing a Data Warehouse with Microsoft SQL Server 2014

his course describes how to implement a data warehouse platform to support a BI solution. Students 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.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Duration in hours : 40
Audience : IT Professional
Level : Advanced
Technology : SQL Server

20464 - Developing Microsoft SQL Server 2014 Databases

This instructor-led course introduces 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, and triggers are also covered in this course. Also this course helps you prepare for the Exam 70-464.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Duration in hours : 40
Audience : IT Professionals
Level : Advanced
Technology : SQL Server

20465 - Designing Solutions for Microsoft SQL Server 2014

The focus of this instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads and how to plan and implement high availability and disaster recovery solutions.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Duration in hours : 24
Audience : IT Professionals
Level : Advanced
Technology : SQL Server

20466 - Implementing Data Models and Reports with SQL Server 2014

The focus of this five-day instructor-led 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.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Duration in hours : 40
Audience : IT Professional
Level : Advanced
Technology : SQL Server

20467 - Designing Business Intelligence Solutions with Microsoft SQL Server 2014

This training course teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server 2014 and other Microsoft BI technologies.This course is not designed for students who are new to SQL Server 2014 BI technologies; it is targeted at BI professionals with experience of implementing solutions with SQL Server database Engine, SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services.

Duration in hours : 40
Audience : IT Professional
Level : Advanced
Technology : SQL Server

20761 - Querying Data with Transact-SQL

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first 10 modules can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. The remaining modules has skills required to take exam 70-761.

Duration in hours : 40
Audience : Data Professional
Level : Intermediate
Technology : SQL Server

20762 - Developing SQL Databases

This course provides students with the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.

Duration in hours : 40
Audience : IT Professionals
Level : Advanced
Technology : SQL Server

20764 - Administering a SQL Database Infrastructure

This instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

Duration in hours : 40
Audience : IT Professionals
Level : Advanced
Technology : SQL Server

20765 - Provisioning SQL Databases

This 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.

Duration in hours : 40
Audience : IT Professionals
Level : Intermediate
Technology : SQL Server

20767 - Implementing a SQL Data Warehouse

This course provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.

Duration in hours : 40
Audience : BI Professionals, ETL Developers, DB Developers
Level : Advanced
Technology : SQL Server

20768 - Developing SQL Data Models

This 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.

Duration in hours : 24
Audience : BI Professionals, Data Analysts, BI Developers
Level : Intermediate
Technology : SQL Server
1 2