120
SQL Programming / Coding - 1 on 1
Completed by 1 learner
Ages 10-18
Live 1-on-1 Lessons
Average rating:
5.0
Number of reviews:(5 reviews)
Live video meetings
Meets on demand
50 min
What’s included
Meets on Demand
schedule meetings as needed50 mins
per sessionTeacher support
Class Experience
Beginner Level
This class will cover the basics of SQL. SQL is a widely-used programming languages. Large websites like Facebook, X (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 very 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 Database Browser 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://sqlitebrowser.org/
I use the Windows portable version, but any version will be fine.
Language of Instruction
English
External Resources
In addition to the Outschool classroom, this class uses:
Meet the teacher
Teacher expertise and credentials
3 Degrees
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 have been a SQL developer for 15 years and an adjunct professor at local colleges for roughly the same time. I also taught middle school mathematics for 3 years. I teach coworkers SQL on a daily basis in my current job.Reviews
Other classes by Trey Rice
Other classes by Trey Rice
Parents also liked
Data Science & Analytics With Python: Finance, Health, Space & Python Coding
David Sofield
4.9
(839)
$35 per class
Next session at 5:30 PM on Sun 8/24
Group Class
8 wks, 1/wk, 1 hr
12-17
Data Science & Analytics With Python Coding: Finance, Health & Space Summer Camp
David Sofield
4.9
(839)
$35 per class
Next session at 6:45 PM on Mon 6/16
Group Class
2 wks, 4/wk, 1 hr
12-17
SQL Programming / Coding - 1 on 1
Trey Rice
5.0
(5)
$60 per session
1-on-1 Lessons
On Demand
10-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
Introduction to SQL
Brandon
4.9
(37)
$10 per class
Next session at 2 PM on Tuesday
Group Class
1 wk, 1/wk, 55 min
13-18
Learn SQL (Structured Query Language)
Geetu sodhi
5.0
(18)
$13 per class
Next session at 11 PM tomorrow
Group Class
4 wks, 2/wk, 45 min
11-16
Building a Database
Brandon
4.9
(37)
$25 per class
Next session at 4:30 PM tomorrow
Group Class
1 wk, 1/wk, 55 min
13-18
Math Fractions and Data
Excellence in Interdisciplinary Studies
5.0
(32)
$22 per class
Next session at 5 PM on Tue 6/17
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,804)
$19 per class
Next session at 3 PM on Mon 6/16
Group Class
2 wks, 5/wk, 1 hr
13-17
Summer Camp: Project Based Python (Level 1)
AI Code Academy
4.7
(1,804)
$17 per class
Next session at 1 PM on Mon 6/16
Group Class
2 wks, 5/wk, 1 hr
9-14
Candy Math: Data Collection and Graphing With Skittles
Danielle
4.9
(332)
$16 per class
Next session at 4:30 PM on Tuesday
Group Class
1 wk, 1/wk, 25 min
5-8
Project Based Python Coding for Kids (Level 3)
AI Code Academy
4.7
(1,804)
$23 per class
Next session at 3 PM on Sat 6/14
Group Class
10 wks, 1/wk, 1 hr
11-16
Advanced Python Coding: Data Structures, OOP & Coding Challenges
PopSkool: English, Music, Art, Math, Coding & More
5.0
(100)
$15 per class
Next session at 6 PM tomorrow
Group Class
8 wks, 1/wk, 55 min
9-14
The Data Set Book Club Ages 6-9 With Teacher Dianne
Teacher Dianne M.Ed. - Reading Specialist
5.0
(561)
$13 per class
Next session at 2:30 PM on Thu 6/12
Group Class
1/wk, 25 min
6-9
1-on-1 Grade1-4 Minecraft Math Learn Geometry, Data graphing and Multiplication
Create N Learn: Game-Based Learning & Future Skill
4.9
(98)
$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,804)
$23 per class
Next session at 3 PM on Mon 6/16
Group Class
2 wks, 5/wk, 1.25 hr
13-18
More to explore
Whats for Dinner 30 Cooking Confidence With Kristy
Geography States
Genshin Impact Drawing
Labor
Marching To War
Singapore 2b
Hidden Figures
Math Without
Nature Journal
Oh Snap Dslr Photography Fundamentals I 14-18
Exponent Lab
Violin Beginner
Credit
Cat Care
Drawing Painting
Worry Monster
Whittier Strong
The Secret Zoo
Ready To Read Cvc Words & Beyond Phonics Blends Read Write And Do Math
Swan Lake
