•
1 1

Practical Graph Structures in SQL Server and Azure SQL by Louis Davidson

Checking stock...
Checking stock...
Proud to be B-Corp

Our business meets the highest standards of verified social and environmental performance, public transparency and legal accountability to balance profit and purpose. In short, we care about people and the planet.

The feel-good place to buy books
  • Free delivery in Australia
  • Supporting authors with AuthorSHARE
  • 100% recyclable packaging
  • Proud to be a B Corp – A Business for good

Practical Graph Structures in SQL Server and Azure SQL by Louis Davidson

Use the graph table features in Azure SQL that were introduced in SQL Server 2017 and further refined in SQL Server 2019. This book shows you how to create data structures to capture complex connections between items in your data. These connections will help you analyze and draw insights from connections in your data that go beyond classic relationships.

The graph examples in the book are useful for analyzing social media relationships, complex product-to-customer relationships, and any other type of data analysis in which indirect connections that otherwise might be missed using conventional techniques can be mined for their insight and business value. 


Tree structures are covered, with emphasis on a structure commonly used by organizations to aggregate data at different levels of an organization. The book provides code examples of SQL Graph objects as well as an alternate tree implementation technique. Included is sample data (and data generators) for you to test for performance and choose the implementation approach that best suits your needs and that of your application.


If your job involves analyzing or storage of data elements that are connected in a networked topology, then this is the book that will help you bring the power of SQL Server to bear on that data and take advantage of your existing knowledge.  


What You Will Learn
  • Understand the graph model and the associated terms used in graph analysis
  • Store highly connected data in SQL Server and Azure SQL alongside existing relational data
  • Make full use of the graph table feature that is refined and enhanced in SQL Server 2019
  • Implement high performance tree structures that will make storing and querying tree data possible
  • Report on data associated with a tree structure to aggregate results at different levels

Who This Book Is For


You might also like

More by Louis Davidson
View all
Louis Davidson has been working with databases for more than 20 years as a corporate database developer and architect. He has been a Microsoft MVP for 15 years. And he has completed a sixth edition of his SQL Server database design book (Apress). Louis has been active speaking about database design and implementation at many conferences over the past 17 years, including SQL PASS, SQL Rally, SQL Saturday events, CA World, Music City Data, and the devLink Technical Conference. Louis has worked for the Christian Broadcasting Network (CBN) as a developer, DBA, and data architect for over 21 years. He has a bachelor's degree in computer science from the University of Tennessee at Chattanooga. For more information, please visit his website at drsql.org.


SKU Unavailable
ISBN 13 9781484294581
ISBN 10 1484294580
Title Practical Graph Structures in SQL Server and Azure SQL
Author Louis Davidson
Condition Unavailable
Binding Type Paperback
Publisher APress
Year published 2023-05-18
Number of pages 238
Cover note Book picture is for illustrative purposes only, actual binding, cover or edition may vary.