-
IntroductionWelcome to the Bootcamp
-
Our approach
-
Why Hackathons?
-
What is Data Engineering & DevelopmentUnderstanding Data Engineering
-
Problem-Solving for Developers - A Beginner's Guide
-
Understanding Business & Client NeedsRunning hypothesis-driven experiments using the MVP
-
The Hackathon Problem Brief
-
Task: Identify the MVP1 Quiz
-
From MVP to “MLP” (Minimum Lovable Product)— Building What Your Customers Care About
-
User and Player Types in Gamified Systems
-
The Octalysis Framework for Gamification & Behavioral Design
-
The Strategy Dashboard for Gamification Design
-
Task: Evaluate client needs & wants1 Quiz
-
10 tips for writing good user stories
-
A Complete Guide to Data-Driven Customer Acquisition
-
Design & DevelopmentDesigning Enterprise Level End to End Systems from Idea to Product1 Quiz
-
Database design
-
Classifying data models
-
Deciding fact and dimension tables
-
Entity Relationship Diagram (ERD) Tutorial - Part 1
-
Entity Relationship Diagram (ERD) Tutorial - Part 2
-
Querying the dimensional model
-
Conceptual, Logical and Physical Data Models
-
Test Your Knowledge on Database Design1 Quiz
-
Task: Create ERDs for Your Client1 Quiz
-
Intro to Programming
https://campus.datacamp.com/courses/database-design/processing-storing-and-organizing-data?ex=11
Let’s try to run a query based on this schema. How about we try to find the number of minutes we ran in July, 2019? We’ll break this up in two steps. First, we’ll get the total number of minutes recorded in the database. Second, we’ll narrow down that query to week_id‘s from July, 2019.
Responses