From the course: Hands-On Analytics Engineering Project
Join today to access over 24,600 courses taught by industry experts.
Building our data model
From the course: Hands-On Analytics Engineering Project
Building our data model
- [Instructor] Let's create our first SQL query. In GitHub Codespaces, you'll notice a folder in the left-hand navigation called queries. Go ahead and click the dropdown for that folder. Now, let's create a new .sql file. This will serve as our first data model. This can be done by right-clicking the folder and select New File. Next, let's name our model. We're going to be modeling data on our customer's orders, so let's call it customer_orders_query.sql. It's really important that you include the .sql at the end of your file name, so our explorer knows what type of file to expect. Now, if you click on your new file, you should see a tab up here in the top right of your screen called customer_orders_query. Let's right-click on that file and select Split Down. This will duplicate our file so we can easily see our query results in a new window. While we're at it, let's close the terminal for now to free up some space to work. Now let's write our first SQL query. One of the simplest…
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.