SQL 101: Databases for Beginners

Focused View

Alvin Wan

46:41

21 View

01 introduction.mp4

01:47

02 overview project.mp4

01:06

03 databases 101.mp4

01:34

04 sql hello world.mp4

06:00

05 case study 1 weather app.mp4

06:59

06 case study 2 todo app.mp4

07:00

07 case study 3 airbnb design.mp4

03:12

08 case study 3 airbnb diagram.mp4

03:39

09 case study 3 airbnb code database.mp4

07:31

10 case study 3 airbnb code queries.mp4

06:36

11 next steps.mp4

01:17

Description

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.

What You'll Learn?

Technology
SQL
Database
Databases
Coding
Developer
Tech

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

SQL Server

Oracle SQL

PostgreSQL

Microsoft SQL

SQLite

Alvin Wan

Instructor's Courses

Hi, I'm Alvin

Looking to learn coding? machine learning? Let me help! I was formerly a computer science lecturer at UC Berkeley, where I served on various course staffs for 5 years. I'm now a research scientist in industry, working on cutting edge computer vision. I've designed a few courses to get you started -- not just to teach the basics, but also to get you excited to learn more. Check out the courses on my profile! Or scroll down for a guide to getting started.

Website | Github | YouTube | Twitter | Research

Featured Reviews

"Alvin Wan is a fantastic teacher. The instruction format was just what I was looking for. This is fun due to the format... Due to Alvin's teaching method I'm not only grasping the content I'm having fun learning."

Rick M., Coding 101: Python for Beginners

"I hated programming when studying. I had no real goal in mind + our teachers were purely theoretical about it. In this lesson I got hooked! ...Would recommend this to everyone like myself."

Johannes W., Coding 101: Python for Beginners

Introducing Guest Teacher Derek Wan

I was formerly an instructor for the largest computer science course at the University of California, Berkeley, where I taught undergraduates for several years and won the Distinguished GSI (graduate student instructor) award . I am now a full-time software engineer working on experimentation platforms at a large tech company based in Cupertino, California. However, I'm still passionate about tech education and decided to start making Skillshare courses to get more people excited about coding! I have more courses in the works, but check out what I have so far by scrolling down.

Website | Github | Research

Featured Reviews

"Derek is an amazing [instructor]. He is not only committed to understanding the material, but is also committed to learning how to better teach it. He always makes time to make sure a student has understood his explanation and goes out of his way to connect with his students and make a personal investment in them."

UC Berkeley undergraduate student (Fall 2018 cohort)

"Derek was always extremely well prepared for every discussion and made it a point to add his own tips and lessons on top of the material already provided... He would teach us any additional material that he thought was relevant or helpful along with the normal material to truly improve our skills."

UC Berkeley undergraduate student (Spring 2020 cohort)

Overall rating: 4.45 / 5.00

(943 submitted reviews over 7 semesters)

SkillShare

View courses SkillShare

Skillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.