Latests Posts

Selcuk Kiziltug

Hierarchical Queries in Oracle

HIERARCHICAL QUERIES IN ORACLE WITH TEAMSQL Standard SQL doesn’t support hierarchical or recursive queries. However, in the relational data model we usually create tables with an intrinsic recursive nature. Many database engines add proprietary extensions to SQL to support recursive queries. In this article, we will explain how to query these kinds of ...
Selcuk Kiziltug

Oracle Pivoting Queries in TeamSQL

ORACLE PIVOTING QUERIES IN TEAMSQL One interesting feature in Oracle is the PIVOT operator, which is available from Oracle version 11g. This feature is frequently used in data warehouse environments to solve cross queries in few lines of SQL code. In this article, we will explain how to use the PIVOT clause in Oracle to create powerful cross queries ...
Selcuk Kiziltug

The Difference Between SQL and PL/SQL

If you’re familiar with Oracle Databases, you’ll have seen mentions to SQL and PL/SQL, which are both programming languages used to interact with said databases. In this article, we will cover what these two programming languages are, as well as when you should use which. SQL 101 When it comes to databases, SQL is the industry-standard programming ...
Selcuk Kiziltug

Execute as a script in TeamSQL

In TeamSQL, there are two types of executing queries: Execute and Execute as a script.  If you execute long queries using the Execute button, you have to wait until the finish of the query to continue working on other tasks. You might have difficulty if you often use long queries. There is a solution to this problem in TeamSQL: Execute as a script. E...
Selcuk Kiziltug

Subquery Operators

In SQL we can use a subquery in several parts of the query. We can use a subquery in the WHERE clause (which is the natural place for the subquery), in the FROM clause, in the SELECT list, or even in the HAVING clause. Moreover, we can use subqueries in the UPDATE, DELETE and INSERT statements. However, in this article, we will focus on subqueries used in ...
Selcuk Kiziltug

Correlated Subqueries With TeamSQL

Correlated subqueries are a different type of subqueries. In some situations, you must use a correlated subquery to obtain the correct reply or result data set. In this article, we will cover how to identify or detect these situations in which you must use a correlated subquery. We also show some examples of correlated subqueries, and we will even talk ...
Selcuk Kiziltug

TeamSQL Connect & Execute #1: Building Backend Architectures with AWS CloudFormation

https://www.meetup.com/teamsql/events/254266862/ The TeamSQL community is proud to start a new meetup series called TeamSQL Meetup to gather its users and people interested in database management and development. We'll learn and demonstrate new technologies and discuss how to use them with our businesses in every meetup. On the 2nd of October 2018, we ...
Selcuk Kiziltug

Relational Algebra and TeamSQL - Part II

Sometimes is good to dive into the foundations of something, to find new elements to add more power to our current skills. This article is the second part of the previous week Relational Algebra article. In Relational Algebra, there are several data operations, and almost all of them have a simple SQL statement representing the same process. However, there ...
Selcuk Kiziltug

A day in the life of a Test Manager

Selcuk is a Test Manager in the product team here at TeamSQL. When he's not busy browsing Tech Crunch, he's verifying and evaluating the quality of TeamSQL before delivering it to the users. In this interview, Selcuk talks about his role, what makes a good Test Manager, and why he loves working at TeamSQL.   What exactly does a Test & Release ...
Selcuk Kiziltug

Relational Algebra and TeamSQL

In this article about Algebra Relational, we will cover a very rare in SQL operation called division. This operator has not an equivalent implementation in SQL. However, there is a technique to implement division in SQL, and we will explain here.   Relational Algebra: Division, what is it? As any other algebra, relational algebra has operations ...