SQL Programming / Coding - 1 on 1 (half-hour session)
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.
Trey Rice
Average rating:
5.0
Number of reviews:(5)
What's included
Meets on Demand
schedule meetings as needed30 mins
per sessionTeacher 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:
Teacher expertise and credentials
3 Degrees
Master's Degree in Mathematics from Mississippi College
Bachelor's Degree in Education from University of Mississippi
Bachelor's Degree in Mathematics 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
Live 1-on-1 Lessons
$30
per sessionMeets on demand
30 min
Completed by 1 learner
Live video meetings
Ages: 10-18
