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英語
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.

あなたが開発するスキル

ModelingBusiness IntelligenceDatabase (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.

ガイド付きプロジェクトの仕組み

ワークスペースは、ブラウザに完全にロードされたクラウドデスクトップですので、ダウンロードは不要です

分割画面のビデオで、講師が手順ごとにガイドします

よくある質問

よくある質問

さらに質問がある場合は、受講者向けヘルプセンターにアクセスしてください。