SQL Server Application Development Best Practices

Focused View

Rudi Bruchez

3:32:38

0 View

1-Course Overview

1 -Course Overview.mp4

01:49

2-Do We Still Need to Think in SQL

2 -Introduction to the Course.mp4

03:09

3 -What Is Pachadata, Our Fictional Company.mp4

04:03

4 -Understanding Imperative vs. Declarative Languages.mp4

03:44

5 -The Power of a Declarative Language.mp4

04:30

6 -Improving C# Code with Declarative Additions.mp4

04:40

7 -Understanding Stateful and Stateless Programming.mp4

03:31

8 -Why Is Set Theory Important.mp4

02:54

9 -An Example of Loop Operation with SQL Server.mp4

05:20

10 -Implementing the Bulk Insert Solution.mp4

03:41

11 -Trying the Data Type and XML Solutions.mp4

06:01

12 -Conclusion.mp4

01:49

3-Is a SQL Database Just a Store

13 -Introduction to the Module.mp4

01:56

14 -What Is SQL Server Made Of.mp4

02:30

15 -Where to Put the Business Logic.mp4

03:09

16 -Analyzing Performances on the Database Side.mp4

04:32

17 -Understanding Entity Framework.mp4

02:31

18 -Analyzing Entity Framework Code First from the Database Perspective.mp4

09:38

19 -Should We Use EF Code First from Database.mp4

02:52

20 -Why Should We Still Write SQL Code.mp4

06:37

21 -Why Are Stored Procedures Awesome.mp4

04:37

22 -Conclusion.mp4

01:30

4-Can We Get Good Performances from SQL Server

23 -Introduction to the Module.mp4

01:13

24 -How to Think in SQL.mp4

04:23

25 -Demo of Thinking Declaratively.mp4

06:15

26 -The Cursor Problem.mp4

04:21

27 -Replacing a Cursor.mp4

07:34

28 -The Concatenation Challenge.mp4

09:01

29 -The Recursive Headache.mp4

05:01

30 -The Window Functions Treasure.mp4

07:44

31 -Conclusion.mp4

01:13

5-Are Relational Databases Obsolete

32 -Introduction to the Module.mp4

02:07

33 -What Is NoSQL.mp4

06:06

34 -Understanding the NoSQL Data Model.mp4

06:27

35 -A Look at MongoDB.mp4

08:50

36 -Is the Relational Model Too Rigid.mp4

04:51

37 -Implementing an Abstraction Layer with Views.mp4

03:52

38 -Conclusion.mp4

01:39

6-Can You Get Predictable Performances from SQL Server

39 -Introduction to the Module.mp4

03:10

40 -Why Are Database Performances Not Predictable.mp4

04:13

41 -Troubleshooting Production Server Performances.mp4

03:40

42 -How to See Waits on the Server.mp4

06:14

43 -Generating Test Data with Cross Join.mp4

04:21

44 -Using Red Gate SQL Data Generator.mp4

04:29

45 -Using SQL Query Stress.mp4

03:47

46 -Leveraging RML Utilities.mp4

08:52

47 -Replaying Traces with RML Utilities.mp4

06:17

48 -Course Conclusion.mp4

01:55

Description

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.

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Rudi Bruchez

Instructor's Courses

Rudi Bruchez is a freelance consultant and trainer based in Paris, France. He has more than 15 years of experience with SQL Server and started to venture into NoSQL territories. He worked first as a developer and started as a DBA in 2001, in Switzerland at MSC (Mediterranean Shipping Company). He moved to France in 2005 and is working freelance since 2006. He provides consulting, administration, audits and training. As SQL Server evolves into a more complex solution, he tries to make sure that developers and administrators keep mastering the fundamentals: the relational model and the SQL language, as well as the principles of the SGBDR physical architecture. He wrote in 2008 the only French book about SQL Server optimization, published a book about SQL Security at Packt Pub in 2012 and released recently a french book about the NoSQL movement. And yes, he manages to have some free time sometimes.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.