- [Instructor] If you have access to the Exercise Filesfor this course, then you're going to be ableto follow along with the actionsthat I'm performing here on the screen.Simply download and extract them to a locationon your computer that's convenient to get to.I've gone ahead and placed mine here on the desktop.Inside of the Exercise Files folder is a folderfor each chapter of the course.And inside each chapter folderare the individual SQL files that we'll be running.These are just plain text filesthat you can open up inside of Notepad.Or if you double-click on them,they should open up in SQL Server Management Studio.Inside of these scripts when we're ready to run a command,make sure you highlight the text that you want to runbefore pressing the Execute buttonor pressing the F5 shortcut key.

That'll ensure that we run just the highlighted linesand not the entire file all at once.At the end of each file are usually a couple of linesthat'll reset the server back to the state that it was inwhen we started the exercise.Now, there's one small change that I want to maketo the default interface so that it's easierto follow along with what I'm doing here on the screen.Let's go ahead and add in some line numbers onto our filesby going up to the Tools menu, coming down to Options,and then going into the Text Editor options,and then finally clicking on Transact SQL.Here, I'll place a check mark in the optionto enable line numbers and press the OK button.

And when we come back to our file,you'll notice that we have line numbers nowin the left side of the screen.Now, if you don't have access to the Exercise Files,that's okay.You can copy down the code that you see here on the screen,follow along with your own databases,or simply sit back and watch.