SQL 程式設計/編碼 - 1 對 1（半小時課程）
學生將學習結構化查詢語言（也稱為 SQL）的基礎知識。 SQL 是處理資料庫時最廣泛使用的編碼/程式語言之一。它是數據科學和分析的標準工具。
Trey Rice
平均評分：
5.0
評論數量：(5)
包含什麼
按需滿足
根據需要安排會議30 分鐘
每次會話教師支持
我們無法翻譯此文，請刷新頁面並再試一次。
課堂經歷
This class will cover the basics of SQL. SQL is a widely-used programming languages. 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 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, INSERT INTO, NULL VALUES, UPDATE, DELETE, SELECT TOP, MIN, MAX, COUNT, AVG, SUM, LIKE, Wildcards, CREATE TABLE, DROP TABLE, GROUP BY, HAVING, etc.
其他詳情
父母的引導和規範
We'll be downloading Beekeeper studio for this lesson. It's an open source SQL Management tool which lets you query a variety of databases. You can download/install it prior to the lesson, or we can spend the first few minutes downloading and installing it.
https://www.beekeeperstudio.io/
外部資源
除了 Outschool 教室外，本課程也使用：
教師專業知識和證書
3 個學位
碩士 在 數學 從 Mississippi College
學士學位 在 教育 從 University of Mississippi
學士學位 在 數學 從 University of Mississippi
I've been a SQL developer for nearly 15 years. I hold bachelor's and master's degrees in Mathematics and a master's degree in Industrial / Systems Engineering.評論
現場一對一課程
US$30
每次會話按需求安排課程
30 分鐘
有1 位學習者完成此課程
即時視訊會議
年齡: 10-18
