All courses

All courses

  • 20461 Querying Microsoft SQL Server

    Overview 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. The main purpose of the course is to prepare people for the exam "70-461: Writing [...]

  • 20462 Administering Microsoft SQL Server Databases

    Overview This 5-day course provides participants with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. This 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 participants who are interested in learning SQL Server 2012 [...]

  • 20463 Implementing a Data Warehouse with Microsoft SQL Server

    Overview This 5-day course describes how to implement a data warehouse platform to support a business intelligence (BI) solution. Participants will learn how to create a data warehouse with Microsoft SQL Server, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data [...]

  • 20464 Developing Microsoft SQL Server Databases

    Overview This 5-day course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focuses 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 trigger are also covered in this course. [...]

  • 20465 Designing Database Solutions for Microsoft SQL Server

    Overview This 3-day instructor-led course focuses on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. This course describes how to consolidate SQL Server workloads and how to plan and implement high availability and disaster recovery solutions. Enroll 20465 Designing Database Solutions for Microsoft SQL ServerEnroll NowPrerequisites Participants [...]

  • 20466 Implementing Data Models and Reports with Microsoft SQL Server

    Overview The focus of this 5-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. Enroll 20466 Implementing Data Models and [...]

  • 20467 Designing Business Intelligence Solutions with Microsoft SQL Server

    Overview This 5-day training course teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server and other Microsoft BI technologies. Enroll 20467 Designing Business Intelligence Solutions with Microsoft SQL ServerEnroll NowPrerequisites In additional to their professional experience, participants who attend this training should [...]

  • 20480 Programming in HTML5 with JavaScript and CSS3

    Overview This 5-day course provides an introduction to HTML5, CSS3, and JavaScript. This course helps participants gain basic HTML5/CSS3/JavaScript programming skills. This course is an entry point into both the Web application and Windows Store apps training paths. The course focuses on using HTML5/CSS3/JavaScript to implement programming logic, define and use variables, perform looping and [...]

  • 20481 Essentials of Developing Windows Store Apps Using HTML5 and JavaScript

    Overview In this 5-day instructor-led course, participants will learn essential programming skills and techniques required to develop Windows Store apps. This includes a combination of both design and development skills, as well as ensuring that participants are comfortable using and making the most of the Microsoft Visual Studio and Expression Blend Tools. Prerequisites Participants who [...]