Join Ron Davis for an in-depth discussion in this video What you should know before watching this course, part of Developing Microsoft SQL Server 2014 Databases.
- What you should know before watching this course. In this course, we're going to use two databases to do our queries and you will need to download them and install them, assuming you're going to follow along and do what I'm doing in the course. So, if you'll just search for Adventure Works database or SQL server 2014, this first link here will take you to, actually MSDB product samples. It's on CodePlex and if you're not familiar with CodePlex that's some place you really do want to take a look around.
It's Microsoft's opensource software. That is where they put all of the free stuff and whatever. So, that page there will take you here and if you go to this first hyperlink, Adventure Works 2014 Samples and click on it, that will take you down. Now, the one I use is the first one, Adventure Works 2014 Full Database backup. It is zipped, of course. You have to unzip it. Then, you'll restore it. Then, I use this one. Adventure Works Multi-Dimensonal Model SQL Full Database backup.
So, you'll also download that and do the restore. Then, you'll have an environment that will match what you're going to see in the course. You need to have a basic understanding of how relational databases work. Now, I emphasize the relational part because large database flat files, such as those produced often by Access, are not relational. Relational meaning that you have multiple tables and one relates over to the other.
So, you really kind of need to understand how that works. Your life would also be easier if you understood a process known as normalization. Now, there is help on the way. Lynda.com's online library has a number of courses that will teach you those skills. So, I would suggest you learn them before you look at this. The other thing you really kind of need to know is a basic understanding of Transact-SQL, Microsoft T-SQL, and how that query language works.
Again, there are examples of this available to you in your subscription for the Lynda.com online library. Once you have that, come on over and advance through this course.
- Working with SQL Server development tools
- Designing database tables
- Utilizing schemas with tables
- Using constraints to enforce integrity
- Understanding how SQL stores and locates data
- Designing database views
- Working with stored procedures
- Using triggers to modify data
- Creating in-memory databases