Microsoft 70-465: Designing Database Solutions For Microsoft Sql Server 2012
Original price was: £295.00.£99.00Current price is: £99.00.
Course Description
Microsoft SQL Server 2012 is the one of the latest versions of Microsoft SQL Server, the extremely popular and widely used database system in the world.
This course describes how to design and monitor high performance, highly available data solutions with SQL Server 2012.Study247 Academy offers Designing Database Solutions for Microsoft SQL Server 2012 course which focuses on creating plans and designs for database structure, storage, objects, and servers.
Who is this course aimed at?
Professionals who plan and design database solutions for organisations and have experience with database development and administering SQL Server databases.
By choosing online learning instead of a classroom based course, it eliminates the need for time away from work, saving you valuable time and money. It is ideal for those with tight schedules as our online courses give you 12 months unlimited access to all the course materials, so you can study at a pace that suits you. Allowing you to easily resume your studies whenever you have the time. All you need is internet connection to study, so you can study from the comfort of your home or any environment that suits you.
What is included in this course?
When you enrol, you’ll not only gain powerful, career-enhancing skills but also receive exclusive benefits, including:
Course Assessment Process
In order to earn your certification, you’ll have to sit an exam after completing your course with us. To prepare you for your exam, we provide interactive quizzes after each module and a mock exam at the end of your course to ensure you’re fully prepared for the real thing. Once you’ve passed with at least 85%, you’ll be ready to book your exam as a private candidate.
Booking your exam is pretty simple, just purchase your exam voucher and schedule your exam. To make life easier, we can help you find an appropriate exam centre and give you all the information you need to secure your place.
Please note that the exam fees aren’t included in the course price.
Got a question about exams? Contact one of our course advisors. We’re happy to help!
Requirements
Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.
For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player.
Career Path
We’ve put together a list of relevant job titles you can apply for after achieving the Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012 certification (note that some careers may require further study, training and/or work experience):
- Database Administrator
- Database Developer
- Database Analyst
Course Outline
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
Payment Options
Pay securely online by debit or credit card or PayPal. Buying for your team? Talk to us about team training.
Student Reviews
There are no reviews for this course yet.
