| Course Name |
Hours |
List Price |
Content |
| 10985 - Introduction to SQL Databases |
21.00 |
$1,739.00 |
|
Description: This three-day instructor-led 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.
# of Days:
Setting:
|
| 10986 - Updating Your Skills to SQL Server 2016 |
21.00 |
$1,739.00 |
|
Description: This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.
Audience profile
The primary audience for this course are existing database professionals with experience of SQL Server 2014 who want to update their skills to SQL Server 2016. Additional this course is for existing SQL Server 2014 MCSAs who want to prepare for the Upgrade exam for SQL Server 2016 certification.
# of Days:
Setting:
|
| 20463 - Implementing a Data Warehouse with Microsoft SQL Server 2014 |
35.00 |
$2,899.00 |
|
Description: This 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.
# of Days:
Setting:
|
| 20466 - Implementing Data Models and Reports with Microsoft SQL Server |
35.00 |
$2,899.00 |
|
Description: 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.
# of Days:
Setting:
|
| 20761 - Querying Data with Transact-SQL |
35.00 |
$2,899.00 |
|
Description: This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 5 teach the remaining skills required to take Exam 70-761.
Audience profile
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who arent necessarily database-focused; namely, report writers, business analysts and client application developers.
# of Days:
Setting:
|
| 20762 - Developing SQL Databases |
35.00 |
$2,899.00 |
|
Description: This four-day instructor-led 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.
Audience profile
The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2016 product features and technologies for implementing a database.
The secondary audiences for this course are individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server 2016 database.
# of Days:
Setting:
|
| 20765 - Provisioning SQL Databases |
35.00 |
$2,899.00 |
|
Description: This three-day instructor-led 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.
Audience profile
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.
# of Days:
Setting:
|
| 40364 - Database Administration Fundamentals |
21.00 |
$1,739.00 |
|
Description: This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam.
Audience Profile
The Microsoft Technology Associate (MTA) is Microsofts newest suite of technology certification exams that validate fundamental knowledge needed to begin building a career using Microsoft technologies. This program provides an appropriate entry point to a future career in technology and assumes some hands-on experience or training but does not assume on-the-job experience.
# of Days:
Setting:
|
| 55120: Quick Microsoft SQL Server 2012-2014 Integration Services |
14.00 |
$1,159.00 |
|
Description: This two-day instructor-led course is intended for those that are new to SQL Server Integration Services or are interested in learning the features available. This course uses an instructor-led topic explanation, instructor performing detailed demonstrations, then the student performing exercises to duplicate what the instructor demonstrated. This style of training is a combination of traditional classroom training and mentored learning. Additionally, videos of the demonstrations performed by the course author are included with the course as a take-away. The course completes with additional scenario-based labs to reinforce the course content.
# of Days:
Setting:
|