MySQL Database Admin -DBA for Beginners

MySQL Database Admin -DBA for Beginners, available at $74.99, has an average rating of 4.45, with 103 lectures, based on 292 reviews, and has 17088 subscribers.

You will learn about Perform backups of your data Manage users and privileges Install the MySQL server Configure MySQL server Create Views Create stored procedures Perform table joins Create databases Create tables Explore and use MySQL Workbench Use MySQL Command line client Execute Common MySQL Commands Query databases Update databases Delete records Perform aggregate functions This course is ideal for individuals who are Beginner Database Administrators or Beginner database designers or Beginner developers It is particularly useful for Beginner Database Administrators or Beginner database designers or Beginner developers.

Enroll now: MySQL Database Admin -DBA for Beginners

Summary

Title: MySQL Database Admin -DBA for Beginners

Price: $74.99

Average Rating: 4.45

Number of Lectures: 103

Number of Published Lectures: 103

Number of Curriculum Items: 103

Number of Published Curriculum Objects: 103

Original Price: $119.99

Quality Status: approved

Status: Live

What You Will Learn

Perform backups of your data

Manage users and privileges

Install the MySQL server

Configure MySQL server

Create Views

Create stored procedures

Perform table joins

Create databases

Create tables

Explore and use MySQL Workbench

Use MySQL Command line client

Execute Common MySQL Commands

Query databases

Update databases

Delete records

Perform aggregate functions

Who Should Attend

Beginner Database Administrators

Beginner database designers

Beginner developers

Target Audiences

Beginner Database Administrators

Beginner database designers

Beginner developers

The MySQL is the world’s most popular open source database.

This course will teach you  a lot to  start using this incredibly popular MySQL database and gain useful skills in the process.  In learning about MySQL you will also gain an understanding of relational databases in general.  Furthermore, you will harness that power by learning SQL and using it to build databases, populate them with data and query that data through extensive hands-on practices.

You will learn how to use the MySQL Workbench which is a very powerful administrative tool that contains a lot of useful features that will enable you perform various administrative tasks on MySQL Server installations.

What You will learn includes:

Installation and configuration of MySQL Server

Creating Databases

Creating Tables

Creating Views

Creating Stored Procedures

Using subqueries

Managing users and proviledges

Performing backups and restore

Checking client connections

Checking Server Status

Perform table  joins

Explore and use MySQL Workbench

Use MySQL Command line client

Execute  Common MySQL Commands

Query databases

Update databases

Delete records

Perform aggregate functions

Using SQL Editors

SQL is the language used to interact with databases like MySQL  and others

SQL is a standard language for accessing and manipulating databases.

What is SQL?

SQL stands for Structured Query Language

SQL lets you access and manipulate databases

SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

What Can SQL do?

SQL can execute queries against a database

SQL can retrieve data from a database

SQL can insert records in a database

SQL can update records in a database

SQL can delete records from a database

SQL can create new databases

SQL can create new tables in a database

SQL can create stored procedures in a database

SQL can create views in a database

SQL can set permissions on tables, procedures, and views

SQL is a Standard – BUT.

Although SQL is an ANSI/ISO standard, there are different versions of the SQL language.

Course Curriculum

Chapter 1: MySQL Installation

Lecture 1: Introduction

Lecture 2: What is SQL

Lecture 3: What is MySQL

Lecture 4: MySQL Download and Installation (Windows)

Lecture 5: What is MySQL Workbench

Lecture 6: MySQL Installation (Mac)

Lecture 7: Installing MySQL Workbench (Mac)

Lecture 8: Basic Database Concepts

Lecture 9: What is a Schema

Lecture 10: Database Schema

Lecture 11: MySQL Data Types

Chapter 2: MySQL Workbench Configuration

Lecture 1: User Accessibility Options

Lecture 2: Preferences Options

Lecture 3: General Editor Preferences

Lecture 4: SQL Editor Preferences

Lecture 5: Administration Preferences

Lecture 6: Modelling Preferences

Lecture 7: Fonts and Colors

Lecture 8: SSH Preferences

Lecture 9: Other Preferences

Lecture 10: MySQL Workbench Home Screen

Chapter 3: Database Modeling

Lecture 1: Introduction to data modelling

Lecture 2: Creating a model – part 1

Lecture 3: Creating a model – part 2

Lecture 4: Basic modeling

Chapter 4: Performing Administrative tasks

Lecture 1: Creating a new MySQL Connection

Lecture 2: Managing Server Connections

Lecture 3: Client Connections

Lecture 4: Checking Server Status

Lecture 5: Administration of users and Priviledges

Lecture 6: Checking Performance Dashboard

Lecture 7: Using MySQL Utilities

Lecture 8: Using Object Browser

Lecture 9: Showing existing databases

Lecture 10: Showing list of tables

Lecture 11: Create a Database

Lecture 12: Create a Table

Lecture 13: Using basic SQL Commands

Lecture 14: Displaying table structure

Lecture 15: Changing Table Structure

Chapter 5: Creating MySQL Objects

Lecture 1: MySQL Naming Convention

Lecture 2: Creating a MySQL Database

Lecture 3: Using IF NOT EXIST DROP

Lecture 4: Creating a Table in MySQL

Lecture 5: Setting up default database

Lecture 6: Using MySQL Comments

Lecture 7: Primary keys

Lecture 8: Foreign keys

Chapter 6: MySQL Statements

Lecture 1: MySQL INSERT Statement

Lecture 2: MySQL SELECT statement

Lecture 3: MySQL UPDATE Statement

Lecture 4: MySQL DELETE Statement

Chapter 7: MySQL Access Privilege System

Lecture 1: MySQL Access Privilege

Lecture 2: What You can not do with MySQL privilege SYSTEM

Lecture 3: Static and Dynamic priviledges

Lecture 4: Applying dynamic priviledges

Lecture 5: Migrating SUPER priviledges

Lecture 6: MySQL Priviledges

Chapter 8: MySQL Backup and Recovery

Lecture 1: Introduction to MySQL Backup and Recovery

Lecture 2: Backup and Recovery Types

Lecture 3: Setting up backup directory with mysqldump

Lecture 4: Export data from MySQL Database

Lecture 5: Export result set of a query

Lecture 6: Backing up databases with mysqldump

Lecture 7: Restore database from backup

Lecture 8: Backing up a single table

Lecture 9: Restoring table from backup

Chapter 9: MySQL Table Joins

Lecture 1: MySQL INNER Join

Lecture 2: MySQL LEFT JOIN

Lecture 3: MySQL RIGHT Join

Lecture 4: MySQL SELF join

Chapter 10: MySQL Views

Lecture 1: MySQL Views

Lecture 2: Creating a MySQL View

Lecture 3: Querying MySQL Views

Lecture 4: Modifying a view

Lecture 5: Dropping a view

Chapter 11: MySQL Stored Procedures

Lecture 1: What are stored procedures

Lecture 2: Creating stored procedure

Lecture 3: Modifying stored procedure

Lecture 4: Creating an advanced stored procedure

Lecture 5: Calling and deleting stored procedures

Chapter 12: MySQL Subqueries

Lecture 1: What is a subquery

Lecture 2: Nested subqueries

Lecture 3: Derived Tables

Chapter 13: MySQL Clauses | Keywords | Some String Functions

Lecture 1: DISTINCT keyword

Lecture 2: GROUP BY Clause

Lecture 3: HAVING clause

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 9 votes

2 stars: 14 votes

3 stars: 51 votes

4 stars: 97 votes

5 stars: 121 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!