DownLoad and Install a sample database SQL Server


show more Downloading and installing a sample database provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions show less
please wait ...

Downloading and installing a sample database

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 rea...

Downloading and installing a sample database
Video duration: 1m 9s 1h 52m Advanced

Viewers:

Downloading and installing a sample database provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions

Subjects:
Business Developer IT
Software:
SQL Server
Author:
please wait ...