From the course: Data Analysis: Investigate with SQL

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Data analysis: First steps

Data analysis: First steps - SQL Tutorial

From the course: Data Analysis: Investigate with SQL

Start my 1-month free trial Buy for my team

Data analysis: First steps

“

- [Instructor] All right, now it's time to begin the investigation. As with any case, we start simple. We want to know, where did the crime take place? We've been told it took place in New York City, so let's look into our data to see who might be connected to that location. Now this is your very first real SQL query. Think of it as the opening move in a larger strategy, the first clue on the board. From here on out, every line of SQL you write will bring us closer to solving the case. So, go ahead and open up the WSDA SQL editor in your browser. You can get to it by navigating to this address. Once you get there, you'll see the same tables we'll be using throughout the course here. Now, once you're in, you'll notice a table called customer details. That's where we'll start. And here's your task. Let's ask the database to show us anyone whose city is listed as New York City. It's a small query, but a powerful one, because in the real world, data analysis often begins with filtering…

Contents