- You are here:
- Home »
- SQL
Category Archives for SQL
Top 3 Reasons to Learn 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 readingUsing SQL to Find When Members First Subscribed
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 readingGoldilocks and the Three SQL Concepts – Window Functions, Case Statements, and CTEs
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 readingShould 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 readingHow 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 readingWhy Data Scientists Need to Learn SQL Programming
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