Overview/Description In addition to Windows Azure SQL Database, Windows Azure enables you to configure and manage a VM dedicated to running an instance of SQL Server. High availability is the ability of a service to continue after a failure, and SQL Server 2014 has a number of options for implementing high availability. This course covers VMs on Windows Azure, and how to install, configure and manage SQL on a VM, and high availability in SQL 2014 including Windows Server Failover Clusters, AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups. This course is part of a series...

Overview/Description Backup and recovery planning are key to any organizations who implement SQL Server 2014. This course covers backup and recovery, how to create and maintain a disaster recovery plan, and configuration and management of SQL Server replication. This course is part of a series of Skillsoft courses that covers the objectives for exam 70-465. This exam is required for the certification MCSE: Data Platform. Target Audience Database professionals who design and build database solutions, create plans and designs for database structure, storage, objects and servers, and plan...

Overview/Description Once the business requirements are determined during the design stage of building a business intelligence solution, the data warehouse needs to be designed and then populated with the data required for analysis and reporting from the source systems. SQL Server 2014 provides an Extract, Transform, and Load (ETL) process to perform this task. This course will discuss and demonstrate how to build an ETL solution to gather the data required, transform it to conform to the destination, and the load it to the data warehouse. You will also learn how to deploy and manage the ETL...

Overview/Description The primary goal of a Business Intelligence solution is the delivery of meaningful data to the business users to make informed decisions required the business. During the planning of the BI solution, you need to include the design and creation of the Reporting Services solution to create and deliver the reports. In this course, you will explore how to design and create a reporting services solution to create reports for delivery. This course is one of a series in the Skillsoft learning path that helps individuals prepare for the Designing Business Intelligence Solutions...