MySQL for Beginners

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.

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.

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.

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

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

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

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

• Accessing MySQL Server 5.6 Command Line Client

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

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

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

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

Lets see what you know when it comes to Installing MySQL

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

• CREATE DATABASE Statement
• Creating Database on MySQL Database Server

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Lets see what you can make out of the MySQL Basics

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

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

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,...)

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'

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

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

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

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

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

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

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

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

• PRIMARY KEY
• Limitation
• Usage

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

• UNIQUE KEY
• Limitation
• Usage

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

• FOREIGN KEY
• Limitation
• Usage

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

• NOT NULL
• Limitation
• Usage

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

• AUTO_INCREMENT
• Limitation
• Usage

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

• DEFAULT
• Limitation
• Usage

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

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

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

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

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

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

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

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