Designing a Data Solution with Microsoft SQL Server (MS-20465)

Rating:
100% of 100
This course is designed for customers who are interested in learning how to design a data solution with SQL Server database. It also covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
  • Virtual Classroom

    Learning Style
  • Intermediate

    Difficulty
  • 3 Days

    Course Duration
  • 3 Days

    SATV Value
Pricing
About Individual Course:
  • Individual course plan gives you access to this course
On Sale!
Now Only $999.00 Regular Price $2,195.00
Now Only $999.00 Regular Price $2,195.00
/ Seat
Team
Pricing
  • Buy 5-9 Enrollments And Save 10% ($899.00 each.)
  • Buy 10-19 Enrollments And Save 15% ($849.00 each.)
  • Buy 20-above Enrollments And Save 20% ($799.00 each.)
This course is designed for customers who are interested in learning how to design a data solution with SQL Server database. It also covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

About this course:

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.

The student can also focus through this course towards 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. This course also prepares the students for the Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server certification exam.

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.

The average salary for a Microsoft SQL Server Solution Architect is $120,000 per year.

Course Objectives:

After completing this course, students will be able to:

  • Assess an existing enterprise environment.
  • Plan and implement Policy-Based Management.
  • Describe the considerations for consolidating workloads with SQL Server 2014.
  • Describe considerations for including SQL Server 2014 in a private cloud.

Audience:

This course is intended for database professionals who need who plan, implement, and manage database solutions. Primary responsibilities include:

  • Planning and implementing database infrastructure.
  • Planning and implementing consolidation strategies. 
  • Planning and implementing high availability solutions.
  • Planning and implementing disaster recovery solutions.

Prerequisites:

This course requires that you meet the following prerequisites:

  • At least 2 years’ experience of working with relational databases, including:
  • Planning and implementing databases
  • Managing databases
  • Querying with Transact-SQL
  • Some basic knowledge of high availability and disaster recovery

Suggested prerequisites courses:

More Information
Brand Microsoft
Lab Access Yes
Technology Microsoft
Learning Style Virtual Classroom
Difficulty Intermediate
Course Duration 3 Days
Language English
SATV Value 3 Days
VPA Eligible VPA Eligible
Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account
Sales Support

Sales (866) 991-3924

Mon-Fri. 8am-6pm CST

Have Questions? Ask Us.

Why QuickStart

Turn Training Into A Personalized Learning Experience


  • Problem Solving through ExpertConnect & Peer-To-Peer Learning
  • Find The Quickest Path To Learn With Career Paths
  • Access All Courses With Master Subscription
  • Manage Your Team With Learning Analytics
  • Virtual Classroom Training & Self-Paced Learning
  • Integrate With Your LMS Through API's