Eren BaydemirinTeamSQLEmulating UPSERT in PostgreSQLUpsert is an interesting and powerful SQL statement not supported on all database managers. In this article we will cover a technique to…Jan 5, 2018Jan 5, 2018
Eren BaydemirinTeamSQLCustom SnippetsTeamSQL has supported snippets for some time, but we’re introducing custom snippets to help you work more effectively.Oct 28, 2017Oct 28, 2017
Eren BaydemirinTeamSQLTeamSQL Charts: Using the Bar Chart Feature to Create Funnel ChartsIn today’s post, we’ll revisit bar charts, which we covered a couple of days ago. However, we will modify our use of bar charts a bit so…Oct 20, 2017Oct 20, 2017
Eren BaydemirinTeamSQLCreating Bar Charts in TeamSQLWe’ve already covered the basics on how to work with charts in TeamSQL, so today, we’ll go over how to create a specific type of charts in…Oct 14, 2017Oct 14, 2017
Eren BaydemirinTeamSQLHow to Create an Extension: Open a Google MapThis tutorial will show you how to open a Google Map using a given set of coordinates. These coordinates come from the results set you get…Oct 3, 2017Oct 3, 2017
Eren BaydemirinTeamSQLUsing TeamSQL with RedisTeamSQL now supports Redis, a data structure store used as a database, cache, and message broker. Here’s how to connect to your Redis…Aug 17, 20171Aug 17, 20171
Eren BaydemirinTeamSQLUsing TeamSQL Snippets with RedshiftIf you’ve upgraded to the TeamSQL Pro Plan, you have access to the Snippets feature, which we think you’ll love. In this post, we’ll talk…Aug 4, 2017Aug 4, 2017
Eren BaydemirinTeamSQLThe GROUP BY ClauseThe GROUP BY statement is often used with aggregate functions (such as COUNT, MAX, and SUM) so that you can group a set of rows by one or…May 12, 2017May 12, 2017
Eren BaydemirinTeamSQLCast vs. ConvertWhen working with Microsoft’s SQL Server (and by extension, T-SQL), you have two options when making explicit conversions: CAST and…May 5, 2017May 5, 2017
Eren BaydemirinTeamSQLThe Seven Types of SQL JoinsIt’s unlikely that you’ll be working exclusively with data from one table, so you’ll need to be able to grab data from multiple tables. One…Apr 26, 20171Apr 26, 20171