What's included
8 live meetings
6 in-class hoursClass 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:
Sources
https://www.mysql.com/downloads/
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
$25
weekly or $100 for 8 classes2x per week, 4 weeks
45 min
Live video meetings
Ages: 11-16
4-7 learners per class