-
Course
- Data
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.
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.
Table of contents
- Introduction to the Course | 3m 5s
- What Is Pachadata, Our Fictional Company? | 3m 56s
- Understanding Imperative vs. Declarative Languages | 3m 42s
- The Power of a Declarative Language | 4m 28s
- Improving C# Code with Declarative Additions | 4m 40s
- Understanding Stateful and Stateless Programming | 3m 27s
- Why Is Set Theory Important? | 2m 46s
- An Example of Loop Operation with SQL Server | 5m 20s
- Implementing the Bulk Insert Solution | 3m 35s
- Trying the Data Type and XML Solutions | 5m 57s
- Conclusion | 1m 44s
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 Courses by Rudi