Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Skillshare

SQL 101: Databases for Beginners

via Skillshare

Overview

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.

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

Taught by

Alvin Wan

Reviews

Start your review of SQL 101: Databases for Beginners

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.