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.
-Course Overview and Planning Files and Filegroups
-Planning a Partitioning Strategy