SQL Server Application Development Best Practices

سرفصل های دوره

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.

1-Course Overview

1 -Course Overview

2-Do We Still Need to Think in SQL

2 -Introduction to the Course

3 -What Is Pachadata, Our Fictional Company

4 -Understanding Imperative vs. Declarative Languages

5 -The Power of a Declarative Language

6 -Improving C# Code with Declarative Additions

7 -Understanding Stateful and Stateless Programming

8 -Why Is Set Theory Important

9 -An Example of Loop Operation with SQL Server

10 -Implementing the Bulk Insert Solution

11 -Trying the Data Type and XML Solutions

12 -Conclusion

3-Is a SQL Database Just a Store

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

4-Can We Get Good Performances from SQL Server

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

5-Are Relational Databases Obsolete

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

6-Can You Get Predictable Performances from SQL Server

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

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight