Outschool
開啟貨幣、時區和語言設置
登入

結構化查詢語言 (SQL) 程式設計入門

學生將學習結構化查詢語言(也稱為 SQL)的基礎知識。 SQL 是處理資料庫時最廣泛使用的編碼/程式語言之一。它是 STEM、數據科學和分析的標準工具。
Trey Rice
平均評分:
5.0
評論數量:
(5)
班級

包含什麼

1 現場會議
1 上課時間
我們無法翻譯此文,請刷新頁面並再試一次。

課堂經歷

This class will cover the basics of SQL. SQL is a widely-used programming language. Large websites like Facebook, Twitter, Instagram, etc. all use SQL to store data.

We'll first make sure everyone can download the SQL client we' re using. Then students will follow along as they learn how to query data. The course is very open and questions are encouraged.

First we'll cover some basic commands: build tables, insert data into those tables and how to query data from the tables. We'll cover some of the most common commands first and possibly dive into more complex queries if time permits. We'll use a test database, so users will be able to (and in fact encouraged to) delete the entire database and rebuild it from scratch if they want to.

I'll demonstrate each query one at a time, then allow students to replicate the query. And of course, answering any questions along the way.

After this course, students should have a good feel for how to create a database, edit it and build simple queries in a SQL database.
學習目標
Basic SQL commands; SELECT, FROM, WHERE, DISTINCT, AND, OR, NOT, ORDER BY, MIN, MAX, COUNT, AVG, SUM, LIKE, Wildcards, GROUP BY, HAVING, etc.
學習目標

其他詳情

父母的引導和規範
We'll spend the first few minutes of class downloading the appropriate software. I recommend BeeKeeper Studio because it's free and open-source. Also it has a portable version for Windows. So it doesn't require any installation. It's just a matter of downloading a file and running it. If you want to go ahead and download it, you can find the software at https://www.beekeeperstudio.io
供應清單
While it's not required, multiple monitors will be helpful.
外部資源
除了 Outschool 教室外,本課程也使用:
已加入 January, 2022
5.0
5評論
教師檔案
教師專業知識和證書
碩士 在 數學 從 Mississippi College
學士學位 在 教育 從 University of Mississippi
學士學位 在 數學 從 University of Mississippi
I'm a data / analytics professional working in healthcare finance. I have bachelor's degrees in mathematics and mathematics education from Ole Miss, along with a master's degree in mathematics from Mississippi College and a master's degree in industrial/systems engineering from Mississippi State University. I have extensive experience with Structured Query Language (SQL) and love teaching database concepts. I also teach mathematics and programming. I've taught all ages from middle school up through graduate engineering students. I work part-time as an adjunct instructor for various colleges/universities in the area and online. I love seeing people learn new concepts, especially as it relates to data and analytics.

評論

一次性直播課程
分享

US$24

每班
單堂課
60 分鐘

有5 位學習者完成此課程
即時視訊會議
年齡: 10-15
4-18 每班學員人數

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