Join Ron Davis for an in-depth discussion in this video Using the exercise files, part of SQL Server 2014: Installation and Administration.
- As you go through this course you'll see me opening files that may be in a different location than you are seeing right now. However in all instances they have the same name as we're working with in the videos. Now for your convenience I took the files where there are files and loaded them per chapter. Now some chapters have no code but even so I created a folder for it As you see, Chapter 1 Installing SQL Server, has nothing in it.
But others such as Learning SQL Tools has a number of different SQL scripts in it. And here's the names and I followed the naming convention all the way through. So in Chapter 2 these are the scripts you'll need. Now let me just show you something in here. I'm going to open this with Notepad rather than with SQL. And you see this is really long and complex. When you're into this type of a statement I would absolutely go through and use these scripts.
However, particularly I'm talking to here, people that are new at this. So here I have Importing and Exporting Data, and here's a create table. And again if I look at this, see this is really basic stuff, "Use AdventureWorks2014 Go Create Table". I suggest that you look at this but you actually type in the code. If you're new to Transact SQL you want to make errors and then figure out what went wrong.
So each of the chapters has a corresponding code file. Now this one down here Internet Explorer Favorites. As we go through the course I look at a lot of pages on Microsoft MSDN, and less so Tech Net, is what you want to use as an authoritative source in all situations. I saved those pages. You can import those bookmarks into IE and into Chrome.
In IE you just select Import and navigate into it and select this and bring them on in. And then you will have every one of the references that I used within the course. So that's how it works.
- Planning SQL Server installation
- Installing SQL Server 2014
- Using the tools: SQL Server Management Studio, PowerShell, and more
- Managing the databases
- Automating maintenance
- Performing backups and recovery
- Importing and exporting data
- Indexing databases
- Monitoring activity, performance, and events
- Implementing security