Group By in TimescaleDB

Introduction In this lesson document, we’ll investigate use of Group By in TimescaleDB. During this lesson, we’ll use the following structure: What does GROUP BY in SQL look like and do in TimescaleDB databases? How do we use GROUP BY in our TimescaleDB SQL scripts? When in TimescaleDB do we use the GROUP BY statement? … Continued

Update Views in TimescaleDB

Introduction In this lesson, we’ll learn how to Update Views in TimescaleDB. At times you may have a query so complex you would like to package it, give it a name, and call it from within other queries as if it were a table or view. Views provide a way to attain that in a … Continued

Strpos in TimescaleDB

Introduction In this lesson, we’ll investigate how to use the Strpos in TimescaleDB to isolate text in multi-word strings, including: What? What does the TimescaleDB STRPOS function do? How? How do we use this function in our TimescaleDB SQL commands? Why? When do we need these functions? We’ve included a “business reality” use case for … Continued

Substring in TimescaleDB

Introduction In this document, we’ll learn to use Substring in TimescaleDB, along with the position and reverse functions for making changes to text with SQL to isolate strings. This lesson includes the following: What do the POSITION and SUBSTRING functions do? How do we use these functions in TimescaleDB database SQL? When do we want … Continued

Procedures in TimescaleDB

Introduction In this lesson, we see to create Procedures in TimescaleDB, including an explanation of input and output parameters. We will include: What? What do TimescaleDB database’s procedures do and what’s the syntax? Why? Why use the procedure construct, otherwise understandn as Store Procedures in some other relational database systems? How? How and why do … Continued

While Loop TimescaleDB

Introduction In this lesson, we will learn to enhance the power of our database queries using the While loop in TimescaleDB. This lesson will include but not be limited to: What? What does “WHILE” do and what’s the syntax? Why and how? Why and how do we use a “WHILE” loop and where/when can we … Continued

Change Case in TimescaleDB

Introduction In this document, we’ll talk about how to change case in TimescaleDB using the UPPER and LOWER functions in SQL to change characters from three points of view, including: What? What do the UPPER and LOWER functions do for us in relation to text? How? How do we use these text manipulation functions in … Continued

Case in TimescaleDB

Introduction In this document, we’ll explain a specific type of branching using Case in TimescaleDB, including: What? What does the “CASE” statement do? Why? In what circumstances will we gain from use of case branching? Where and how? How can we use the “CASE” branch and where/when can we use it in the SQL we … Continued

Between in TimescaleDB

Introduction In this lesson document, we’ll explain the use of an operator called Between in TimescaleDB using SQL, including but not limited to: What? What does the Between operator attain? Why? In what circumstances will we benefit from using the “between” operator? How? How do we use the “BETWEEN” operator in the SQL we write … Continued

Abs in TimescaleDB

Introduction In this document, we’ll investigate the use of abs in TimescaleDB from multiple angles, including: What? What’s abs and what does abs() do? This includes a high level view of the ABS function. Why? Why and when do we use this function? How? How do we make use of abs() in our TimescaleDB database … Continued

Keep in the know!

Subscribe to our emails and we’ll let you know what’s going on at ObjectRocket. We hate spam and make it easy to unsubscribe.