Performing Data Definition and Manipulation in SQL

4.7
72 個評分
提供方
Coursera Project Network
2,193 人已註冊
在此指導項目中,您將:

Learn how to use SQL data definition statements for various data definition tasks such as creating a database, table etc

Learn how to use SQL data manipulation statements for various data manipulation tasks such as updating records in a table, etc

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

In this 2-hour long project-based course, you will learn how to use SQL data definition statements for various data definition tasks and how to use SQL data manipulation statements for data manipulation tasks such as updating records in a table. In addition, you will learn how to upload a CSV file into a database using PostgreSQL.

您要培養的技能

Data ManipulationDatabase Management SystemsPostgresqlData Definition LanguageRelational Database Management System (RDBMS)

分步進行學習

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

  1. Create a database to store database objects (tables)

  2. Data definition (Creating tables in the database)

  3. Data manipulation (Inserting data into the tables created)

  4. Upload a CSV file into the database

  5. Alter, rename and update records in a table

  6. Drop, truncate and delete records from a table

指導項目工作原理

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

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

講師

審閱

來自PERFORMING DATA DEFINITION AND MANIPULATION IN SQL的熱門評論

查看所有評論

常見問題

常見問題

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