- Course
- Core Tech
Database Management and Design Principles
Learn to create, configure, and manage SQL Server databases effectively. This course covers storage design, indexes, and data migration strategies to ensure healthy, performant, and cloud-ready databases.
What you'll learn
Many SQL Server environments suffer from poor database design choices; tiny autogrowth settings, missing indexes, and no migration planning. In this course, Database Management and Design Principles, you’ll gain the skills to build and manage databases with confidence. First, you’ll learn how to create and configure databases—defining file locations, sizing, filegroups, and collation settings for stability and growth. Next, you’ll explore how to manage database objects such as tables, views, indexes, stored procedures, and user-defined functions, while monitoring them with system catalog views and DMVs. Finally, you’ll practice data loading and migration strategies, using the Import/Export Wizard, BCP utility, and Azure migration tools to move and validate databases across environments. When you’re finished with this course, you’ll have the ability to create and manage SQL Server databases that are efficient, maintainable, and ready for hybrid or cloud deployments.
Table of contents
About the author
Tim Warner is a Microsoft Most Valuable Professional (MVP) and Microsoft Certified Trainer (since 1997) with nearly three decades of experience as an IT professional and technical educator.