-
What is the right way to organize your data?
Learn the pillars of database usage and design -- from writing basic SQL queries to designing a database.
This class is designed for people with little to no experience: If you don’t know what SQL is, if you’ve never used SQL or if you’ve only fetched data this class is for you. All you need is a computer, internet, and 30 minutes of time.
This is a hands-on experience, meaning (a) we cover just what you need. No fluff, and no extraneous information. (b) You’ll be coding live: Learn how to design, create, query, and finally, optimize a database. We will do this a whopping three times, starting with a minimal proof-of-concept and building up to a fully-fledged example. By the end of this class, you’ll know how to create databases for any of your favorite applications, from a simple Tasks app to a minimal version of AirBnb!
Interested in creative coding? Check out my VR 101 (AFrame Nature Scenes) class.
Interested in more data science or machine learning? Check out my Coding 101 (Python), Data 101 (Analytics), or Computer Vision 101 (Applied ML) classes.
Follow me on Skillshare to be the first to hear about more courses in these areas!
Acknowledgments: B-roll used in introductory video CC-0 licensed by Pexels.
Overview
Syllabus
-
- Introduction
- Project: Designing a Database
- Databases 101
- SQL "Hello World"
- Case. Study 1: Weather App
- Case Study 2: Todo App
- Case Study 3: AirBnb (Design)
- Case Study 3: AirBnb (Diagram)
- Case Study 3: AirBnb (Code Database)
- Case Study 3: AirBnb (Code Queries)
- Next Steps
