MySQL and MySQL Workbench For beginners

MySQL and MySQL Workbench For beginners, available at $49.99, has an average rating of 4.55, with 75 lectures, based on 124 reviews, and has 2119 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginner Database Administrators -DBA or Beginners to MySQL and MySQL Workbench It is particularly useful for Beginner Database Administrators -DBA or Beginners to MySQL and MySQL Workbench.

Enroll now: MySQL and MySQL Workbench For beginners

Summary

Title: MySQL and MySQL Workbench For beginners

Price: $49.99

Average Rating: 4.55

Number of Lectures: 75

Number of Published Lectures: 75

Number of Curriculum Items: 75

Number of Published Curriculum Objects: 75

Original Price: $119.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Beginner Database Administrators -DBA

Beginners to MySQL and MySQL Workbench

Target Audiences

Beginner Database Administrators -DBA

Beginners to MySQL and MySQL Workbench

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.

Course Curriculum

Chapter 1: MySQL Server Installation

Lecture 1: Overview of MySQL and MySQL Workbench

Lecture 2: Introduction

Lecture 3: What is MySQL

Lecture 4: What is SQL

Lecture 5: Basic Database Concepts

Lecture 6: What is a Schema

Lecture 7: Data Types

Lecture 8: Database Schema

Lecture 9: Download and Install MySQL (Windows)

Lecture 10: Download and Install MySQL (Mac)

Lecture 11: What is MySQL Workbench

Lecture 12: Installing MySQL Workbench (Mac)

Chapter 2: MySQL Workbench Configuration

Lecture 1: User Accessibility Options

Lecture 2: Introduction to MySQL Workbench Preferences

Lecture 3: General Editors Preferences

Lecture 4: SQL Editor Preferences

Lecture 5: Administration Preferences

Lecture 6: Modeling Preferences

Lecture 7: Fonts and Colors

Lecture 8: SSH Preferences

Lecture 9: Other Preferences

Lecture 10: MySQL Workbench Home Screen

Chapter 3: Creating Connections in MySQL Workbench

Lecture 1: Creating a new Mysql Connection

Lecture 2: Manage Server Connections

Lecture 3: Client Connections

Chapter 4: Performing Administrative Tasks in MySQL Workbench

Lecture 1: Checking Server Status

Lecture 2: Checking Users and Priviledges

Lecture 3: Exploring Performance Dashboard

Lecture 4: Using MySQL Utilities

Chapter 5: Data Export and Import Using MySQL Workbench

Lecture 1: Data Export and Import Methods

Lecture 2: Data Export and Import Using Table Wizard

Lecture 3: SQL Data Export and Import Wizard

Lecture 4: Result Data Export and Import

Chapter 6: Database Development Tools in MySQL Workbench

Lecture 1: Visual SQL Editor

Lecture 2: Object Browser

Chapter 7: MySQL CRUD Operations

Lecture 1: Showing Existing Databases

Lecture 2: Showing List of Tables

Lecture 3: Creating a new table

Lecture 4: Basic MySQL Commands

Lecture 5: Displaying Table Structure

Lecture 6: Adding Records into a Table

Lecture 7: Retrieving Records from a table

Lecture 8: Updating Existing Records in a Table

Lecture 9: Deleting Records from a Table

Lecture 10: Changing the structure of a Table

Lecture 11: Dropping a column

Lecture 12: Removing Duplicate

Lecture 13: SELECT Statment

Lecture 14: Ordering results

Lecture 15: Filtering data with WHERE clause

Chapter 8: Perform CRUD using MySQL Workbench

Lecture 1: Displaying MySQL Databases in MySQL Workbench

Lecture 2: View MySQL Database Tables using MySQL Workbench

Lecture 3: Create a database

Lecture 4: Create a table

Lecture 5: Add a single record into a database table

Lecture 6: Add multiple records into a database table

Lecture 7: Retrieving data from a database table

Lecture 8: Updating Records

Lecture 9: Deleting Records

Lecture 10: Viewing and changing a tables structure

Chapter 9: Some Basic MySQL Operators

Lecture 1: BETWEEN

Lecture 2: IN

Lecture 3: LIMIT

Lecture 4: LIKE

Lecture 5: UNION

Chapter 10: Database Modeling using MySQL Workbench

Lecture 1: Introduction to data Modeling

Lecture 2: Creating a Model -Part 1

Lecture 3: Creating a Model -Part 2

Lecture 4: Basic Modeling

Chapter 11: Aggregate Functions

Lecture 1: Introduction to Aggregate Functions

Lecture 2: COUNT Aggregate Functions

Lecture 3: SUM Aggregate Functions

Lecture 4: MIN Aggregate Functions

Lecture 5: MAX Aggregate Functions

Lecture 6: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 3 votes

2 stars: 10 votes

3 stars: 32 votes

4 stars: 38 votes

5 stars: 41 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!