(upbeat music)…- [Voiceover] So how did you do?…Were you able to create a database…for your own specific project?…Here's how I would approach one of my problems,…which is my out of control book collection.…My wife and I have bookshelves…scattered throughout the house,…and finding a specific book is always a challenge.…So I want to create a database…that will help me keep track of where my books are located.…In order to do that,…I'm going to go over here to the Database collection.…I'll right-click and choose New Database.…I'm going to give this database a name of "My Books."…I'm going to accept the default naming here…and let's go ahead and take a look at this file path.…

I think it's going to be okay to leave these databases…in the Default data folder.…Let's go back here to the beginning.…I'm going to make this a little bit bigger…about 10 megabytes.…I don't expect it to get too large, but 10 megabytes…is plenty of hard drive space that I can spare.…Let's go head and choose that and say OK.…That will go ahead and create the database.…

Resume Transcript Auto-Scroll

Author

Released

8/13/2015

Understand the core concepts every IT professional should know to start working with databases. This course, the first in a four-part series with database consultant Adam Wilbert, is designed to provide a solid foundation that will serve you throughout your IT career. Learn about the different data storage models and find out how to build your first database with SQL Server—the Express edition, which requires no hardware or special connections for setup. Then discover how to create database objects with the data definition language (DDL) and edit data in your tables with data manipulation language (DML). Adam also covers critical relational database concepts, such as relationships, indexes, and schemes.