Take this
course

Test Prep / Software Exams

SQL Server 2012 (70-465): Designing a Database Server Infrastructure

Learn how to design an infrastructure and the options you have to plan and implement along with what you have to consider when you plan your database server infrastructure.

Description

When we talk about database servers, we are talking about the vendor or product; then we can talk about versions, tools, features, and integration abilities, etc. In our course, Designing a Database Infrastructure, the student will be learning how to design an infrastructure and the options you have to plan and implement. They will also learn what you have to consider when you plan your database server infrastructure.


Topics Covered Include:
-Planning for Database Server Infrastructure
-Database Server Consolidation
-Planning Server Hardware
-Managing Server Resources

Full details

Curriculum

  • Course Orientation
    Course Orientation
    1:54
    Designing a Database Server Infrastructure: Supplemental Materials
    "Take advantage of all our extra downloadable supplemental materials. This .zip file includes PDF versions of our Script, PPT Slides, Quiz Questions, and vocabulary tools to better enhance your understanding for this ""SQL Server 2012 (70-465): Designing a Database Server Infrastructure"" Course."
  • Planning for Database Server Infrastructure
    Designing Database Server Infrastructure
    1:19
    Planning SQL Server Implementation
    9:40
    Database Server Infrastructures for SQL Server 2014
    5:52
    Planning a Database Server Infrastructure
    5:21
    Knowledge Check
    0:49
  • Database Sever Consolidation
    Considerations for Database Consolidation
    2:42
    Options for Database Consolidation
    3:55
    Planning Database Consolidation
    3:30
    Knowledge Check
    0:46
  • Planning Server Hardware
    Planning Hardware
    6:12
    Planning Storage
    5:09
    Planning Processors
    4:43
    Planning Memory
    3:30
    Planning Connectivity
    1:58
    Knowledge Check
    0:35
  • Managing Server Resources
    Using Resource Governor
    3:12
    SHOW ME Demonstration: Create Resource Pools and Performance Monitor
    6:45
    Managing Resources Across Multiple Instances
    1:24
    SHOW ME Demonstration: Managing Multiple Instances
    4:15
    Managing Resources in Virtualized Environments
    1:18
    SHOW ME Demonstration: Managing Virtual Environments
    4:41
    Knowledge Check
    0:50
    Conclusion
    1:39

Skills

  • Database Management
  • Database Management System (DBMS)
  • SQL Server

Similar Courses

More Courses by this Instructor