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

每週或US$100 用於 8 課程
每週2次,共 4 週
45 分鐘

即時視訊會議
年齡: 11-16
4-7 每班學員人數

關於
支援
安全隱私加州隱私學習者隱私管理資料首選條款
下載這個軟體
在應用程式商店下載在 Google Play 上取得
© 2024 校外