Join Adam Wilbert for an in-depth discussion in this video What you should know, part of Database Foundations: Storage.
- This course is picking up from where we left off at the end of the second course in the Database Fundamentals series which was Creating and Manipulating Data. Right now I've got SQL Server Management Studio open and I've logged into the instance of SQL Server that we set up in the Core Concepts course. If you've been following along you'll have this H+ Active database in your Object Explorer. In order to make sure that everyone is on the same page, I'd like to remove the database files that we're working with here in the previous course, and then we'll recreate some of these objects from scratch as we move through this course. So in the Object Explorer if you have this H+ Active database go ahead and right click on it and then choose Delete from the pop-up menu.
We want to make sure that this check-box is turned on down here that says Close existing connections and then press OK. That will remove the database from our system and now we can go ahead and recreate a new one from scratch. I'll go back up here into the Object Explorer and I'll right click on Databases and choose New Database. I'll go ahead and give it the database name here of H+ Active and I'll leave all of the other defaults options here, and I'll press OK down at the bottom. That will reset our working environment so that we're all at the same point again and now we're ready to start.
Note: This course will also prepare certification candidates for the "Understanding data storage" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals. Find out more at https://www.microsoft.com/learning/en-us/exam-98-364.aspx.
- Reducing redundancy with normalization
- Fixing partial dependencies
- Creating primary keys
- Linking tables with foreign keys
- Creating clustered and nonclustered indexes