Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In SQL Server 2008 Essential Training, Simon Allardice explores all the major features of SQL Server 2008 R2, beginning with core concepts: installing, planning, and building a first database. Explore how Transact-SQL is used to retrieve, update, and insert information, and gain insight into how to effectively administer databases. The course also covers features outside SQL Server's database engine, including technologies that have grown up around it: SQL Server Reporting Services and Integration Services. Exercise files are included with the course.
Although SQL Server installs a lot of pieces during that whole long-winded install procedure, sample databases are not one of them, but we can get them. I'm going to open up a browser and go to the address sqlserversamples.codeplex.com. Codeplex.com is a web site where a Microsoft put a whole bunch of extensions and downloadable options you can find for SQL Server and other things. And on this page, you will find product code samples for SQL Server 2008, but the things that I'm looking for are the AdventureWorks 2008R2 sample databases.
If you've been working with Microsoft technologies for a few years, you might be familiar with the classic sample databases that Microsoft have had like Northwind and Pubs. AdventureWorks is the company that they came up with a few years ago and I'm going to go and click the link that says they can be downloaded from here. They're a lot bigger than the old Northwind and Pubs sample databases ever were. And if I agree to this, I'm going to download these AdventureWorks sample databases.
And once it's downloaded, I'm going to go ahead and run this. Of course, we don't have to install these databases, but it will give us something to play around with when we are writing bits of SQL later on. It will unzip a bunch of files and then run just a little installer that will allow you to go ahead and basically import those. It's not quite the right word, but it'll do for the time being, import them into our default installation of SQL Server. You'll notice that there is a few markers here, that there are certain things that say manually deploy via BIDS after install.
These are for the more advanced OLAP databases for analytical processing being use by Analysis Services. I'm not really going to attach these in this course. What I'm really just interested in are the AdventureWorks OLTP and perhaps the data warehouse ones. I'm going to go ahead and install. And after several minutes you should get to the finish screen. I'm just going to hit Finish and we should be done. Of course I want to prove this, so I'm going to close down my browser and go back and open up SQL Server Management Studio, connect to the local machine, and expand Databases and see what we can find, and there we go.
We've got AdventureWorks, AdventureWorks data warehouse, and the light versions of it. And I could even start to expand these and now I'll see inside AdventureWorks. I have tables, which I can expand, which will have data about employees and people and productions and bill of materials. This is all sample information of course. I could select the HumanResources.Employee table. We'll talk much more about what this is in the moment. I'm going to right-click it and save Select Top 1000 Rows and I'll finally see that we have indeed some data that's being stored in our SQL Server database that certainly seems like we could start to manipulate it and play around with it.
So even though we're going to get on to creating our own databases, having the AdventureWorks databases in here in SQL Server will certainly make it useful when it comes to talking about examples of retrieving and updating information. Now you'll notice that this particular SQL Server, what we call the instance of SQL Server and this is the default instance, itself is containing multiple databases. In this case we have AdventureWorks is a database that itself contains dozens of tables.
AdventureWorksDW is another one. AdventureWoksDW2008R2, AdventureWorksLT, ReportServer, ReportServerTempDB, and we have the system databases. And it's an important distinction to make, because it's very common that people talk about SQL Server as if it's a database. They say that very generic term. And of course SQL Server is not a database. SQL Server is your database server that itself can contain dozens of databases. You might only be interested in making one database for yourself, but you could have many.
So there is very much a distinction between the databases you have and the instance of SQL Server that holds those databases. And because these databases are independent of each other, if you wanted to, you could go through and delete them or do what's called detaching them, meaning we just don't care about them anymore. I'm not going to do that right now, because I do want to work with them later but you certainly could do that later on.
Find answers to the most frequently asked questions about SQL Server 2008 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.