MySQL and MySQL Workbench For beginners
- Descrição
- Currículo
- FAQ
- Revisões
MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.
MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort.
MySQL Workbench delivers visual tools for creating, executing, and optimizing SQL queries. The SQL Editor provides color syntax highlighting, auto-complete, reuse of SQL snippets, and execution history of SQL. The Database Connections Panel enables developers to easily manage standard database connections, including MySQL Fabric. The Object Browser provides instant access to database schema and objects.
MySQL Workbench provides a visual console to easily administer MySQL environments and gain better visibility into databases. Developers and DBAs can use the visual tools for configuring servers, administering users, performing backup and recovery, inspecting audit data, and viewing database health.
MySQL is an open-source relational database management system (RDBMS). Its name is a combination of “My”, the name of co-founder Michael Wideness’s .
MySQL is the most popular Open Source Relational SQL Database Management System. MySQL is one of the best RDBMS being used for developing various web-based software applications. MySQL helps users store, organize, and retrieve data.
-
1Overview of MySQL and MySQL WorkbenchTexto
-
2IntroductionVídeo Aula
-
3What is MySQLVídeo Aula
-
4What is SQLVídeo Aula
-
5Basic Database ConceptsVídeo Aula
-
6What is a SchemaVídeo Aula
-
7Data TypesVídeo Aula
-
8Database SchemaVídeo Aula
-
9Download and Install MySQL (Windows)Vídeo Aula
-
10Download and Install MySQL (Mac)Vídeo Aula
-
11What is MySQL WorkbenchVídeo Aula
-
12Installing MySQL Workbench (Mac)Vídeo Aula
-
13User Accessibility OptionsVídeo Aula
-
14Introduction to MySQL Workbench PreferencesVídeo Aula
-
15General Editors PreferencesVídeo Aula
-
16SQL Editor PreferencesVídeo Aula
-
17Administration PreferencesVídeo Aula
-
18Modeling PreferencesVídeo Aula
-
19Fonts and ColorsVídeo Aula
-
20SSH PreferencesVídeo Aula
-
21Other PreferencesVídeo Aula
-
22MySQL Workbench Home ScreenVídeo Aula
-
36Showing Existing DatabasesVídeo Aula
-
37Showing List of TablesVídeo Aula
-
38Creating a new tableVídeo Aula
-
39Basic MySQL CommandsVídeo Aula
-
40Displaying Table StructureVídeo Aula
-
41Adding Records into a TableVídeo Aula
-
42Retrieving Records from a tableVídeo Aula
-
43Updating Existing Records in a TableVídeo Aula
-
44Deleting Records from a TableVídeo Aula
-
45Changing the structure of a TableVídeo Aula
-
46Dropping a columnVídeo Aula
-
47Removing DuplicateVídeo Aula
-
48SELECT StatmentVídeo Aula
-
49Ordering resultsVídeo Aula
-
50Filtering data with WHERE clauseVídeo Aula
-
51Displaying MySQL Databases in MySQL WorkbenchVídeo Aula
-
52View MySQL Database Tables using MySQL WorkbenchVídeo Aula
-
53Create a databaseVídeo Aula
-
54Create a tableVídeo Aula
-
55Add a single record into a database tableVídeo Aula
-
56Add multiple records into a database tableVídeo Aula
-
57Retrieving data from a database tableVídeo Aula
-
58Updating RecordsVídeo Aula
-
59Deleting RecordsVídeo Aula
-
60Viewing and changing a table's structureVídeo Aula