Master SQL Server Performance: Ultimate 2024 Optimization Guide
Focused View
3:32:38
1 -Course Overview.mp4
01:49
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
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
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
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
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
More details
Course Overview
This comprehensive course teaches proven techniques to maximize SQL Server performance, from diagnosing issues to implementing advanced optimizations, while helping you make informed decisions between SQL and NoSQL solutions.
What You'll Learn
- Diagnose and solve SQL Server performance problems effectively
- Implement declarative programming techniques for optimal queries
- Evaluate when to use SQL vs NoSQL for your applications
Who This Is For
- SQL Server developers seeking performance mastery
- Database administrators optimizing query performance
- Full-stack developers working with Entity Framework
Key Benefits
- Hands-on demos with real-world performance scenarios
- Master advanced techniques like window functions and bulk operations
- Learn to generate and analyze performance test data
Curriculum Highlights
- Declarative vs imperative programming in SQL
- Entity Framework performance analysis
- Advanced troubleshooting with RML Utilities
Focused display
Category
- language english
- Training sessions 48
- duration 3:32:38
- level average
- Release Date 2025/05/10
