Microsoft 70-465: Designing Database Solutions for SQL Server 2012

Please note that Microsoft have retired this exam. Although the exam(s) associated with this course has been retired by Microsoft, this course still retains value as a training resource & learners will receive a certificate of completion after completing the course.

Today’s IT Industry demands that professionals cover the latest technology on the marketplace. Many IT professionals separate themselves from their competitors by achieving certifications in the most current technologies and giving themselves skill-sets that are unmatched by many of their peers. This course has been designed to prepare you for the Microsoft 70-465 exam.

Certificate of completion

Digital certificate - Included

• 12 months unlimited access
• Certificate of completion awarded upon completing the course to show to employers or prospective employers your new skills
• Free upgrade on to our premium platform
• Free career advice available upon request after completing the course

Today’s IT Industry demands that professionals cover the latest technology on the marketplace. Many IT professionals separate themselves from their competitors by achieving certifications in the most current technologies and giving themselves skill-sets that are unmatched by many of their peers.

This course has been designed to prepare you for the Microsoft 70-465 exam. The exam covers the following topics:

• Design a database structure.
• Design databases and database objects.
• Design database security.
• Design a troubleshooting and optimisation solution.

This course is designed for Database professionals who design and build database solutions. These Database professionals are responsible for the creation of plans and designs for Database structure, storage, objects, and servers, as well as creating the plan for the environment in which the database solution runs. Primary responsibilities may include but are not limited to designing:

• Data compression strategies
• Database models
• Full-Text Search strategies
• High-availability solutions
• Maintenance strategy for database servers
• Management automation strategies
• Migration, consolidation, and upgrade strategies
• Database, schema, and object security parameters

Module Breakdown

Module 1: Designing a Database Server Infrastructure

• 1.1 Introduction
• 1.2 Designing a Database Server Infrastructure Part 1
• 1.3 Designing a Database Server Infrastructure Part 2
• 1.4 Designing a Database Server Infrastructure Part 3
• 1.5 Designing a Database Server Infrastructure Part 4
• 1.6 Considerations for Database Server Consolidation
• 1.7 Managing Server Resources

Module 2: Designing a Logical Database Scheme

• 2.1 Designing a Logical Database Scheme Part 1
• 2.2Designing a Logical Database Scheme Part 2
• 2.3 Designing a Logical Database Scheme Part 3
• 2.4 Designing a Logical Database Scheme Part 4
• 2.5 Designing a Logical Database Scheme Part 5

Module 3: Designing a Physical Database Implementation

• 3.1 Designing a Physical Database Implementation Part 1
• 3.2 Designing a Physical Database Implementation Part 2
• 3.3 Designing a Physical Database Implementation Part 3

Module 4: Incorporating Data Files into the Database

• 4.1 Incorporating Data Files into the Database Part 1
• 4.2 Incorporating Data Files into the Database Part 2
• 4.3 Incorporating Data Files into the Database Part 3
• 4.4 Incorporating Data Files into the Database Demo
• 4.5 Searching Data Files
• 4.6 Searching Data Files Demo

Module 5: Tuning Database Performance

• 5.1 Tuning Database Performance Part 1
• 5.2 Tuning Database Performance Part 2
• 5.3 Tuning Database Performance Part 3
• 5.4 Working with Query Plans Part 1
• 5.5 Working with Query Plans Part 2
• 5.6 Working with Query Plans Part 3
• 5.7 Working with Query Plans Part 4

Module 6: Designing Database Security

• 6.1 Designing Database Security Part 1
• 6.2 Designing Database Security Part 2
• 6.3 Contained Databases
• 6.4 Protecting Data with Encryption

Module 7: Policy Based Management

• 7.1 Policy Based Management
• 7.2 Policy Based Management Demo

Module 8: Monitoring Server Health

• 8.1 Monitoring Server Health
• 8.2 Monitoring Server Health Demo

Module 9: Designing Database Backup Solution

• 9.1 Designing Database Backup Solution Part 1
• 9.2 Designing Database Backup Solution Part 2
• 9.3 Designing Database Backup Solution Part 3
• 9.4 Designing Database Backup Solution Part 4
• 9.5 Disaster Recovery Plan Part 1
• 9.6 Disaster Recovery Plan Part 2

Module 10: Automating Multi Server Maintenance

• 10.1 Automating Multi Server Maintenance
• 10.2 Managing Multiple Servers

Module 11: Managing SQL Server with Windows PowerShell

• 11.1 Managing SQL Server with Windows PowerShell
• 11.2 Windows PowerShell Lab

Module 12: Replicating Data

• 12.1 Replicating Data Part 1
• 12.2 Replicating Data Part 2
• 12.3 Replicating Data Part 3

Why My Training Academy? My Training Academy’s training courses are light-years ahead of our competitors. We provide expert instructor-led training modules with customised presentations, practice exam simulators and learning supplements that provide the full benefits of live classroom training – you can study when and where you want, at your own pace.

Benefit? Our online courses are delivered by the industry’s finest instructors, with a minimum of 15 years real world experience and experts in their fields. You will learn all the relevant skills to support you in attaining your dream job. Gain the skills in demand by employers and the confidence that you’re one step closer to your dream job, promotion or new career.

Why not try the training for free? Request a free demo today at no extra cost.

Invest in yourself: Acquiring these vital business skills – will repay the cost in improved employment opportunities and job satisfaction. What better investment than in your own future? The sooner you start, the sooner you will benefit.

When can I start? Enquire today, simply enrol and you can start studying today if you wish.

What are our students saying about us? I have just bought the Networking Bundle from My Training Academy and can't wait to get started! The service received from John was first class, He gave me a fantastic price on the bundle which I really appreciated having recently been made redundant. Really helpful to have a free demo to see the course before buying. Really like this style of training it will suit me down to the ground, can’t thank you enough.