Performing Data Definition and Manipulation in SQL
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
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 Manipulation
- Database Management Systems
- Postgresql
- Data Definition Language
- Relational Database Management System (RDBMS)
分步進行學習
在與您的工作區一起在分屏中播放的視頻中，您的授課教師將指導您完成每個步驟：
Create a database to store database objects (tables)
Data definition (Creating tables in the database)
Data manipulation (Inserting data into the tables created)
Upload a CSV file into the database
Alter, rename and update records in a table
Drop, truncate and delete records from a table
指導項目工作原理
您的工作空間就是瀏覽器中的雲桌面，無需下載
在分屏視頻中，您的授課教師會為您提供分步指導
審閱
來自PERFORMING DATA DEFINITION AND MANIPULATION IN SQL的熱門評論
it was good session for DML process and understand functionality of alter, drop and delete syntax. also good example to understand to copy data from other table.
i have a issue with third party rhyme,my work was loss at the middle however i learnt via instructor .
Thank you Coursera for bringing an affordable and easy to understand interactive course.
A very good hands on course for learning DDL and DML in PostgreSQL.
常見問題
常見問題
如果我購買指導項目，會得到什麼？
指導項目可在台式設備和移動設備上學習嗎？
指導項目的授課教師是誰？
我能在完成指導項目後從中下載作品嗎？
我能夠退款嗎？退款政策是如何規定的？
有助學金嗎？
我能旁聽指導項目並免費觀看視頻部分嗎？
我需要具備多少經驗才能做這個指導項目？
我能直接通過 Web 瀏覽器來完成此指導項目，而不必安裝特殊軟件嗎？
指導項目的學習體驗如何？
還有其他問題嗎？請訪問 學生幫助中心。
Coursera Footer
