Loading Classes
Designing a Data Solution with Microsoft SQL Server (20465)
New Age Technologies has been delivering Authorized Training since 1996. We offer Microsoft’s full suite of authorized courses including courses pertaining to Designing a Data Solution with Microsoft SQL Server, SharePoint 2013 Business Intelligence, Programming in HTML5 with JavaScript and CSS3, Microsoft Office, Microsoft Exchange Server, and more. If you have any questions or can’t seem to find the Microsoft class that you are interested in, contact one of our Microsoft Training Specialists. Invest in your future today with Microsoft training from New Age Technologies.
✉ Microsoft Training Specialist | ☏ 502.909.0819
Current Promotion
EXCLUSIVE BENEFIT:
This course includes a twelve-month subscription to these exclusive benefits:
- 12 months of anytime access to your course labs and lab environment
- 12 months of 24/7 access to mentoring via chat, email, and phone
- 12 months of on-demand access to indexed, searchable recordings of your Online Live class
- 12 months of unlimited retakes of your class
COURSE INFORMATION
Designing a Data Solution with Microsoft SQL Server (20465) Overview:
In the Designing a Data Solution with Microsoft SQL Server (20465) course, you will learn to plan and implement enterprise database infrastructure solutions using Microsoft SQL Server 2012 and 2014.
You will also learn:
- Enterprise Data Architecture
- Multi-server configuration management
- Database solutions including:
- Consolidating database workloads
- Cloud data
- Microsoft Azure services
- High availability
- Clustering
- AlwaysOn Availability
- Disaster recovery
- Data replication
This course covers the skills and knowledge measured by Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012 and, in conjunction with on-the-job experience, can help you prepare for the exam.
Who Should Attend:
- IT professionals who design database solutions and have experience with database development and administration of SQL Server databases
- IT professionals who need to learn database infrastructure, consolidation strategies, IT scenarios for on-premise, cloud and hybrid, high availability and disaster recovery solutions
Designing a Data Solution with Microsoft SQL Server (20465) Prerequisites:
Before attending this course, you must have:
- Technical knowledge of relational databases, including:
- Database planning
- Implementation
- Management
- Querying with Transact-SQL
- Basic knowledge of high availability, disaster recovery, and Microsoft Azure technologies around cloud computing
Designing a Data Solution with Microsoft SQL Server (20465) Objectives:
After successfully completing this course, you will be able to:
- Access an Existing Enterprise Environment
- Plan and Implement Policy-Based Management
- Consolidation Workloads
- Private Cloud Considerations
- Microsoft Azure Storage
- Implement and Configure Databases in Microsoft Azure Database and in Microsoft Azure Virtual Machines
- Windows Server Failover Clustering and AlwaysOn Failover Cluster Instance
- AlwaysOn Availability Groups Implementation
- High Availability and Disaster Recovery Solutions
- Plan and Implement Database Replication
Designing a Data Solution with Microsoft SQL Server (20465) Outline:
Module 1: Introduction to Enterprise Data Architecture
- Enterprise Data Considerations
- Access an Existing Infrastructure
- Module 1 Labs: Assess an Existing Enterprise Data Infrastructure
- MAP Toolkit
- Review MAP Toolkit Reports
Module 2: Multi-Server Configuration Management
- Policy-based Management
- Microsoft System Center
- Module 2 Labs: Plan and Implement Policy-Based Management
Module 3: Consolidate Database Workloads with SQL Server 2014
- Database Server Consolidation Considerations
- Resource Management in a Consolidated Database Infrastructure
- Module 3 Labs: SQL Server Consolidation
- Prepare for Database Consolidation
- Manage Resources for an Instance of SQL Server
- Manage Resources for Multiple Instances on a Windows Server
Module 4: Introduction to Cloud Data Solutions
- Cloud Computing
- SQL Server in a Private Cloud
- Module 4 Labs: Prepare a SQL Server Installation in a Virtual Machine Template
- Create and Complete a Prepared Instance
Module 5: Introduction to Microsoft Azure
- Microsoft Azure Overview and Microsoft Storage
- Module 5 Labs: Microsoft Azure
- Create a Microsoft Azure Storage Account
- Backup a Database to Microsoft Azure
Module 6: Microsoft Azure SQL Database
- Introduction to Microsoft Azure SQL Database
- Microsoft Azure SQL Database Security
- Implement and Manage Databases
- Module 6 Labs: Microsoft Azure SQL Database
- Provision a Microsoft Azure SQL Database
- Configure Microsoft Azure SQL Database Security
- Migrate a Database to Microsoft Azure SQL Database
Module 7: SQL Server in Microsoft Azure Virtual Machines
- Introduction to Microsoft Azure Virtual Machines
- Microsoft Azure Virtual Machine Connectivity and Security
- Create Databases in a Microsoft Azure Virtual Machine
- Module 7 Labs: Plan Policy-Based Management Microsoft Azure Virtual Machines
- Create a Microsoft Azure Virtual Machine
- Configure Microsoft Azure Virtual Machine Security and Connectivity
- Create Databases on a Virtual Machine
Module 8: Introduction to High Availability in SQL Server 2014
- High Availability Concepts and Options in SQL Server 2014
- Log Shipping
- Module 8 Labs: Log Shipping
- Configure and Test Log Shipping
- Test Failover
Module 9: Clustering with Windows Server and SQL Server 2014
- Introduction to Windows Server Failover Clustering
- SQL Server AlwaysOn Failover Cluster Instances
- Module 9 Labs: Implement an AlwaysOn Failover Cluster Instance
- Windows Server Failover Cluster Configuration
- Install an AlwaysOn Failover Cluster Instance
- Configure tempdb to use Local Storage
- Test Automatic Failover and Failback
Module 10: Automating Multi-Server Maintenance AlwaysOn Availability Groups
- AlwaysOn Availability Groups Introduction and Considerations
- Module 10 Labs: Implement and Test an AlwaysOn Availability Group
- Implement and Connect to an AlwaysOn Availability Group
- Test Failover
- Configure Quorum Voting
Module 11: Plan High Availability and Disaster Recover
- High Availability and Disaster Recovery with SQL Server 2014
- High Availability and Disaster Recovery for Databases in Microsoft Azure
- Module 11 Labs: Plan High Availability and Disaster Recovery
- High Availability and Disaster Recovery Solutions with SQL Server 2014 and using Microsoft Azure
Module 12: Replicating Data
- SQL Server Replication
- Planning Replication
- Module 12 Labs: Plan and Implement Replication
/Salary/by_Job/300s.png)
