Earlier, we’ve discussed that your database stores data at its most granular level. This means that every order creates one row in your orders table. Likewise, every click a customer makes creates one row in your clicks table. And every review you receive creates one row in your product reviews table. When this builds up
Month: August 2020
Filtering the data you want: The “WHERE” clause
Why is SQL necessary and useful? In essence, we have huge amounts of data and SQL enables us to extract what we need for specific business insights. So, filtering with the “WHERE” clause is a crucial part of using SQL. This Kaggle notebook contains all the code for following along with the examples. Run cells
Your first SQL joins: reading the “FROM” clause
You’ve got a first query from your company, and you’re ready to start making sense of it. First of all, you’ll want to look at the FROM clause, which tells you where your data is coming from. Then you’ll find that you are looking at your first SQL joins. But most SQL books aren’t going
Using a beginner SQL book efficiently
Perhaps you have started your SQL journey by trying to read a beginner SQL book from start to end. In fact, if you feel that this is slow and frustrating, you’re not alone. Similarly, I worked for 7 years as a business analyst without finishing any beginner SQL books! Instead, you will learn faster by
Learning SQL Mid-Career: Why Survival SQL?
In your industry, you’ve been around the block, and then some. The value that your business acumen, experience, and domain expertise bring is immense. Yet, businesses are digitizing with increasing speed, especially since e-commerce is important for survival in a post-COVID-19 world. Therefore, you’ve probably thought about learning SQL – but as a busy mid-career