David T, September 5, 2019

Introduction Enterprise data management and analysis is growing more complex and difficult by the minute, as businesses struggle to make the most effective use of the vast arrays of information at their fingertips. According to a 2017 survey, 95 percent of Fortune 1000 companies have embarked on a big data ...

Jeremy Hillpot, August 23, 2019

*Much lonely... Nobody likes to feel lonely. Not even your SQL table data. Fortunately, a SQL GROUP BY clause can bring it all together—so your data never feels alone. GROUP BY clauses are a powerful way to organize your SQL data into useful statistics and business insights. This fun tutorial ...

David T, August 9, 2019

If you’ve been learning about data warehouses for your business, you might have run across the term “star schema.” What is a star schema exactly, and do you need a star schema for your enterprise data warehouse?

Jeremy Hillpot, June 14, 2019

During the last three months, I learned to code in SQL (for free). I went from an absolute newbie to intermediate status using free resources on the internet. In this guide, I'll show you how to do the same, in 30 days or less. Something you should know about learning ...

Erin Forst, June 4, 2019

The right attention at the right time could be the difference between your startup becoming the next Amazon or fading into oblivion. Having a great idea that solves a problem is an important part of the journey, but you also have to make sure people know about it. With the ...

Jeremy Hillpot, May 31, 2019

Sequel Pro claims to be "a fast, easy-to-use Mac database management application for working with MySQL databases." It also boasts a 5-star rating on MacUpdate with glowing user reviews. Sounds excellent, right? When you add the fact that Sequel Pro is free, opensource software , it's an attractive option for ...

Jeremy Hillpot, May 17, 2019

I'm a tech writer. Not a programmer. And until a short time ago, I had never written a single line of code in my life. But then something changed: SQLBot challenged me to review SQLZoo's Structured Query Language course… SQLZoo ...

Doug Breaker, April 12, 2019

Most businesses generate data. Tons of data. Oceans of data! One of the biggest challenges confronting business today is consuming that data. How can you examine and combine the data? How do you make sense of the data? Where to begin? Man, I wish I was surfing There are two ...

Doug Breaker, April 6, 2019

They say that practice makes perfect, and that's especially true when it comes to passing the dreaded technical interview. During a technical interview, you'll need to show that you have an in-depth knowledge of the skills and languages that you claim to have. The point of a technical interview is ...

Doug Breaker, April 6, 2019

Your boss calls it "sequel," but you've been calling it S-Q-L for months. And that’s not the worst. You're suffering from "Super Slow Query Syndrome,” and sometimes, your queries bomb without a result. Don’t worry. The SQLBot team has your back. We just had an overcaffeinated powwow to brainstorm our ...