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:
|
10987 - Performance Tuning and Optimizing SQL Databases |
28.00 |
$2,319.00 |
|
Description: This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.
Audience profile
The primary audience for this course is individuals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure optimal execution performance of the workloads.
The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.
Skills gained
Describe the high level architectural overview of SQL Server and its various components.
Describe the SQL Server execution model, waits and queues.
Describe core I/O concepts, Storage Area Networks and performance testing.
Describe architectural concepts and best practices related to data files for user databases and TempDB.
Describe architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking.
Describe architectural concepts of the Optimizer and how to identify and fix query plan issues.
Describe architectural concepts, troubleshooting scenarios and best practices related to Plan Cache.
Describe architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.
Explain data collection strategy and techniques to analyze collected data.
Understand techniques to identify and diagnose bottlenecks to improve overall performance.
# of Days:
Setting:
|
10990 - Analyzing Data with SQL Server Reporting Services |
35.00 |
$2,899.00 |
|
Description: This five-day instructor-led 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.
Audience profile
The primary audience for this course is database professionals who need to fulfil a BI developer role to create reports. Primary responsibilities will include implementing reports and mobile reports.
The secondary audiences for this course are power information workers.
# of Days:
Setting:
|
20461 - Querying Microsoft SQL Server 2014 |
35.00 |
$2,899.00 |
|
Description: This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.
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:
|
20462 - Administering Microsoft SQL Server 2014 Databases |
35.00 |
$2,899.00 |
|
Description: This five-day 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.
# 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:
|
20464 - Developing Microsoft SQL Server 2014 Databases |
35.00 |
$2,899.00 |
|
Description: This 5-day 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.
# of Days:
Setting:
|
20465 - SQL Server 2014: Designing Database Solutions for Microsoft SQL Server 2014 |
35.00 |
$2,899.00 |
|
Description: This course describes how to design and monitor high performance, highly available data solutions with SQL Server 2014. This course focuses on creating plans and designs for database structure, storage, objects, and servers. Students will have the opportunity to practices hands-on skills and design tasks in a virtual lab environment and will learn about topics such as data compression, high availability, data migration, security, and scalability.
This course maps to skills and knowledge measured by Microsoft Exam 70-465, and in conjunction with on-the-job experience, can help prepare your for the exam.
# 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:
|
20467 - Designing Self-Service Business Intelligence and Big Data Solutions |
35.00 |
$2,899.00 |
|
Description: This five-day instructor-led course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform. The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 Power BI to create self-service data models and reports. The course then goes on to describe how to use Windows Azure HDInsight to perform Big Data analysis.
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.
This course maps to skills and knowledge measured by Microsoft Exam 70-467, and in conjunction with on-the-job experience, can help prepare you for the exam.
# 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:
|
20764 - Administering a SQL Database Infrastructure |
35.00 |
$2,899.00 |
|
Description: This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.
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:
|
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:
|
20767 - Implementing a SQL Data Warehouse |
35.00 |
$2,899.00 |
|
Description: This five-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 are database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.
# of Days:
Setting:
|
20768 - Developing SQL Data Models |
21.00 |
$1,739.00 |
|
Description: The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.
Audience profile
The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions. Primary responsibilities will include:
Implementing multidimensional databases by using SQL Server Analysis Services
Creating tabular semantic data models for analysis by using SQL Server Analysis Services
The secondary audiences for this course are power information workers/data analysts.
# 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:
|
CIPTV1: Implementing Cisco IP Telephony Video, Part 1 |
35.00 |
$3,695.00 |
|
Description: Implementing Cisco IP Telephony Video, Part 1 (CIPTV1) v1.0 is a five-day course that prepares the learner for implementing a Cisco Collaboration solution at a single-site environment. This course focuses primarily on Cisco Unified Communications Manager Version 10.x, which is the call-routing and signaling component for the Cisco Collaboration solution.
Lab exercises included in the course help learners to perform post installation tasks, configure Cisco Unified Communications Manager, implement MGCP and H.323 and, SIP trunks, and build dial plans to place single site on-cluster and off-cluster calling for voice and video. Learners will also implement media resources, audio and video conferencing, and describe QoS.
# of Days:
Setting:
|
CIPTV2: Implementing Cisco IP Telephony Video, Part 2 |
35.00 |
$3,695.00 |
|
Description: Implementing Cisco IP Telephony Video, Part 2 (CIPTV2) v1.0 is a five-day course that prepares the learner for implementing Cisco Unified Communications Manager, Cisco VCS-C, and Cisco Expressway series in a multisite voice and video network. It covers globalized call routing, URI call routing, global dial plan replication based on the ILS, Cisco Unified SRST, mobility features, call admission control, integration of Cisco VCS and Cisco Unified Communications Manager, and Cisco Mobile Remote access on Cisco Expressway Series.
# of Days:
Setting:
|
CIVND: Implementing Cisco Video Network Devices Part 1 and Part 2 |
35.00 |
$4,995.00 |
|
Description: This course is a new 5-day ILT class designed to provide students with the necessary knowledge and skills to implement various Cisco Video endpoints in converged Cisco video infrastructures. Cisco business video solutions has four major Cisco Medianet application components: - Unified Communication and Collaboration - TelePresence - Digital Media Suite (DMS) - Video Surveillance. Part 1 is designed to provide students with the necessary knowledge to describe characteristics of video solutions and assess the requirements for a successful implementation of a video solution. And describes the characteristics of a video solution and enables students to evaluate the general requirements for video deployments such as coding options, media formats, protocols, network impact, high-level architectural components and their interactions, and requisites to the environment. Part 2 describes Cisco business video solutions and enables students to implement and troubleshoot Cisco Unified Communication and Collaboration, TelePresence and Digital Media Player in different Cisco business video solution architectures.
# of Days:
Setting:
|
CTCOLLAB: Troubleshooting Cisco IP Telephony and Video |
35.00 |
$3,695.00 |
|
Description: Troubleshooting Cisco IP Telephony Video (CTCOLLAB) v1.0 is a five-day course that prepares the learner for troubleshooting Cisco Unified Communications Manager, Cisco VCS-C, and Cisco Expressway series in a multisite voice and video network. The course teaches troubleshooting methodology, triage, resources, tools, and fixes at the integrated system or solution level for Cisco Collaboration Solutions. It covers troubleshooting of Cisco Unified Communications Manager, VCS Control and VCS Expressway, issues with Call Setup, issues with ILS, Cisco Unified Communications Manager Mobility Features, Cisco TelePresence Management Suite, and issues with Voice Quality and Media Resources.
# of Days:
Setting:
|