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.
Course info
Rating
(27)
Level
Intermediate
Updated
May 18, 2018
Duration
3h 29m
Table of contents
Course Overview
Do We Still Need to Think in SQL?
Is a SQL Database Just a Store?
Can We Get Good Performances from SQL Server?
Are Relational Databases Obsolete?
Can You Get Predictable Performances from SQL Server?
Description
Course info
Rating
(27)
Level
Intermediate
Updated
May 18, 2018
Duration
3h 29m
Description

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.

About the author
About the author

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. As SGBD evolve into more complex solutions, he tries to make sure that people understand the fundamentals and implement their databases wisely.

More from the author
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone! My name is Rudi Bruchez, and welcome to my course, SQL Server Application Development Best Practices. I am a SQL Server consultant and trainer from Paris, France. But you get that from my accent, right? In 20 years, I have seen a lot of shops working with SQL Server. It gave me the material for this course. If you have questions about SQL or NoSQL databases, if you are using Entity Framework, and you get performance problems, or you want to work best with SQL Server, this course is for you. This course is about getting accustomed to what SQL Server and the relational SQL database is really--a great a great piece of software. So we will see why SQL is a smart language that took the right approach to what's manipulating data. We will talk about sharing responsibilities between Entity Framework and SQL Server, how to diagnose and solve performance problems, how to choose between SQL and NoSQL, and, finally, how to access performances before going to production. By the end of this course, you will be able to use these real-world best practices and build on them to get better performances and more flexibility with SQL Server. Before beginning the course, you should be familiar with SQL Server, the SQL language, and. NET development. Nothing too advanced. I'm just assuming you have some experience programming SQL Server with. NET, and you have questions that this course is designed to help you answer. I hope you will join me on this journey to learn SQL application development best practices at Pluralsight.