MySQL for Beginners

Learn how to Create, Use and Handle a MySQL Database from Scratch
4.3 (916 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
20,920 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 58
  • Length 6 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2015 English

Course Description

MySQL Database Being the Second most widely used Relational Database makes it one of the database to learn if you are looking forward to develop a database driven application.

Are you a Web Developer? An Application Developer? or A Programmer? Then MySQL Database should be one of the Mandatory Database in your "To Learn" list. If you don't know MySQL yet or if you are new to any database then this is your go to course to learn SQL and also MySQL Database.

If you are learning or want to learn PHP, PYTHON, PEARL or RUBY then you should learn MySQL as well as this is the Database that is used by most of the developer who prefer the previously mentioned programming languages. If you are Web Developer and you don't know MySQL yet then most won't recommend you to call yourself as a Web Developer yet.

MySQL is one of the most used and go to database for pretty much all the web developer who pick PHP, PEARL or Python without a second thought.

What does this Course cover?

  • Installation of MySQL Server in your Local System
  • Setting up and Configuring MySQL Database Server
  • Creating a Database with data
  • Maintaining the Database
  • Designing a better database
  • Covers all the basic you should know to create a complex database driven application

Materials Included with this Course:

  • Course has around 50 Videos and will grow with time
  • Materials will be updated regularly
  • Sectional wrap up with a document containing all the Query Syntax
  • Instructor Help when needed by student (Discussion Board)

Why should you take this course?

  • If you don't have any idea about SQL or Database this course is for you as it starts from scratch
  • You want to create a database driven application? All you need to create the database and write queries for the same will be covered
  • Maintaining you database with Ease even if you have no experience
  • Some concepts are taught in such a way you will learn them as you practice them and implement in your own way for better involvement and learning.

The course follows a typical flow of topic which is considered best for learning the MySQL Database. The learning curve of SQL is also a part of this course.



What are the requirements?

  • A Computer
  • Basic Knowledge about using a Computer

What am I going to get from this course?

  • Create a Well Structure Database
  • Handle a Database with Pretty 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

What is the target audience?

  • This course is for people who are new Databases or SQL
  • All who are willing to learn MySQL
  • Web Developers
  • Programmers
  • Application Developers
  • If there is anywhere a word called MySQL in things you want to learn then is the right course for you

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to Course
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.

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.

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.

Section 2: Getting the Development Environment Ready
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
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
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
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
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
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
04:15

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

4 pages

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

4 questions

Lets see what you know when it comes to Installing MySQL

Section 3: Beginning with MySQL Basics
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
11:30

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

9 pages

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

5 questions

Lets see what you can make out of the MySQL Basics

Section 4: Time to Jump in for More
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
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
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,...)
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'
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
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
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
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
07:18

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

7 pages

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

Section 5: Few things that Keeps the Database in Shape
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
04:43

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

  • PRIMARY KEY
  • Limitation
  • Usage
02:51

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

  • UNIQUE KEY
  • Limitation
  • Usage
09:36

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

  • FOREIGN KEY
  • Limitation
  • Usage
06:31

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

  • NOT NULL
  • Limitation
  • Usage
05:16

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

  • AUTO_INCREMENT
  • Limitation
  • Usage
08:31

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

  • DEFAULT
  • Limitation
  • Usage
06:44

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

7 pages

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

Section 6: Using Joins to Combine Tables
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
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
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
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
08:01

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

6 pages

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

Section 7: Concluding the MySQL with More to Come
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.

05:14

A set of requests to all the students who have taken up and enrolled to the course.

04:15

A way to connect to each other between the student and instructor in case some of the students need them.

05:23

A Thanking Video to thank all students who have taken up the course and some information about myself with a request to all students.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Vasandkumar Kunasekaran, Developer and Youtuber

I am Vasandkumar, a Post Graduate with Masters in Technology in Computer Science and Engineering currently working as a Web Developer. I do a lot of Freelance works in Web Development, Mobile Application Development and a lot of Programming.

I am very passionate about computers and Programming. Well I started out as a basic programmer in Java and right now capable of programming in around 6 programming languages.

I love teaching or mentoring on something I know and also an active youtube successfully running the youtube channel WebDevMentors.

Personally a friendly guy and talks a lot. Mostly categorized as a Tech Geek but I believe there is a lot to learn.

Ready to start learning?
Take This Course