Got it

The Series of MySQL -2- MySQL Workbench - EP 02_01

Latest reply: May 21, 2022 09:02:45 849 37 22 0 0

The Series of MySQL -2- MySQL Workbench - EP 02_01

 

HI Hi, Greetings!  i_f47.gif 

Happy January i_f25.gif

 

Hi Everyone,

 

Today, I would like to share with you an article about the second episode of Series of MySQL (MySQL Workbench), and the content is given below.


a. MySQL Workbench environment deployment

b. MySQL Workbench Editions

c. MySQL Workbench Administration Tool

d. MySQL Workbench Manager (Create, Alter, Drop Delete)

e. MySQL Workbench Database Export and Import 

 

Basics of MySQL Workbench

For database architects, developers, and administrators, MySQL Workbench is a graphical user interface (GUI) or unified visual database design tool. Oracle is the corporation that built it and keeps it up to date. SQL programming, data ling, data migration, server configuration, user management, backup, and other administrative tools are all included. Create new physical data models, E-R diagrams, and SQL development with this Server Administration tool (run queries, etc.). All major operating systems are supported, including Mac OS, Windows, and Linux. The MySQL Workbench is compatible with MySQL Server version 5.6 and above.

 

wwww


The key features of MySQL Workbench:

The MySQL Workbench has five key features, which are listed below:

 

·        SQL Development:

This feature allows you to use the built-in SQL editor to run SQL queries, as wells as create and manage database connections.

 

·        Data Modelling (Design):

This feature allows you to develop graphic models of the Database Schema, do the reverse and forward engineering between a Schema and a live database, and change any parts of the database with the full table editor. The Table editor supports tables, columns, indexes, views, triggers, partitioning, and other features.

 

·        Server Administration:

        This feature allows you to manage MySQL Server instances by creating users, checking audit data,                 viewing database health, making backups and recoveries, and monitoring MySQL Server performance.

 

·        Data Migration:

        This feature allows you to move tables, objects, and data from Microsoft SQL Server, SQLite, Microsoft        Access, PostgreSQL, Sybase ASE, SQL Anywhere, and other RDBMS to MySQL. It also allows you to          upgrade from older MySQL versions to newer versions.

 

·        MySQL Enterprise Supports:

        This feature enables you to use enterprise products like MySQL firewall, MySQL Enterprise Backup, and          MySQL Audit.

 

Editions of MySQL Workbench

 

There are three editions of MySQL Workbench, which are listed below:

 

    1. Community Edition (Open Source, GPL)                

    2. Standard Edition (Commercial)

    3. Enterprise Edition (Commercial)

 

1.    Community Edition

 

The Community Edition of the most popular database system is an open-source and freely available version. It was released under the GPL license and has a large developer community behind it.

 

2.    Standard Edition

 

It is the commercial edition that allows you to create high-performance, scalable Online Transaction Processing (OLTP) applications. MySQL has become well-known for its industrial-strength, performance, and dependability.

 

3.    Enterprise Edition

 

It's the commercial edition, which comes with a number of sophisticated features, administration tools, and professional support to help you achieve the highest levels of scalability, security, dependability, and uptime. Furthermore, the risk, cost, and complexity of designing, deploying, and administering MySQL applications are reduced with this edition.



Source: 

·        https://www.w3schools.com/mySQl/default.asp

·        https://www.mysqltutorial.org/mysql-basics/


You are welcome to like and leave feedback in the comment area. 


Link: 


EP 02_02:

The Series of MySQL -2- MySQL Workbench - EP 02_02


EP 02_03:

The Series of MySQL -2- MySQL Workbench - EP 02_03



EP 02_04:

The Series of MySQL -2- MySQL Workbench - EP 02_04




M M Zaheer Hussain

Stay Safe!

tt

The post is synchronized to: Author groupzaheernew's Author Collection

  • x
  • convention:

zaheernew
MVE Author Created Jan 14, 2022 00:53:38

  • x
  • convention:

SaraZahid
SaraZahid Created Jan 28, 2022 16:42:33 (0) (0)
 
Unicef
MVE Created Jan 14, 2022 01:50:05

NICE THX, MATE
View more
  • x
  • convention:

zaheernew
zaheernew Created Jan 14, 2022 15:29:20 (0) (0)
 
Rumana
Created Jan 14, 2022 18:42:32

Very Interesting all parts are superb.
View more
  • x
  • convention:

sabahshahzad
sabahshahzad Created Jan 28, 2022 16:43:00 (0) (0)
 
BWGARM
Created Jan 15, 2022 01:33:13

The Series of MySQL -2- MySQL Workbench - EP 02_01-4602637-1
View more
  • x
  • convention:

hanhcao
Created Jan 16, 2022 10:08:24

Good one
View more
  • x
  • convention:

zaheernew
zaheernew Created Jan 16, 2022 16:02:04 (0) (0)
thanks  
faysalji
Author Created Jan 17, 2022 05:36:37

Thanks for sharing
View more
  • x
  • convention:

zaheernew
zaheernew Created Jan 20, 2022 13:34:46 (0) (0)
Awesome  
zaheernew
zaheernew Created Jan 20, 2022 13:34:59 (0) (0)
Awesome  
Anno7
Moderator Author Created Jan 19, 2022 05:10:41

good post
View more
  • x
  • convention:

Saqibaz
Created Jan 19, 2022 05:16:02

Thanks for sharing
View more
  • x
  • convention:

Lucfabrice
MVE Author Created Jan 19, 2022 05:42:13

Nice share !!!
View more
  • x
  • convention:

123
Back to list

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.
Information Protection Guide
Thanks for using Huawei Enterprise Support Community! We will help you learn how we collect, use, store and share your personal information and the rights you have in accordance with Privacy Policy and User Agreement.