->
Lynda - Developing Microsoft SQL Server 2016 Databases - 534417
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

  • Introduction
  • 1. Data Table Fundamentals
  • 2. Implement Advanced Table Features
  • 3. Work with Database Views
  • 4. Ensure Data Integrity through Constraints
  • 5. Create Secure User Accounts
  • 6. Implement Data Types
  • 7. Create Stored Procedures
  • 8. Create In-Memory Tables
  • 9. Introduction to Indexing
  • 10. Index Optimization
  • 11. Work with Sparse Columns
  • 12. Optimize Query Performance
  • 13. Design and Implement User-Defined Functions (UDFs)
  • 14. Monitor Database Performance
  • Conclusion
  • Lynda - Developing Microsoft SQL Server 2016 Databases


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss