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.

Навыки, которые вы получите

  • 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.

Как устроены проекты с консультациями

Ваше рабочее пространство — это облачный рабочий стол в браузере. Ничего не нужно загружать.

На разделенном экране видео преподаватель предоставляет пошаговые

Часто задаваемые вопросы

Часто задаваемые вопросы

Остались вопросы? Посетите Центр поддержки учащихся.