Notice : You are now accessing LOOP UAT SERVER. This is not meant for public access. For the actual LOOP Website please visit www.LOOP.sg instead


Certification at Your Fingertips - Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012


Certification at Your Fingertips - Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012, Singapore elarning online course

Course Description

This course prepares students for the Microsoft 70-465 Designing Database Solutions for Microsoft SQL Server 2012 exam. The course teaches students how to plan and implement enterprise database infrastructure solutions by using SQL Server 2012 and other Microsoft technologies. The course describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions.

Be fully prepared for your certifications exams!

- Learn of the examination outline before sitting for your certification
- Know and understand the topics that may be covered in your examinations
- Learn and understand the chapters for each tailored certification
- Go through past questions to have a feel of the examinations


Course Objectives

1. Designing A Database Server Infrastructure
2. Tuning Database Performance
3. Monitoring Server Health
4. Automating Multi Server Maintenance
5. Replicating Data


Related Courses

  • Certification at Your Fingertips - Microsoft 70-686 Pro: Windows 7, Enterprise Desktop Administrator

    Certification at Your Fingertips - Microsoft 70-686 Pro: Windows 7, Enterprise Desktop Administrator

    SGD $589.00

    Course Description

    Practice Lab  This course comes with a Remote Practice Environment, a virtual remote environment; where you are able to practically apply the skills you have learned on the respective server, systems and networks. With this platform, get one step ahead in your preparation for your certification exams! Whether it’s Cisco, Microsoft or VMware, our Practice Lab unifies access to all of these vendors through a web browser interface. Pre-configured hardware layouts with accompanying lab guides for fast, convenient access to gain hands on experience. With step-by-step instructions covering thousands of practical tasks across Cisco, Microsoft, VMware and CompTIA exam titles, the Practice Lab makes studying for an exam or learning new technologies an engaging experience. What this course prepares you for: Prepare for your Microsoft 70 -686 Pro: Windows 7, Enterprise Desktop Administrator certification exam with this course. This course will enable students to plan and deploy Windows 7 desktops in large organizations. Students will also be equipped with skills to design, configure and manage a Windows 7 Client Environment. At the end of this course, candidates will have understood the topics that are being covered for the examination.  Ace your certification examination with this preparation course! - Learn of the examination outline before sitting for your certification  - Know and understand the topics that may be covered in your examinations - Understand both practical and theory aspects of the examination - Apply the practical skills through the Remote Practice Environment

    Read more...

  • Certification at Your Fingertips - Microsoft 70-697: Configuring Windows Devices (Windows 10)

    Certification at Your Fingertips - Microsoft 70-697: Configuring Windows Devices (Windows 10)

    SGD $589.00

    Course Description

    Practice Lab  This course comes with a Remote Practice Environment, a virtual remote environment; where you are able to practically apply the skills you have learned on the respective server, systems and networks. With this platform, get one step ahead in your preparation for your certification exams! Whether it’s Cisco, Microsoft or VMware, our Practice Lab unifies access to all of these vendors through a web browser interface. Pre-configured hardware layouts with accompanying lab guides for fast, convenient access to gain hands on experience. With step-by-step instructions covering thousands of practical tasks across Cisco, Microsoft, VMware and CompTIA exam titles, the Practice Lab makes studying for an exam or learning new technologies an engaging experience. What this course prepares you for: This course will prepare you for the Microsoft 70 -697: Configuring Windows Devices (Windows 10) exam. The course will validate a candidate’s fundamental knowledge and skills for building solid identities, protection of content (data loss protection), mobile device management policy, virtualization with Hyper-V, application management using the Company Portal and the Windows Store. This course will cover topics related to the fundamental knowledge needed in order to sit for the examination.  Ace your certification examination with this preparation course! - Learn of the examination outline before sitting for your certification  - Know and understand the topics that may be covered in your examinations - Understand both practical and theory aspects of the examination - Apply the practical skills through the Simulated Practice Environment This course is SkillsFuture Credit Eligible.

    Read more...

  • Certification at Your Fingertips - Microsoft 70-410: Installing and Configuring Windows Server 2012

    Certification at Your Fingertips - Microsoft 70-410: Installing and Configuring Windows Server 2012

    SGD $589.00

    Course Description

    Practice Lab  This course comes with a Remote Practice Environment, a virtual remote environment; where you are able to practically apply the skills you have learned on the respective server, systems and networks. With this platform, get one step ahead in your preparation for your certification exams! Whether it’s Cisco, Microsoft or VMware, our Practice Lab unifies access to all of these vendors through a web browser interface. Pre-configured hardware layouts with accompanying lab guides for fast, convenient access to gain hands on experience. With step-by-step instructions covering thousands of practical tasks across Cisco, Microsoft, VMware and CompTIA exam titles, the Practice Lab makes studying for an exam or learning new technologies an engaging experience. What this course prepares you for: With this preparation course for Microsoft 70-410: Installing and Configuring Windows Server 2012, candidates will be able to revise and sharpen their skills and knowledge needed to pass the examination. This exam is part one of a series of three exams that test the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. Passing this exam validates a candidate’s ability to implement and configure Windows Server 2012 core services, such as Active Directory and the networking services. Passing this exam along with the other two exams confirms that a candidate has the skills and knowledge necessary for implementing, managing, maintaining, and provisioning services and infrastructure in a Windows Server 2012 environment. A few of the topics that will be covered in this course includes: install and configure servers, configure server roles and features, Configure Hyper-V, Deploy and configure core network services, install and administer Active Directory and Create and manage Group Policy. Ace your certification examination with this preparation course! - Learn of the examination outline before sitting for your certification  - Know and understand the topics that may be covered in your examinations - Understand both practical and theory aspects of the examination - Apply the practical skills through the Remote Practice Environment This course is SkillsFuture Credit Eligible

    Read more...


Content

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

+
Content
  • Module 1: Designing A Database Server Infrastructure
    • 1.1 Introduction
    • 1.2 Desiging A Database Server Infrastructure Part 1
    • 1.3 Desiging A Database Server Infrastructure Part 2
    • 1.4 Desiging A Database Server Infrastructure Part 3
    • 1.5 Desiging 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

SGD $299.00
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.