
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 ...
Continue reading this post

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?
Continue reading this post

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 ...
Continue reading this post

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 ...
Continue reading this post

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 ...
Continue reading this post

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 ...
Continue reading this post

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 ...
Continue reading this post

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 ...
Continue reading this post

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 ...
Continue reading this post

Doug Breaker, February 10, 2019
In today's technology-driven world, developers are preparing for some incredible careers. And, thanks to the competitive marketplace, companies are offering some awesome perks . If you are searching for your dream position, check out these 10 SQL software developer jobs. Plus, see the added benefits you'll enjoy at these groundbreaking ...
Continue reading this post