From the course: ETL in Python and SQL
Join today to access over 24,800 courses taught by industry experts.
Querying your data with SQL
From the course: ETL in Python and SQL
Querying your data with SQL
- [Instructor] In the previous chapter, we loaded data into the H+ Sports store data warehouse and discuss data quality checks and why they're necessary. In this video, we'll create the data we have loaded. ETS are great because the power that data we need to make important business institutions. Here we'll query our data to make an important business decision. Where to open a new H+ Sport store branch? To query our data, log onto your ElephantSQL console and navigate to the browser tab. On the left of the screen, we can click on the table queries button to see a list of tables that currently exist in the database. For us we have just customers, so let's click on that and execute. And this shows us the top 100 rows in this data. We can go further to get accounts of all the customers where states is in Texas. So let's do that, we would select counts from customers where states is equal to Texas or TX. In our case, let's run this, awesome. We can see that we have 110 customers whose…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.