From the course: SQL for AI Projects: From Data Exploration to Impact

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Explore California case study

Explore California case study - SQL Tutorial

From the course: SQL for AI Projects: From Data Exploration to Impact

Start my 1-month free trial Buy for my team

Explore California case study

“

- [Instructor] Before we dive into some SQL code, let's check out the Explore California Case Study, which underpins our entire course. To consolidate our learnings together, I've created a fun little case study, which closely simulates what you might find out in the wild when working on data projects. Explore California is a digital e-commerce business. It provides tourist destination information on various webpages throughout the website. There are online sales transactions, user attributes, and product reviews, and we've also got some fancy experimentation results and generative AI interaction logs, which we'll be diving into. I've also prepared an entity relationship diagram, which, it's a fancy way to say a database data dictionary, but pretty much all of the tables that we'll be exploring are here on the screen now. We'll start our exploration by looking at the locations data. Then we'll move onto the reviews to look…

Contents