MySQL and MySQL Workbench For beginners

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 table's 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