Take this
course

Test Prep / Software Exams

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

Utilize important tools to help you map the progress of requirements from the business and technical teams to a physical storage and your data and your future database options

Description

There’s more to databases than using tables to logically represent the data. In this course on designing a physical database implementation, you, as an administrator, will been given important tools to help you map the progress of requirements from the business and technical teams to a physical storage. As an administrator, you know what main and secondary memory you have at your disposal as well as the kind of storage devices and their performance details. We’ll be discussing how to handle both data files and log files as they rapidly grow. Understanding your data and your future database options is key as you plan your physical database designs.
 

Topics Covered Include:
-Course Overview and Planning Files and Filegroups
-Planning a Partitioning Strategy
-Planning Compression

Full details

Curriculum

  • Course Overview
    Course Orientation
    1:54
    Designing a Physical Database Implementation: 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 Physical Database Implementation"" Course."
    Introduction
    1:52
    Course Overview
    1:33
  • Planning Files and Filegroups
    Planning Data Files and Log Files
    4:13
    Storing Data Files and Log Files in Multiple Files
    2:20
    Planning File Groups
    3:35
    File Size and File Growth
    1:53
    SHOW ME Demonstration: Estimation of Fize Size and File Growth
    1:29
    Considerations for RAID and Tempdb
    4:17
    Knowledge Check
    0:33
  • Planning a Partitioning Strategy
    Planning Partitioning
    2:18
    Partition Functions
    1:27
    SHOW ME Demonstration: Partitioning a Table
    3:16
    Performing Operations on Partitioned Data
    1:22
    SHOW ME Demonstration: Implementing Sliding Window Partition
    2:48
    Partitions and Performance
    1:59
    Knowledge Check
    0:34
  • Planning Compression
    Planning Data Compression
    2:52
    Planning a Compression Strategy
    1:23
    Knowledge Check
    0:30
    Conclusion
    1:42

Skills

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

Similar Courses

More Courses by this Instructor