무엇이 포함되어 있나요?
8개의 라이브 미팅
수업 6 시간보고계신 지문은 자동 번역 되었습니다
수업 소개
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.
그 외 세부 사항
학부모 가이드
Students will be asked to download a free open source software MYSQL.
https://www.mysql.com/downloads/
Outschool 외 필요 앱/웹사이트
이 수업에서는 아웃스쿨 교실 외에도 다음의 툴을 사용합니다:
출처
https://www.mysql.com/downloads/
교사 전문성 및 자격증
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.
리뷰
실시간 그룹 수업
매주
US$25
또는 8 회 수업에US$1004주 동안 주당 2회
45분
실시간 화상 수업
연령: 11-16
수업당 학습자 4-7 명