Outschool
통화, 시간대 및 언어 설정 열기
로그인

SQL(구조화된 쿼리 언어)을 배우세요

이 4주간 온라인 수업에서 학생들은 관계형 데이터베이스의 기본 구조와 간단하고 복잡한 SQL 문을 읽고 쓰는 방법을 배웁니다.
Geetu sodhi
평균 평점:
5.0
수강 후기 수:
(18)
수업

무엇이 포함되어 있나요?

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 외 필요 앱/웹사이트
이 수업에서는 아웃스쿨 교실 외에도 다음의 툴을 사용합니다:
  • MY SQL
출처
https://www.mysql.com/downloads/
가입일: May, 2022
5.0
18수강 후기
프로필
교사 전문성 및 자격증
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$100
4주 동안 주당 2회
45분

실시간 화상 수업
연령: 11-16
수업당 학습자 4-7 명

아웃스쿨 소개
고객 지원
안전 정책개인 정보CA 개인 정보어린이 개인정보데이터 기본 설정 관리이용 약관
아웃스쿨 홈페이지
앱 다운로드
앱 스토어에서 다운로드Google Play에서 다운로드
© 2024 아웃스쿨