Beyond Classical RDBMS: Non-Tabular Data Structures

$259.00

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

Description

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.

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.

Link to the agenda and sample videos from the course

Length: 2 Hours and 14 Minutes

Instructor

Dejan Sarka


Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on the development of database and business intelligence applications. Besides projects, he spends about half of the time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, SolidQ, and Pluralsight.

Reviews

There are no reviews yet.

Be the first to review “Beyond Classical RDBMS: Non-Tabular Data Structures”

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Product Enquiry

You may also like…