May 1, 2024
Updated May 12, 2025
24 minute read
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. At its core, it's a software product designed to store and retrieve data as requested by other software applications. These applications can run on the same computer or across a network. SQL Server uses Transact-SQL (T-SQL), a proprietary extension of the standard SQL (Structured Query Language), for interacting with databases. It's a robust platform used for a wide array of data management tasks, including transaction processing, business intelligence, and analytics applications in corporate environments.
o73wy1|
Find a path to becoming a Microsoft SQL Server. Learn more at:
OpenCourser.com/topic/o73wy1/microsoft
Reading list
We've selected 27 books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Microsoft SQL Server.
Provides a deep dive into the internal workings of SQL Server. It covers topics such as memory management, query processing, and transaction logging. The authors are both Microsoft engineers who have worked on the SQL Server team for many years, and their insights into how SQL Server works will help you troubleshoot and optimize your SQL Server databases.
Cornerstone for anyone starting with Microsoft SQL Server and T-SQL. It provides a solid theoretical foundation in T-SQL querying and is essential for gaining a broad understanding. While foundational, it dives deep enough to be valuable for those looking to solidify their understanding of the language's underpinnings. It is often recommended as a starting point for developers and database professionals.
Is geared towards experienced professionals looking to tackle complex performance issues and troubleshoot SQL Server effectively. It offers advanced techniques and best practices for optimizing system performance. It's a key resource for senior DBAs and developers facing challenging performance scenarios.
An updated take on query performance tuning for SQL Server 2022, this book is essential for anyone working with the latest version. It focuses on troubleshooting and optimizing queries, incorporating new features and techniques. It's a practical guide for developers and DBAs aiming for optimal query execution.
For those seeking a deep understanding of how SQL Server works internally, this book is invaluable. It explores the architecture and internal operations, providing insights into how design decisions impact performance. This more advanced book, suitable for experienced professionals looking to truly master the platform.
Understanding execution plans is fundamental to performance tuning in SQL Server. provides a detailed guide to reading and interpreting execution plans, enabling users to identify performance bottlenecks and optimize queries effectively. It's a must-read for anyone serious about performance.
Provides a comprehensive overview of Transact-SQL (T-SQL), the programming language used to interact with SQL Server databases. It covers topics such as data types, control flow, and error handling. The authors are both experienced SQL Server developers, and their clear and concise writing style makes this book an excellent resource for learning T-SQL.
Provides a practical guide to developing applications with SQL Server. It covers topics such as data modeling, query optimization, and transaction management. The author seasoned SQL Server developer, and his real-world examples will help you build better applications.
This comprehensive guide is excellent for those looking to gain a broad understanding of SQL Server administration, particularly with the latest features in SQL Server 2022 and Azure SQL. It covers planning, implementation, deployment, management, and security. It serves as a valuable reference tool for database administrators and those preparing for administration roles.
Building upon the fundamentals, this book deepens the understanding of T-SQL querying with advanced techniques. It covers complex topics essential for developers and database professionals who need to write efficient and sophisticated queries. It valuable reference for mastering T-SQL beyond the basics.
Is aimed at those seeking to deepen their knowledge in advanced SQL Server administration and optimization techniques. It's a practical guide for experienced DBAs looking to enhance their skills in managing and maintaining SQL Server environments.
Focused on T-SQL querying with a strong emphasis on performance tuning, this book covers a wide range of techniques for writing efficient queries. It's a valuable resource for developers and DBAs looking to improve the speed and efficiency of their T-SQL code.
Focusing on the foundational aspect of database design, this book is crucial for anyone involved in building SQL Server databases. It covers principles of relational design and practical implementation techniques. It provides essential knowledge for developers and database architects.
Window functions are a powerful feature in T-SQL for data analysis. provides a deep dive into using them effectively, offering techniques for handling common querying tasks with greater elegance and power. It's an excellent resource for analysts and developers looking to enhance their data manipulation skills.
Although focused on SQL Server 2017, the performance tuning principles and techniques discussed in this book remain highly relevant for newer versions. It provides a solid understanding of query optimization and good reference for anyone working with SQL Server performance.
Query Store crucial feature for monitoring and improving query performance in modern SQL Server versions. provides a detailed look at how to effectively use Query Store, making it essential for DBAs and developers responsible for performance management.
Delves into the new features introduced in SQL Server 2019, including Big Data Clusters and Machine Learning services. It's a good resource for understanding contemporary topics and the latest advancements in the platform. It is particularly relevant for those exploring newer capabilities.
Is geared towards developers working with SQL Server 2019, covering essential SQL and database design concepts from a developer's perspective. It includes topics like stored procedures and triggers, making it a practical resource for application development against a SQL Server backend.
Ideal for beginners, this book provides a clear introduction to Microsoft SQL Server. It covers fundamental relational database concepts, writing T-SQL statements, executing queries, and basic administration and security. is particularly helpful for those new to databases and SQL Server, providing a strong starting point before moving to more advanced topics.
While not exclusively about SQL Server, this book is highly relevant as it addresses common mistakes and poor practices in database programming using SQL. Understanding these antipatterns is vital for writing efficient and maintainable code in SQL Server. It is valuable for developers of all levels.
Provides a comprehensive overview of data analysis techniques in SQL Server. It covers topics such as data mining, machine learning, and predictive analytics. The authors have extensive experience in data analysis, and their practical examples will help you get started with data analysis in SQL Server.
Provides a practical guide to using SQL Server for data science applications. It covers topics such as data mining, machine learning, and predictive analytics. The authors are both experienced data scientists, and their insights will help you get started with data science in SQL Server.
Provides a comprehensive overview of SQL Server's capabilities for big data. It covers topics such as PolyBase, Spark SQL, and machine learning. The author recognized expert in big data, and his insights will help you understand how to use SQL Server for big data applications.
This cookbook provides practical recipes for creating reports with SQL Server Reporting Services (SSRS). It covers topics such as report design, data visualization, and deployment. The authors are both experienced SSRS developers, and their tips and tricks will help you create better reports.
For more information about how these books relate to this course, visit:
OpenCourser.com/topic/o73wy1/microsoft
Save
