Companies Home Search Profile

Complex Many-to-many Relationships with Graph in SQL Server

Focused View

Russ Thomas

1:31:03

109 View
  • 01. Course Overview.mp4
    01:44
  • 02. Course Overview.mp4
    03:54
  • 03. Relational Model.mp4
    01:48
  • 04. Tuples Attributes and Relations.mp4
    02:54
  • 05. Sets Projections and Selects.mp4
    02:27
  • 06. Many to Many and Recursions.mp4
    04:13
  • 07. A Eularian Walk.mp4
    03:30
  • 08. Nodes and Edges.mp4
    03:41
  • 09. SQL Server Tables as Nodes and Edges.mp4
    04:48
  • 10. Carved Rock Data Objectives.mp4
    01:48
  • 11. Creating Nodes.mp4
    05:44
  • 12. Creating Edges.mp4
    04:48
  • 13. Insert Sample Node Data.mp4
    02:19
  • 14. Generate Sample Edge Data.mp4
    04:46
  • 15. Basic Graph Query with Match.mp4
    03:47
  • 16. Friends and Friends of Friends.mp4
    05:59
  • 17. A More Complex Eularian Path.mp4
    03:23
  • 18. The Shortest Path.mp4
    07:38
  • 19. Module Summary.mp4
    03:11
  • 20. Need for Administration.mp4
    01:29
  • 21. Undirected Graph Relationships.mp4
    03:41
  • 22. Avoiding Duplicates.mp4
    02:05
  • 23. Data Integrity with Cascade Delete.mp4
    03:54
  • 24. Index Considerations.mp4
    03:38
  • 25. Query Internals and Final Thoughts.mp4
    03:54
  • Description


    This course will teach you not only the fundamentals of graph theory, the terminology, and the problems that can be solved with graph, but will also teach you to immediately put into practice the feature set now available in Microsoft SQL Server.

    What You'll Learn?


      With graph tables and queries you will be empowered to immediately gain insights and feel comfortable revealing the complex relationships buried in the natural world around us. If you have a good understanding of relational databases and are familiar with Microsoft SQL Server, this course will take you from “buzz word familiarity” to “ready to implement real world graph solutions” in about 90 minutes! In this course, Complex Many-to-many Relationships with Graph in SQL Server, you’ll learn to understand and implement real world solutions using graph tables and queries. First, you’ll explore the theories around graph databases, the terminology and unique concepts found in these types of data models, and the real world applications for this approach all around you. Next, you’ll discover how easy it is to build data models that store these complex many-to-many relationships, how SQL Server has automated and architected the connections and framework for you, the limitations of the past and where this technology is going, and how natural language makes modeling and visualizing these relationships far more simple than you might think. Finally, you’ll learn how to query your graph data assets to build powerful link chains, analysis, solutions and quick answers to very complex questions.. When you’re finished with this course, you’ll have the skills and knowledge of graph databases needed to understand graph theory across the industry, where graph fits in the many styles of data modeling and storage, and implement real world solutions with graph using Microsoft SQL Server!

    More details


    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category
    Currently an IT leader in Denver Colorado's financial sector Russ has focused on database engineering, modelling, administration, and BI since 1997 across the Microsoft stack. Russ is a passionate trainer and SQL community volunteer presenting regularly at PASS SQL Saturday events and local user groups around the US. In 2019 much of Russ' focus turned to cloud based data lakes specifically on Google BigQuery.
    Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.
    • language english
    • Training sessions 25
    • duration 1:31:03
    • level preliminary
    • Release Date 2022/12/12