SQL 101: Databases for beginners

——   Created by Kalob Taulien

Share this course:

NEW
Course
15
Lessons
42m
Lesson time
beginner
Skill level
This course is included in Arbington Premium
$15/month gets you access to every course. Start your 14 day trial today.

More about this course

Welcome to SQL 101: Databases for beginners. In this class you will learn how to manage your data by selecting data, updating data, inserting data, and deleting data. 

We'll also dive into what schemas are, how to create a table and how to delete a table. All from scratch! 

There are absolutely no requirements to take this course. And the only thing you need to get started is an internet connection and a browser on your computer. You do not need any special programs of software to take this course.

The course project

Your project is all about hands on experience without needing to install specialized software. 

Your project is to follow these steps:

  1. Create a brand new table
  2. Add 5 rows of information to your table
  3. Select 3 out of 5 rows
  4. Take a screenshot and share it with the class! 

Make sure you share your screenshot in the class project section. 

Happy databasing! 

15 Lessons

0:04:58
What is a schema?
free preview
0:02:00
Using a browser based tool for ease
free preview
0:01:44
Selecting data
0:02:05
Ordering data
0:02:28
Selecting specific data
0:03:08
Selecting a range of data
0:02:29
Ordering selected data
0:03:05
Limiting data
0:03:13
Inserting data
0:03:53
Updating data
0:02:33
Deleting data
0:05:36
Creating a table
0:01:37
Truncating data
0:02:07
Your project
0:01:26
Deleting a table
View more lessons +

100% of 1 people enjoyed this course!

Delia Asan liked this class

Enroll in this course for $19.97
or $15/mo for unlimited courses

Class benefits

  • Certificate of Completion
  • 14 day free trial
  • 24/7 streaming access
  • Project included
  • Teacher Q&A
  • 42m of on-demand video
  • Have a coupon?

About the instructor

Hi everybody! I'm Kalob Taulien.

Here's the TL;DR (short) version about me:

  • I have been coding since 1999 and teaching people how to code since 2011
  • I have over 500,000 web development students world-wide
  • I'm on the Wagtail CMS core development team (Wagtail is Python's #1 most popular website making …
View full profile

Access unlimited courses for only $15 per month

Start your 14 day free trial. Cancel at any time.

Join Today