Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

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

via Pluralsight

Overview

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.

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!

Syllabus

  • Course Overview 1min
  • Many-to-many Relationships 15mins
  • Introducing Nodes and Edges 12mins
  • Creating and Querying Node and Edge Tables 43mins
  • Administering Graph Databases and Tables 18mins

Taught by

Russ Thomas

Reviews

4.9 rating at Pluralsight based on 12 ratings

Start your review of Complex Many-to-many Relationships with Graph in SQL Server

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.