$30

per session
Class

SQL Programming / Coding - 1 on 1 (half-hour session)

Completed by 1 learner
Ages 10-18
Live 1-on-1 Lessons
Students will learn the basics of Structured Query Language (otherwise known as SQL). SQL is one of the most widely-used coding / programming languages when working with databases. It's a standard tool for data science and analysis.
Average rating:
5.0
Number of reviews:
(5 reviews)

Live video meetings
Meets on demand
30 min

What's included

Meets on Demand
schedule meetings as needed
30 mins
per session
Teacher support

Class Experience

This class will cover the basics of SQL. SQL is a widely-used programming languages. Large websites like Facebook, Twitter, Instagram, etc. all use SQL to store data.

We'll first make sure everyone can download the SQL client we' re using. Then students will follow along as they learn how to query data. The course is open and questions are encouraged.

First we'll cover some basic commands: build tables, insert data into those tables and how to query data from the tables. We'll cover some of the most common commands first and possibly dive into more complex queries if time permits. We'll use a test database, so users will be able to (and in fact encouraged to) delete the entire database and rebuild it from scratch if they want to.

I'll demonstrate each query one at a time, then allow students to replicate the query. And of course, answering any questions along the way.

After this course, students should have a good feel for how to create a database, edit it and build simple queries in a SQL database.

Learning Goals

Basic SQL commands; SELECT, FROM, WHERE, DISTINCT, AND, OR, NOT, ORDER BY, INSERT INTO, NULL VALUES, UPDATE, DELETE, SELECT TOP, MIN, MAX, COUNT, AVG, SUM, LIKE, Wildcards, CREATE TABLE, DROP TABLE, GROUP BY, HAVING, etc.

Other Details

Parental Guidance
We'll be downloading Beekeeper studio for this lesson. It's an open source SQL Management tool which lets you query a variety of databases. You can download/install it prior to the lesson, or we can spend the first few minutes downloading and installing it. https://www.beekeeperstudio.io/
External Resources
In addition to the Outschool classroom, this class uses:

Meet the teacher

Joined January, 2022
5.0
5reviews
Profile
Teacher expertise and credentials
Master's Degree in Mathematics from Mississippi College
Bachelor's Degree in Mathematics from University of Mississippi
Bachelor's Degree in Education from University of Mississippi
I've been a SQL developer for nearly 15 years. I hold bachelor's and master's degrees in Mathematics and a master's degree in Industrial / Systems Engineering.

Reviews



Parents also liked
Data Science & Analytics With Python: Finance, Health, Space & Python Coding
David Sofield
4.9
(833)
$35 per class
Group Class
8 wks, 1/wk, 1 hr
12-17
Data Science & Analytics Summer Camp: Finance, Health & Space With Python Coding
David Sofield
4.9
(833)
$35 per class
Next session at 6:45 PM on Mon 6/16
Group Class
2 wks, 4/wk, 1 hr
12-17
Computer Science: Python, R, AI, Data Science 1-On-1 Tutoring
Kevin Stachelek
$55 per session
1-on-1 Lessons
On Demand
12-18
Computer Science: Python, R, JS, Java, C, AI, Data Sci. & More 1-On-1 Tutoring
Joshua West, MBA/ISM, President & Educator w/OtRE
$140 per session
1-on-1 Lessons
On Demand
12-18
Math Fractions and Data
Excellence in Interdisciplinary Studies
5.0
(32)
$22 per class
Next session at 3 PM on Tuesday
Group Class
2 wks, 3/wk, 50 min
8-11
Summer Camp: Project Based Python for High School (Level 1)
AI Code Academy
4.7
(1,797)
$24 per class
Next session at 3 PM on Mon 6/16
Group Class
2 wks, 5/wk, 1 hr
13-17
Candy Math: Data Collection and Graphing With Skittles
Danielle
4.9
(330)
$16 per class
Next session at 10 PM on Tuesday
Group Class
1 wk, 1/wk, 25 min
5-8
Summer Camp: Project Based Python (Level 1)
AI Code Academy
4.7
(1,797)
$23 per class
Next session at 3 PM on Mon 6/16
Group Class
2 wks, 5/wk, 1.25 hr
9-14
Python for AI Machine Learning and Big Data (Level 4)
AI Code Academy
4.7
(1,797)
$28 per class
Next session at 10:45 PM on Monday
Group Class
10 wks, 1/wk, 1 hr
13-18
Math Skills: Making Decisions With Data, Statistics, and Numbers
Kim David - BA, MPA, MLIS
4.8
(35)
$16 per class
Next session at 5 PM on Mon 6/2
Group Class
1 wk, 1/wk, 50 min
11-14
Homeschoolers Minecraft Math: Learn Decimals, Volume, Graphing Data and Geometry
Create N Learn: Game-Based Learning & Future Skill
4.8
(58)
$18 per class
Group Class
10 wks, 1/wk, 55 min
10-13
1-on-1 Grade1-4 Minecraft Math Learn Geometry, Data graphing and Multiplication
Create N Learn: Game-Based Learning & Future Skill
4.8
(58)
$30 per session
1-on-1 Tutoring
On Demand
6-9
Summer Camp: Machine Learning in Python With Big Data (Level 4)
AI Code Academy
4.7
(1,797)
$28 per class
Next session at 3 PM on Mon 6/16
Group Class
2 wks, 5/wk, 1.25 hr
13-18
Minecraft Survival Mode — Java + Bedrock for Teens! Plugins, Data Packs and More
Mr. Vaughn's Virtual Vault
5.0
(148)
$17 per class
Next session at 9 PM on Thursday
Group Class
1/wk, 45 min
11-16
Prepare for IELTS Writing Task 1 Academic Describing Charts & Data 1-1 Tutoring
Mr Darcy
5.0
(1)
$28 per session
1-on-1 Tutoring
On Demand
13-18
Biology and the Human Body! a Life Science and Medical Science Course
Ms. Kathleen: Veterinary science, animal science
4.9
(539)
$14 per class
Next session at 1 PM on Monday
Group Class
1/wk, 35 min
7-12
See More Classes
Home
Search
Give a Gift Card
Open currency, time zone, and language settings
Language & Region
Log In