Beyond Classical RDBMS: Non-Tabular Data Structures

Academy Membership

This is for individual Membership: When you are registering for yourself. if you want to register for a group or team, check out the team membership. Worth more than $10K! 48-hours free trial

  • Access to all video courses.
  • 200+ hours of video courses.
  • Instructed by RADACAD Coaches
  • Get certification for completed courses.
  • Member-only discount on upcoming in-person training sessions.
  • Yearly and Monthly plans. You can cancel anytime.

From: $49.00 / month with a 2-day free trial

Academy Membership - for Teams

This is for team Membership: When you have a group of team members registering. if you want to register for one person, check out the individual membership. Worth more than $10K! 48-hours free trial

  • Access to all video courses.
  • 200+ hours of video courses.
  • Instructed by RADACAD Coaches
  • Get certification for completed courses.
  • Member-only discount on upcoming in-person training sessions.
  • Yearly and Monthly plans. You can cancel anytime.

From: $49.00 / month with a 2-day free trial per member

Beyond Classical RDBMS: Non-Tabular Data Structures

Tabular structures are not always the best for storing some kinds of data. Maybe your data has a bit more dynamic structure than you can represent with tables or has a very specific structure, like hierarchy. This course introduces how to deal with such data inside a SQL Server database. You will learn how to store and retrieve semi-structured data in XML or JSON format. You can extend the collection of the data types supported by SQL Server with your own CLR data types, written in C# or VB. This infrastructure was used also by Microsoft through the four spatial data types. Hierarchical data, like XML and JSON, are just a special case of general data structures called graphs. You will learn also how to use graphs in SQL Server.

Length: 2 Hours and 14 Minutes

$259.00
Or log in to access your purchased courses

Tabular structures are not always the best for storing some kinds of data. Maybe your data has a bit more dynamic structure than you can represent with tables or has a very specific structure, like hierarchy. This course introduces how to deal with such data inside a SQL Server database.

You will learn how to store and retrieve semi-structured data in XML or JSON format. You can extend the collection of the data types supported by SQL Server with your own CLR data types, written in C# or VB. This infrastructure was used also by Microsoft through the four spatial data types. Hierarchical data, like XML and JSON, are just a special case of general data structures called graphs. You will learn also how to use graphs in SQL Server.

All these features mentioned are sometimes referred to as “beyond relational”. However, data type and language support in a specific database management product has nothing to do with the relational model, which is a purely logical model. For many years, we used to associate an RDBMS with the SQL language and simple data types; but there are no limitations for both in the relational model. Therefore, I prefer to use the term “beyond classical RDBMS”.

This is the second “beyond relational” course. SQL Server supports also programming in languages other than T-SQL, and using specific T-SQL extensions for temporal data and full-text searches. Please see the “Beyond Classical RDBMS: Enhancing Pure T-SQL” for this support.

Modules