From the course: Developing Microsoft SQL Server 2016 Databases
Welcome - SQL Server Tutorial
From the course: Developing Microsoft SQL Server 2016 Databases
Welcome
- [Adam] Hello and welcome to Developing Microsoft SQL Server 2016 Databases. My name is Adam Wilbert and in this course I'll introduce you to some of the more advanced capabilities that you need to be aware of when creating databases in SQL Server. I'll start with a discussion on data tables, including how to create temporary tables and table variables. I'll talk about creating a schema for the database and enforcing the integrity of the data that's being stored. Then I'll discuss the importance of creating indexes and show you how to monitor their performance to ensure that they're a benefit to the database and not a hindrance. Along the way I'll look at reading an execution plan, working with functions and creating a more secure environment for your data. There is a lot to cover, so let's jump right in to Developing Microsoft SQL Server 2016 Databases.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.