10 SQL Articles Everyone Must Read zite.to/19fbHvA
Tag Archives: sql
SQL is what’s next for Hadoop: Here’s who’s doing it
SQL is what’s next for Hadoop: Here’s who’s doing it zite.to/13XoSyB
Data Science for SQL Folks: Leveraging SQL and R
Data Science for SQL Folks: Leveraging SQL and R – article from SQLServerCentral
How To Calculate Cohort Retention in SQL
Your business is always acquiring some new customers and losing others. In order to improve your business you’ll need to understand what is working and not working and how it is impacting those customers. Cohorts are a great way to keep track of the performance of your customers. By tracking groups who registered or purchased in a particular period of time and then seeing how their doing at a later point, you can see how many are no longer active. You can also see what their activity is at different points in time. Maybe you have customers that buy only once a year, but do so in a predictable manner.
For example: In June, you acquire 100 customers, the following month 10 of them shop again, and the following month 10 shop again. You can calculate how many of the 10 repeated and what the total frequency and dollar value of the original hundred customers is. You can compare that to the group of customers you acquired in May or the prior June.
Check out this article from Periscope.io about How To Calculate Cohort Retention in SQL.
You can also check out how to do cohorts in Tableau.
Facebook open sources its SQL-on-Hadoop engine
Facebook open sources its SQL-on-Hadoop engine, and the web rejoices zite.to/17bRNzo
Splice Machine Real-time transactional SQL-on-Hadoop
Splice Machine Real-time transactional SQL-on-Hadoop Limited Release zite.to/Hl0Fad
Does it matter if your SQL is bad?
Does it matter if your SQL is bad? zite.to/10CprGr
Real-time SQL on Hadoop
Real-time SQL on Hadoop zite.to/WVdAnS
PostgreSQL 9.0 now available
Check out the release details at the Postgres site.
Postgres resources
Here’s a great collection of Postgres resources.