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.
If you are a premium member of lynda.com, you can download some exercise files for this course. Now I've got these saved to my Desktop here and if I open this up, you'll see that a few of the chapters in this course have their own folder. I could drill down into that folder, find the number of a movie, and find any file that's associated with it. Now, not all movies have files and in fact most of what I've provided here in the download is simply a copy of what you will end up writing if you just follow along with the course. But in a few movies in this course, you'll see an overlay appear that might point you to a chapter, say Chapter 8, and a movie, say number 05, with a starter file.
That's just designed to save you a little time. If you don't have access to the exercise files at that moment, you will be able to follow along just fine. You just may have to type a couple of lines of code. Now we're also going to be using some sample Microsoft databases, which aren't part of this download. But I'll show you how to get to those and install them just a little later.
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.