SQL Server Application Development Best Practices

SQL Server Application Development Best Practices

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 3h 29m | 579 MB

Relational databases like SQL Server are powerful and complex systems. This course will teach you everything you need to know to get excellent performances from SQL Servers, including how to diagnose performance problems, and more.

Relational databases like SQL Server are powerful and complex systems, and you need to know how to work with them to get the best out of them. In this course, SQL Server Application Development Best Practices, you will learn what you need to do to get excellent performances from SQL Servers. First, you will learn how SQL Server works and how to think like SQL. Next, you will see how to diagnose performance problems, how to solve those problems the SQL way, and how to choose between SQL and NoSQL. Is NoSQL worth the change? You will have the right arguments to decide. Finally, you will discover how to get predictable performances from SQL Server. When you’re finished with this course, you will have the skills and knowledge needed to improve the way you work with SQL Server.

Table of Contents

01 Course Overview
02 Introduction to the Course
03 What Is Pachadata, Our Fictional Company
04 Understanding Imperative vs. Declarative Languages
05 The Power of a Declarative Language
06 Improving C# Code with Declarative Additions
07 Understanding Stateful and Stateless Programming
08 Why Is Set Theory Important
09 An Example of Loop Operation with SQL Server
10 Implementing the Bulk Insert Solution
11 Trying the Data Type and XML Solutions
12 Conclusion
13 Introduction to the Module
14 What Is SQL Server Made Of
15 Where to Put the Business Logic
16 Analyzing Performances on the Database Side
17 Understanding Entity Framework
18 Analyzing Entity Framework Code First from the Database Perspective
19 Should We Use EF Code First from Database
20 Why Should We Still Write SQL Code
21 Why Are Stored Procedures Awesome
22 Conclusion
23 Introduction to the Module
24 How to Think in SQL
25 Demo of Thinking Declaratively
26 The Cursor Problem
27 Replacing a Cursor
28 The Concatenation Challenge
29 The Recursive Headache
30 The Window Functions Treasure
31 Conclusion
32 Introduction to the Module
33 What Is NoSQL
34 Understanding the NoSQL Data Model
35 A Look at MongoDB
36 Is the Relational Model Too Rigid
37 Implementing an Abstraction Layer with Views
38 Conclusion
39 Introduction to the Module
40 Why Are Database Performances Not Predictable
41 Troubleshooting Production Server Performances
42 How to See Waits on the Server
43 Generating Test Data with Cross Join
44 Using Red Gate SQL Data Generator
45 Using SQL Query Stress
46 Leveraging RML Utilities
47 Replaying Traces with RML Utilities
48 Course Conclusion