Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Now that we've installed SQL Server let's go ahead and set up a test database to run some demos on. I've already staged some code for you in your Exercise Files folder. The one says create_database, just copy and paste all of that into Management Studio. You notice near the top it's going to try to create some files in C:\program files\Microsoft SQL Server, et cetera, et cetera. This is the default path for database and log files.
You're welcome to use a different path if you want to. What I have on the screen here just represents the default. So we'll go ahead and run that. Command completed successfully. And that gives us a new database called myDatabase. We do need to add one table to that database and populate it with just a little bit of data. We have script for that also. So again I'll copy and paste that over, and execute, and we see now we have an Authors table and we should have of a few records in that Authors table. It looks good.
I think we're ready to go.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 82327 Viewers
80 Video lessons · 133712 Viewers
52 Video lessons · 67034 Viewers
59 Video lessons · 52853 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.