Outschool
Open currency, time zone, and language settings
Log In

Learn SQL (Structured Query Language)

In this 4 week week online class, students will learn the basic structure of relational databases and how to read and write simple and complex SQL statements.
Geetu sodhi
Average rating:
5.0
Number of reviews:
(18)
Class

What's included

8 live meetings
6 in-class hours

Class Experience

Structured Query Language (SQL) is a programming language used to communicate with and manipulate databases.
You can manage databases with ease thanks to SQL, a query-based language that is both strong and straightforward. Students will  be introduced to the DBMS/ database management system. We'll also learn how to download from the internet a free, open-source DBMS, MySQL.

Class 1:Learn about the traditional database structure, the structure and history of the relational database, and what structured query language (SQL) is and how it relates to the relational-database structure.
Class 2: Learn about the basic structure of relational databases and how to read and write simple and complex SQL statements and advanced data manipulation techniques. You'll learn how to manipulate data using the INSERT, UPDATE, and DELETE statements.
Class 3:Learn how to use SQL to filter retrieved data and how to use SQL to sort and retrieve data from tables.
Class 4:Learn how to reformat retrieved data with calculated fields and how to merge columns and create alternate names for columns.
Class 5: Learn how to use single row functions ( math, string and date)
Class 6: Learn how to gather significant statistics from data using aggregate functions and Group by.
Class 7: Learn how to extract data from multiple tables simultaneously using joins and subqueries. 
Class 8: Practice Exercises to Test your knowledge.

By the end of this course, you'll feel confident in your ability to write SQL queries to create tables; retrieve data from single or multiple tables; delete, insert, and update data in a database; and gather significant statistics from data stored in a database.

Other Details

Parental Guidance
Students will be asked to download a free open source software MYSQL. https://www.mysql.com/downloads/
External Resources
In addition to the Outschool classroom, this class uses:
  • MY SQL
Sources
https://www.mysql.com/downloads/
Joined May, 2022
5.0
18reviews
Profile
Teacher expertise and credentials
Hi to everybody!
My name is Geetu Sodhi, and I hold a data analysis certification in addition to my computer science major. I will impart computer science-related knowledge here. I have first-hand knowledge in tutoring various computer science subjects .   
I consider teachers to be perpetual learners who are always expanding and changing. As I am aware that every student learns in a unique way, it is my job as a teacher to accurately analyse each student's interests, skills, and prior knowledge. The next step is for me to design instructional activities that will push each student intellectually and allow them to develop.  Some of the subjects that I would be teaching on outschool are : Advance Excel, Python Programming, Gsuite and SQL.

Reviews

Live Group Class
Share

$25

weekly or $100 for 8 classes
2x per week, 4 weeks
45 min

Live video meetings
Ages: 11-16
4-7 learners per class

About
Support
SafetyPrivacyCA PrivacyLearner PrivacyManage Data PreferencesTerms
Financial Assistance
Get The App
Download on the App StoreGet it on Google Play
© 2024 Outschool