Lynda - Developing Microsoft SQL Server 2016 Databases
SQL Server is Microsoft's de facto relational database software. While you can build a simple database relatively easily straight out of the box, most administrators need to know how to take advantage of more advanced features in the latest release, SQL Server 2016, to give their clients everything they've come to expect in an enterprise database. In this course, Adam Wilbert shows experienced SQL Server DBAs how to develop a SQL Server 2016 database. Learn how to create data tables, including temporary tables and tables with variables, and schemas. Find out how to enforce data integrity with constraints and secure your database at the user level. Then discover how to create indexes to optimize performance, work with functions, and make sure your SQL database is as fast and secure as possible.
Table of Contents
Introduction1. Data Table Fundamentals2. Implement Advanced Table Features3. Work with Database Views4. Ensure Data Integrity through Constraints5. Create Secure User Accounts6. Implement Data Types7. Create Stored Procedures8. Create In-Memory Tables9. Introduction to Indexing10. Index Optimization11. Work with Sparse Columns12. Optimize Query Performance13. Design and Implement User-Defined Functions (UDFs)14. Monitor Database PerformanceConclusion