Database Creation and Modeling using MYSQL Workbench

提供方
Coursera Project Network
在此指導項目中,您將:

create a new connection with the local server, create and drop a database, create and delete tables.

rename a column of a table, connect tables with each other, insert data to tables and manipulating data.

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

In this 1-hour long project-based course, you will be able to identify and fully comprehend the basics of the MYSQL workbench and create a new connection to the local server. you will also learn how to create a new database and drop it, create new tables, and delete them. Moreover, You will be able to rename columns of a table, connect tables with each other, and add data to tables. And finally, you will learn how to add columns and apply some features professionally on these columns using some keywords such as PRIMARY KEY, FOREIGN KEY, NOT NULL, AUTO_INCREMENT, and DISTINCT and update the tables with new data. SQL is used by all the big names in tech like Netflix or Airbnb. If you target Google, Facebook, or Amazon, they, of course, have their database systems. But SQL will be there too to query and analyze the data. This guided project is for beginners in the field of data management data modeling and databases. It provides you with the basics of creating the whole database. It equips you with knowledge of the first steps in modeling. 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.

您要培養的技能

  • Modeling
  • Business Intelligence
  • Database (DBMS)
  • MySQL

分步進行學習

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

  1. By the end of task 1, you will be able to create a new connection with the local server, create and drop a database.

  2. By the end of task 2, you will be able to create and delete tables, and columns with some features.

  3. By the end of task 3, you will be able to rename a column of a table, connect tables with each other, and add data to tables.

  4. By the end of task 4, you will be able to change all column names, reorder the data, and update them.

指導項目工作原理

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

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

常見問題

常見問題

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