Beyond Classical RDBMS: Enhancing Pure T-SQL

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: Enhancing Pure T-SQL

In this course, you will learn how to manipulate the data stored in your SQL Server and Azure SQL Database with advanced T-SQL language elements and with other languages. You will learn about Full-Text Search (FTS), integrating CLR functions written in Visual C# or Visual Basic in your T-SQL code, and work with system-versioned tables within SQL Server.

Length: 2 Hours and 25 Minutes

$259.00
Or log in to access your purchased courses

Many times, you wish you could have some more powerful tools than the Transact-SQL (T-SQL) language for working with data. You might need to enable your users to use word search in your string columns or in Office documents to give them similar experiences like they get when they search the web. You might need to implement constraints and do the data analysis with functions that are simply not implemented in T-SQL. Or you might need to maintain multiple versions of data over time and be able to query the state of the data from the past.

In this course, you will learn how to manipulate the data stored in your SQL Server and Azure SQL Database with advanced T-SQL language elements and with other languages. You will learn about Full-Text Search (FTS), integrating CLR functions written in Visual C# or Visual Basic in your T-SQL code, and work with system-versioned tables within 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 first “beyond relational” course. SQL Server supports also data structures that are not pure tables in a classical relational way. Please see the “Beyond Classical RDBMS: Non-Tabular Data Structures” for this support.

Modules