Zero to Hero with Microsoft SQL Server 2014 Database (720p)

Zero to Hero with Microsoft SQL Server 2014 Databases

Would you like to learn how to implement a database in SQL Server 2014? Developing Microsoft SQL Server 2014 Databases? This course can help.

Experts take you through tables, indexes, stored procedures, and other database objects. Learn about techniques for designing indexes, managing transactions, and optimizing performance and concurrency. And get troubleshooting tips and best practices.

[00:00:00] Implementing Tables and Views
Find out how to implement disk-based tables based on appropriate data types and constraints and how to implement table objects using variables, temporary tables, and common table expressions. Hear how to implement views as a way of providing a de-normalized abstraction layer over the database schema for client applications.

[00:22:37] Implementing Indexes
Learn the difference between heaps, clustered indexes, and non-clustered indexes. Hear how to design and implement clustered and non-clustered indexes, including considerations for filtered indexes, data types, page density, and index maintenance.

[02:19:16] Implementing Stored Procedures and Functions
Explore implementing and executing stored procedures, including execution context, parameters, and return values. Learn about the different kinds of functions that you can create, along with how to implement them.

[02:53:41] Managing Transactions
Get an introduction to transactions and isolation concepts, and look at how to implement transactions, catch and resolve errors, set isolation levels, and design database objects for concurrency. Learn how to detect and resolve contention and locking issues, including deadlock.

[03:35:37] Implementing In-Memory Objects
Find out how to implement clustered and non-clustered columnstore indexes on disk-based tables. Learn how (and when) to implement in-memory tables and stored procedures, and explore considerations for co-existence with disk-based tables and other database object

[04:26:25] Optimizing and Troubleshooting Queries
Learn how to tune poorly performing queries, and get tips on dealing with common performance issues and tools you can use to analyze and tune workloads.

If you feel useful for you and for everyone, please share it!

Source via: Channel9 – MVA