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.

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.