MySQL and MySQL Workbench For beginners

[mitsumi]

MySQL and MySQL Workbench For beginners
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 2.22 GB
Genre: eLearning Video | Duration: 63 lectures (6 hour, 14 mins) | Language: English

 Learn some fundamentals of MySQL and MySQL Workbench

What you'll learn

    Install MySQL and MySQL Workbench
    Configure MySQL Workbench
    Create new connections to MySQL Server
    Manage Server Connections
    Check Server Status
    Check Users and Priviledges
    View Performance Dashboard
    Use MySQL Utilities
    Perform Data Export and Import
    Explore Database Development Tools
    Use Some basic MySQL Operators
    Create database objects
    Retrieve and Read Data from Database Table
    Update existing records in a table
    Delete records from a table
    Remove Duplicates from results of a query
    Database Modeling
    Create a Model

Requirements

    Basic knowledge of SQL
    Basic knowledge of database concepts

Description

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.

Who this course is for:

    Beginner Database Administrators -DBA
    Beginners to MySQL and MySQL Workbench

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction