by Emma Wishart | Mar 26, 2025 | Emma Wishart
I’m writing a quick blog on an SQL query that comes in handy when you have many tables and columns to search through, but aren’t quite sure where everything is in a database. All you need is a keyword and this SQL query, and it could save you hours of...
by Kyle Stanford | Mar 12, 2025 | Kyle Stanford
Last week at The Data School in Sydney, we learned basic and intermediate SQL querying. Like most skills that we have learned about so far, we approached different facets of SQL in a formulaic way: Explanation of [SQL concept here] Demonstration of [SQL concept here]...
by The Data School | Oct 27, 2023 | The Data School
This week I have been practising my SQL skills with the Week 2 Case Pizza Run in 8 Week SQL Challenge. In this blog I would like to introduce you to the function of STRING_SPLIT to split a column into rows (with MS SQL Server).When preparing the data for analysis, we...
by The Data School | Aug 21, 2023 | The Data School
Structured Query Language (SQL) is a widely used database manipulation tool. Knowing how to use it is considered a foundational knowledge for data analysts. It is quite intuitive, but the code logic might still confuse new users. Specifically, SQL logical order (the...
by The Data School | Jul 31, 2023 | The Data School
Introduction When it comes to filtering data in SQL, developers often encounter the HAVING and WHERE statements. Though they might seem similar at first, they serve different purposes and are used in distinct contexts. In this blog, we will explore the differences...
