Simple Retrieval Queries in MySQL Workbench

4.6
63 個評分
提供方
Coursera Project Network
1,501 人已註冊
在此指導項目中,您將:

Describe the components of a relational table.

Retrieve data from a table using an SQL Query.

Modify the appearance of query results with filtering and sorting.

Clock50 minutes
Beginner初級
Cloud無需下載
Video分屏視頻
Comment Dots英語(English)
Laptop僅限桌面

In this beginning-level course you will use MySQL Workbench to write basic SQL queries that retrieve data from tables in a relational database. As a DBMS (database management system), MySQL is used by many organizations for managing a variety of types and sizes of databases. MySQL Workbench acts as an integrated development environment allowing users to work with relational databases using a visual user interface rather than the command line. In hands-on activities in MySQL Workbench, you will write and execute the SQL code that retrieves data to satisfy a request. In addition, you will include the filters, sorting, and calculated columns to produce required output. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

您要培養的技能

Mysql WorkbenchDatabase ApplicationQueriesMySQLSQL

分步進行學習

在與您的工作區一起在分屏中播放的視頻中,您的授課教師將指導您完成每個步驟:

  1. Tables in MySQL Workbench

  2. Queries in MySQL Workbench

  3. The SELECT Statement

  4. The WHERE Clause

  5. The Combination WHERE Clause

  6. The ORDER BY Clause

指導項目工作原理

您的工作空間就是瀏覽器中的雲桌面,無需下載

在分屏視頻中,您的授課教師會為您提供分步指導

審閱

來自SIMPLE RETRIEVAL QUERIES IN MYSQL WORKBENCH的熱門評論

查看所有評論

常見問題

常見問題

還有其他問題嗎?請訪問 學生幫助中心