- [Instructor] SQL Server 2017 introduced graph database…capabilities mainly to model many-to-many relationships or…friend-of-a-friend relationships or linking things.…So when we talk about our graph database within SQL Server,…it's a collection of nodes…or vertices, as we call them, and edges.…Nodes and edges are the terms we use in the T-sql syntax…but vertices in relationships to the actual…kind of graph terms that are used.…A node represents an entity.…A good example of this would be a person or a business…or any other sort of organization.…
And an edge represents a relationship between the two nodes…that it connects.…So it might be like, Joey works for Microsoft…or Joey likes some other business…or Joey is friends with Danny.…And there's nothing necessarily that you can do…in a graph database that you can't do…in a relational database.…However, having that graph database makes it easier…to express certain types of queries.…Also, with specific optimizations,…especially when we start talking about…things like hierarchies, certain queries may perform better.…
- Querying with SQL Graph
- String functions in SQL 2017
- Adaptive query processing
- Docker containers and SQL
- Deploying CLR code with SQL Server on Linux
- Working with SQL Operations Studio
- Using snippets
- Code deployment using GIT
Skill Level Intermediate
1. New Features Overview
2. Adaptive Query Processing
3. SQL Server on Linux
4. SQL Server Operations Studio
Using snippets3m 57s
Next steps1m 39s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.