Mysql Db For Beginners

Learn how to Create, Use and Handle a MySQL Database from Scratch.

Last updated 2022-01-10 | 4.8

- Create a Well Structured Database
- Handle a Database with good efficiency
- Create a Database that can handle itself on most conditions

What you'll learn

Create a Well Structured Database

Handle a Database with good efficiency

Create a Database that can handle itself on most conditions

Create MySQL Queries that are efficient and clear

Understand the errors as they occur and rectify them

Administrate the Database with Ease

Create SQL Queries for Database Driven Applications

Spot abnormality in Database Table

Database Structure as needed for good design

Indexing Tables for Better Performance

Good practices to be followed

* Requirements

* A Computer
* Basic Knowledge about using a Computer

Description

Create a Well Structured Database
Handle a Database with good efficiency
Create a Database that can handle itself on most conditions
Create MySQL Queries that are efficient and clear
Understand the errors as they occur and rectify them
Administrate the Database with Ease
Create SQL Queries for Database Driven Applications
Spot abnormality in Database Table
Database Structure as needed for good design
Indexing Tables for Better Performance
Good practices to be followed

Course content

7 sections • 60 lectures

Introduction to Course 3 lectures

Course Introduction Preview 05:43

A Lecture giving an Introduction to the Course. Know what you can get from this course and what I as an Instructor expect you to do and expect you not to do when it comes to this course.

Introduction to MySQL Preview 03:51

A Lecture giving an Introduction to the MySQL. Few information about the MySQL and why it is so important when it comes to database that are needed these days.

Few Instructions to Students Preview 07:20

This Lecture is to provide some instructions to students with what you should do and expected to do to get more out of this course. It is not mandatory but will definitely improve your learning.

Getting the Development Environment Ready 9 lectures

Installation of MySQL Database Server in WIndows Preview 11:28

A step by step installation Guide for Installing MySQL Database Server in Windows based operating system. The lecture contains the following covered:

Acquiring the required files
Installing the MySQL Database
Configuring the MySQL Database Server
Starting/Stopping MySQL Database Server

Installation of MySQL Database Server in Ubuntu [Linux] Preview 05:24

A step by step installation Guide for Installing MySQL Database Server in Linux based operating system. The lecture contains the following covered:

Updating the Source Repository
Installing the MySQL Database Server
Check if MySQL Server Service running
Restarting the MySQL Database Server
Starting/Stopping MySQL Database Server

Installation MySQL Database Server in MAC OSX Preview 09:44

A step by step installation Guide for Installing MySQL Database Server in MAC OSX based operating system. The lecture contains the following covered:

Acquiring the required files
Installing the MySQL Database
Configuring the MySQL Database Server
Starting/Stopping MySQL Database Server
Adding MySQL command to Shell Command Bash for accessing MySQL Console in Terminal

Introduction to MySQL Console in WIndows Preview 04:24

A Short Introduction to MySQL Console in Windows Based Operating System. The Lecture contains the following:

Accessing MySQL Server 5.6 Command Line Client

Introduction to MySQL Console in Ubuntu [Linux] Preview 04:19

A Short Introduction to MySQL Console in Linux Based Operating System. The Lecture contains the following:

Accessing MySQL Server 5.6 console from Terminal
Command that is used to access the MySQL Console

Introduction to MySQL Console in MAC OSX Preview 08:25

A Short Introduction to MySQL Console in MAC OSX Based Operating System. The Lecture contains the following:

Adding MySQL Command to the Terminal Shell command Bash
Accessing MySQL Server 5.6 Command Line Client

Sectional Wrap-up Preview 04:15

A Sectional Wrap-up Video that sums up and recaps everything learnt in the section with some query syntax when needed.

Wrap-up Document Preview 4 pages

The Wrap up presentation to brush up the sectional topics and engage in student community as part of Classroom environment.

Test your MySQL Installation Knowledge

Lets see what you know when it comes to Installing MySQL

Beginning with MySQL Basics 19 lectures

Creating a Database - CREATE DATABASE Preview 07:03

Lecture on Creating a Database in a MySQL Server. The Lecture contains the following:

CREATE DATABASE Statement
Creating Database on MySQL Database Server

Creating a Table - CREATE TABLE Preview 10:08

Lecture on Creating a Table in a MySQL Server. The Lecture contains the following:

CREATE TABLE Statement
Using a Database in the Server
Creating Table on MySQL Database Server
Datatypes like INT, VARCHAR & TIMESTAMP
Constraints like AUTO_INCREMENT, NOT NULL and PRIMARY KEY

Inserting Values into Table - INSERT INTO Preview 09:57

Lecture on Inserting Value in a MySQL Server Database Table. The Lecture contains the following:

INSERT INTO Statement
Inserting Value in a MySQL Server Database Table
Columns that need to be mentioned
Values and their formats

Retrieving Values from Table - SELECT Preview 04:22

Lecture on Selecting Value from a MySQL Server Database Table. The Lecture contains the following:

SELECT FROM Statement
Selecting Value from a MySQL Server Database Table
How to select all data from a database table
SELECT * FROM table_name

Selecting Distinct Values from Column - DISTINCT Preview 06:49

Lecture on Selecting Distinct Value from a MySQL Server Database Table Column. The Lecture contains the following:

SELECT DISTINCT column_name FROM Statement
Selecting Distinct Value from a MySQL Server Database Table Column
How to select unique or distinct values from a specific table column
SELECT DISTINCT column_name FROM table_name

Selecting a Specific Data using WHERE Clause Preview 05:12

Lecture on Selecting Specific Value from a MySQL Server Database Table. The Lecture contains the following:

SELECT FROM Statement with WHERE Caluse
Selecting Specific Value from a MySQL Server Database Table
How to select specific data from a database table using where clause checking with a value on a column
SELECT * FROM table_name WHERE column_name = value

Selecting with Multiple Identifiers Using AND Preview 04:57

Lecture on Selecting Specific Value from a MySQL Server Database Table with multiple checks. The Lecture contains the following:

SELECT FROM Statement with WHERE Clause and AND keyword
Selecting Specific Value from a MySQL Server Database Table with Multiple value checks
How to select specific data from a database table using where clause and AND keyword checking with multiple value for different column.
SELECT * FROM table_name WHERE column_name = value AND column_name = value

Selecting with One of Many Identifiers Using OR Preview 05:03

Lecture on Selecting Specific Value from a MySQL Server Database Table with multiple checks where one or all of the value being checked for true. The Lecture contains the following:

SELECT FROM Statement with WHERE Clause and OR keyword
Selecting Specific Value from a MySQL Server Database Table with Multiple value checks
How to select specific data from a database table using where clause and OR keyword checking with multiple value for different column where one of the or all of the column checked for true.
SELECT * FROM table_name WHERE column_name = value OR column_name = value

Sorting the Data Using ORDER BY Preview 05:24

Lecture on Ordering the Selected Values from a MySQL Server Database Table. The Lecture contains the following:

SELECT FROM Statement with ORDER BY
Ordering the Selected Values from a MySQL Server Database Table
How to select data from a database table and order them by using ORDER BY with ASC or DESC keywords as values.
SELECT * FROM table_name ORDER BY ASC/DESC

Limiting the Data Retrieved Using LIMIT Preview 08:54

Lecture on Limiting the Selected Values from a MySQL Server Database Table. The Lecture contains the following:

SELECT FROM Statement with LIMIT
Limiting the Selected Values from a MySQL Server Database Table
How to select data from a database table and then limit them with LIMIT keywords.
SELECT * FROM table_name LIMIT start,count

Updating or Modifying Data in a Table Using UPDATE Preview 05:53

Lecture on Updating the Values from a MySQL Server Database Table. The Lecture contains the following:

UPDATE Statement
Ordering the Selected Values from a MySQL Server Database Table
How to update a value in a database table with UPDATE statement by selecting specific row of data
UPDATE table_name SET column_name = value WHERE column_name = value

Deleting a Data from a Table Using DELETE Preview 06:32

Lecture on Deleting the Selected Values from a MySQL Server Database Table. The Lecture contains the following:

DELETE Statement with WHERE Clause
Deleting the Selected Values from a MySQL Server Database Table
How to select data from a database table and delete that data from Database table using DELETE
DELETE FROM table_name WHERE column_name = value

Deleting a Table - DROP TABLE Preview 02:38

Lecture on Dropping or Deleting the entire MySQL Server Database Table. The Lecture contains the following:

DROP TABLE Statement
Dropping or Deleting the entire MySQL Server Database Table
How to delete the table along values and structure in database
DROP TABLE table_name

Deleting all values in Table - TRUNCATE TABLE Preview 03:09

Lecture on Deleting only the values from the MySQL Server Database Table. The Lecture contains the following:

TRUNCATE TABLE Statement
Deleting only the values from MySQL Server Database Table
How to delete the table values and preserving structure in database
TRUNCATE TABLE table_name

DESCRIBE TABLE Preview 04:21

Lecture on Describing the MySQL Server Database Table. The Lecture contains the following:

DESCRIBE Statement
Describing the MySQL Server Database Table
How to describe the table displaying the structure, data type and constraints in the table
DESCRIBE table_name

Altering Table Structure - ALTER TABLE Preview 03:41

Lecture on Altering the MySQL Server Database Table. The Lecture contains the following:

ALTER TABLE Statement
Altering the MySQL Server Database Table
How to Alter the table using ALTER
ALTER TABLE table_name ADD COLUMN column_name data_type constraints
ALTER TABLE table_name DROP COLUMN column_name
ALTER TABLE table_name MODIFY COLUMN column_name data_type constraints

Sectional Wrap-up Preview 11:30

A Sectional Wrap-up Video that sums up and recaps everything learnt in the section with some query syntax when needed.

Wrap-up Document Preview 9 pages

The Wrap up presentation to brush up the sectional topics and engage in student community as part of Classroom environment.

Testing your Basic Knowledge on MySQL

Lets see what you can make out of the MySQL Basics

Time to Jump in for More 10 lectures

Selecting Data with a Range - BETWEEN Preview 05:17

Lecture on Selecting data with range in the MySQL Server Database Table. The Lecture contains the following:

SELECT FROM Statement with BETWEEN
Selecting data with range in the MySQL Server Database Table
How to select data that lies between a range
SELECT * FROM table_name WHERE column_name BETWEEN value and value

Creating Alias Name for a Column - AS Preview 03:58

Lecture on creating an alias name for a column in the MySQL Server Database Table. The Lecture contains the following:

SELECT FROM Statement with AS
creating an alias name for a column in the MySQL Server Database Table
How to create an alias name for a column in a table
SELECT column_name AS alias_name FROM table_name

Selecting Data which has one of Multitple Values - IN Preview 03:40

Lecture on selecting specific data checked with multiple values in the MySQL Server Database Table. The Lecture contains the following:

SELECT FROM Statement with IN
selecting specific data checked with multiple values in the MySQL Server Database Table
How to select data which has one or all of multiple data in a column
SELECT * FROM table_name WHERE column_name in (value,value,...)

Using LIKE and WILDCARDS Preview 06:14

Lecture on selecting specific data with LIKE and Wildcard in the MySQL Server Database Table. The Lecture contains the following:

SELECT FROM Statement with LIKE
Selecting specific data checked with LIKE in the MySQL Server Database Table
How to select data which has part of the value mentioned using LIKE and wildcards
SELECT * FROM table_name WHERE column_name LIKE '%value%'/'_alue'

Copy Table with INSERT INTO SELECT Preview 04:51

Lecture on copying values from one table to another MySQL Server Database Table. The Lecture contains the following:

INSERT INTO SELECT statement
Copying values from one table to another table
How to copy all the values from one table to another similar table
INSERT INTO table_name SELECT * FROM table_name

Copy a Table Struture - CREATE TABLE LIKE Preview 04:26

Lecture on creating a table structure like another MySQL Server Database Table. The Lecture contains the following:

CREATE TABLE with LIKE
Copying the structure of a table by creating another one
How to create a table with same structure as another table
CREATE TABLE table_name LIKE table_name

Copy Table with Certain Columns - INSERT INTO SELECT Preview 03:23

Lecture on copying values from one table to another MySQL Server Database Table with reduced columns. The Lecture contains the following:

INSERT INTO SELECT statement
Copying values from one table to another table
How to copy all the values from one table to another similar table with reduced columns
INSERT INTO table_name SELECT column_name,column_name FROM table_name

Combine the Tables - UNION Preview 09:49

Lecture on combining two tables using UNION in MySQL Server Database. The Lecture contains the following:

SELECT FROM with UNION
combining two tables using UNION in MySQL Server Database
How to combine two tables and display the values with same columns
SELECT * FROM table_name UNION SELECT * FROM table_name

Sectional Wrap-up Preview 07:18

A Sectional Wrap-up Video that sums up and recaps everything learnt in the section with some query syntax when needed.

Wrap-up Document Preview 7 pages

The Wrap up presentation to brush up the sectional topics and engage in student community as part of Classroom environment.

Few things that Keeps the Database in Shape 9 lectures

Keeping Database in Shape Preview 04:38

Lecture on some of the constraints that keeps the table in MySQL Server Database in shape. The Lecture contains the following:

Just an Intro to the Section

PRIMARY KEY Preview 04:43

Lecture on Primary Key in MySQL Server Database in shape. The Lecture contains the following:

PRIMARY KEY
Limitation
Usage

UNIQUE KEY Preview 02:51

Lecture on Unique Key in MySQL Server Database in shape. The Lecture contains the following:

UNIQUE KEY
Limitation
Usage

FOREIGN KEY Preview 09:36

Lecture on FOREIGN Key in MySQL Server Database in shape. The Lecture contains the following:

FOREIGN KEY
Limitation
Usage

NOT NULL Preview 06:31

Lecture on NOT NULL in MySQL Server Database in shape. The Lecture contains the following:

NOT NULL
Limitation
Usage

AUTO_INCREMENT Preview 05:16

Lecture on Auto Increment in MySQL Server Database in shape. The Lecture contains the following:

AUTO_INCREMENT
Limitation
Usage

DEFAULT Preview 08:31

Lecture on Default in MySQL Server Database in shape. The Lecture contains the following:

DEFAULT
Limitation
Usage

Sectional Wrap-up Preview 06:44

A Sectional Wrap-up Video that sums up and recaps everything learnt in the section with some query syntax when needed.

Wrap-up Document Preview 7 pages

The Wrap up presentation to brush up the sectional topics and engage in student community as part of Classroom environment.

Using Joins to Combine Tables 6 lectures

INNER JOIN Preview 09:55

Lecture on Inner Join in MySQL Server Database in shape. The Lecture contains the following:

INNER JOIN
Join two tables with INNER JOIN to get the common data
Usage
SELECT * FROM table_name INNER JOIN table_name ON table_name.column_name=table_name.column_name

LEFT JOIN Preview 07:21

Lecture on Left Join in MySQL Server Database in shape. The Lecture contains the following:

LEFT JOIN
Join two tables with Left JOIN to get the common data and all data from Left Table
Usage
SELECT * FROM table_name LEFT JOIN table_name ON table_name.column_name=table_name.column_name

RIGHT JOIN Preview 07:28

Lecture on Right Join in MySQL Server Database in shape. The Lecture contains the following:

RIGHT JOIN
Join two tables with Right JOIN to get the common data and all data from Right Table
Usage
SELECT * FROM table_name RIGHT JOIN table_name ON table_name.column_name=table_name.column_name

FULL JOIN Preview 11:27

Lecture on Full Join in MySQL Server Database in shape. The Lecture contains the following:

FULL JOIN with UNION
Join two tables with FULL JOIN to get the all data from both Tables
Usage
SELECT * FROM table_name LEFT JOIN table_name ON table_name.column_name=table_name.column_name UNION SELECT * FROM table_name RIGHT JOIN table_name ON table_name.column_name=table_name.column_name

Sectional Wrap-up Preview 08:01

A Sectional Wrap-up Video that sums up and recaps everything learnt in the section with some query syntax when needed.

Wrap-up Document Preview 6 pages

The Wrap up presentation to brush up the sectional topics and engage in student community as part of Classroom environment.

Concluding the MySQL with More to Come 4 lectures

Don't Stop Now Preview 04:20

The course lectures and the materials are not the end, there is always something new that you can learn so keep learning and share anything that you have learnt new.