Latests Posts

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 ...
Selcuk Kiziltug

Recursive Queries with TeamSQL

In many relational database models, we have recursive data structures; it’s true that the relational data model is not oriented to support recursive data structures, and is also true that SQL, (as a query language) doesn’t have a healthy way to manage this recursive structures. However, every database engine has a particular clause to maintain the ...
Selcuk Kiziltug

Avoiding Duplication Of Records

The issue of avoiding duplicate records in relational databases is one of the most common issues or problems. The primary mechanism to prevent that are the primary keys, however, in many databases or tables, primary keys are not defined. We are not going to discuss if not having a primary key is unacceptable or acceptable under the specific circumstance. We ...
Selcuk Kiziltug

A Day At Races With TeamSQL 🏎

A DAY AT THE RACES WITH TEAMSQL In this article, we took a public database with real and historical data about formula one races located at http://ergast.com/mrd/db/, we imported into a PostgreSQL database engine, and then we start querying using TeamSQL trying to cover and use a broad spectrum type of business queries and at the same time using differ...