Category Archives for SQL

Top 3 Reasons to Learn SQL

Is It the Death of SQL?

If you hold the belief that SQL is an old, stodgy language, getting ready to be put out to pasture, then you may want to rethink your position on it. SQL is a workhorse that is not only likely to stick around for years to come but also it gives you power and flexibility when […]

Continue reading

Using SQL to Find When Members First Subscribed

Membership

Do you have a subscription service that you track in a relational database? Businesses that capture this membership information often want to know their members’ starting dates and last dates. This can be useful to track duration trends and retention rates.Memberships that provide strong benefits will keep subscribers longer than those offering weaker benefits. Although […]

Continue reading

Goldilocks and the Three SQL Concepts – Window Functions, Case Statements, and CTEs

Soup Food Truck

The Goldilocks Seasonal Soup (GSS) Company is a food truck that serves soups during lunch and dinner. They try to make their soups at just the right temperature, hence the truck’s name. They also try to accommodate the right soups for the right seasons.GSS is a fictitious company. However, the research about the temperature of […]

Continue reading

Should You Learn SQL?

Featured - Should You Learn SQL

Most people think that SQL is an arcane language. If you’re not familiar with SQL, it stands for Structured Query Language. It is the language of databases. Many companies have years of records stored on databases. But with popular languages such as R and Python, it’s easy to believe that SQL is on its way out. […]

Continue reading

How to Bucket Data in SQL

How to Bucket Data in SQL

Are your employees wondering if they are being paid fairly in your organization? Suppose your HR department wants you to create a tool that will help employees determine how their salaries measure compared to other employees. This tutorial shows one method to help accomplish this task.Purchases made from the links in this article may result […]

Continue reading

Why Data Scientists Need to Learn SQL Programming

Learn SQL

SQL is short for Structured Query Language. It was developed in the 1980s to help database programmers work with database content. While databases existed before SQL, working with them required database programmers to use disparate, and often proprietary methods. Most data scientists focus on learning Python or R, as these are the two dominant languages in […]

Continue reading