Lynda – SQL Server 2014: Developing Databases
Learn how to develop databases with the latest version of SQL Server. Ron Davis shows how to design tables and views, use constraints, and create and implement indexes. He also discusses stored procedures, and using triggers to modify data. Plus, learn about features unique to SQL Server 2014: in-memory tables and in-memory (or natively compiled) stored procedures.
Table of ContentsIntroduction1. Working with SQL Server Development Tools2. Designing Data Tables3. Understanding the Concept of Constraints4. Storage and Indexes5. Designing Views6. Working with Stored Procedures7. Performing Data Modification with Triggers8. In-Memory DatabasesConclusion