Fundamentals of Data Analysis Selecting all records from the table

7. Selecting all records from the table

A week ago Linh, Gessica, and Sandra launched the project they’ve been working on for a couple of months. They called it Bindle – a subscription service for reading books. It’s hard to say where the inspiration for the name came from, we only know that they met when they worked at Boogle.

They hired an agency to build a website and they couldn’t believe that about a week ago they opened a bottle of champagne to celebrate the launch of Bindle 🍾. The Internet accepted their project very well – people were talking about it in social networks, they even managed to get some press coverage.

Everything seemed perfect except one thing – this morning they received an email from the agency’s data analyst. He said that he fell in love and left for Casablanca. Three friends were sitting at Gessica’s kitchen aka “Bindle HQ” making coffee and thinking about the situation. How can they figure out how many signups they had during the last week? Has anyone purchased a subscription? Did users read the books?

They sent an email to the agency asking how can they access the data. They were quite surprised by the answer:

All data of Bindle is stored in a SQL database, feel free to run your queries. FYI SQL – is a language of data. You ask a question, convert them to SQL queries, and get your answers. Honest advice: learn SQL yourself, it’s so powerful, it’ll help you a lot take decisions, plan new features, analyze the impact of your work, really be data-informed (or driven, you decide). Why don’t you start by looking at the users table?

FROM users

“Wow, that sounds amazing, I think we all should learn SQL!” – said Linh in excitement, “How about we start right now?”

I hope in your company data analysts do fall in love, but they don’t leave you on short notice. Go to the Playground and run the query above ☝

Anatoli Makarevich, author of SQL Habit About SQL Habit

Hi, it’s Anatoli, the author of SQL Habit. 👋

SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst 📊 and solve real-life challenges from Business, Marketing, and Product Management.

SQL Habit course is made of bite-sized lessons (you’re looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work. 🚀

“well worth the money”

Fluent in SQL in a month

Master Data Analysis with SQL with real life examples from Product Management, Marketing, Finance and more.
-- Type your query here, for example this one -- lists all records from users table: SELECT * FROM users
Loading chart... ⏳