Claim OwnershipDeveloping Microsoft SQL Server Databases (Audio) - Channel 9
Subscribed: 2Played: 44
Subscribe
Description
Would you like to learn how to implement a database in SQL Server 2014? Or are you studying for Microsoft Certification Exam 70-464: Developing Microsoft SQL Server 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.
6 Episodes
Reverse
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.
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 objects.
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.
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.
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.
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.
Comments
Download from Google Play
Download from App Store
United States