MySQL for Beginners
4.2 (1,117 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.
21,401 students enrolled
Wishlisted Wishlist

Please confirm that you want to add MySQL for Beginners to your Wishlist.

Add to Wishlist

MySQL for Beginners

Learn how to Create, Use and Handle a MySQL Database from Scratch.
4.2 (1,117 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.
21,401 students enrolled
Last updated 3/2015
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • A Computer
  • Basic Knowledge about using a Computer
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 with MySQL

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, MySQL or Database this course is for you as it starts from scratch
  • You want to create a database(MySQL) 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 with MySQL
  • 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.



Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
58 Lectures
06:04:36
+
Introduction to Course
3 Lectures 16:54

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.

Preview 05:43

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.

Preview 03:51

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.

Preview 07:20
+
Getting the Development Environment Ready
8 Lectures 47:59

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 WIndows
11:28

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 of MySQL Database Server in Ubuntu [Linux]
05:24

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
Installation MySQL Database Server in MAC OSX
09:44

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 WIndows
04:24

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 Ubuntu [Linux]
04:19

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
Introduction to MySQL Console in MAC OSX
08:25

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

Sectional Wrap-up
04:15

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

Wrap-up Document
4 pages

Lets see what you know when it comes to Installing MySQL

Test your MySQL Installation Knowledge
4 questions
+
Beginning with MySQL Basics
18 Lectures 01:45:33

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 Database - CREATE DATABASE
07:03

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
Creating a Table - CREATE TABLE
10:08

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
Inserting Values into Table - INSERT INTO
09:57

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
Retrieving Values from Table - SELECT
04:22

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 Distinct Values from Column - DISTINCT
06:49

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 a Specific Data using WHERE Clause
05:12

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 Multiple Identifiers Using AND
04:57

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
Selecting with One of Many Identifiers Using OR
05:03

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
Sorting the Data Using ORDER BY
05:24

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
Limiting the Data Retrieved Using LIMIT
08:54

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
Updating or Modifying Data in a Table Using UPDATE
05:53

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 Data from a Table Using DELETE
06:32

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 a Table - DROP TABLE
02:38

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
Deleting all values in Table - TRUNCATE TABLE
03:09

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
DESCRIBE TABLE
04:21

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
Altering Table Structure - ALTER TABLE
03:41

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

Sectional Wrap-up
11:30

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

Wrap-up Document
9 pages

Lets see what you can make out of the MySQL Basics

Testing your Basic Knowledge on MySQL
5 questions
+
Time to Jump in for More
10 Lectures 48:56

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
Selecting Data with a Range - BETWEEN
05:17

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
Creating Alias Name for a Column - AS
03:58

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,...)
Selecting Data which has one of Multitple Values - IN
03:40

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'
Using LIKE and WILDCARDS
06:14

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 Table with INSERT INTO SELECT
04:51

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 a Table Struture - CREATE TABLE LIKE
04:26

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
Copy Table with Certain Columns - INSERT INTO SELECT
03:23

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
Combine the Tables - UNION
09:49

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

Sectional Wrap-up
07:18

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

Wrap-up Document
7 pages
+
Few things that Keeps the Database in Shape
9 Lectures 48:50

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
Keeping Database in Shape
04:38

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

  • PRIMARY KEY
  • Limitation
  • Usage
PRIMARY KEY
04:43

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

  • UNIQUE KEY
  • Limitation
  • Usage
UNIQUE KEY
02:51

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

  • FOREIGN KEY
  • Limitation
  • Usage
FOREIGN KEY
09:36

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

  • NOT NULL
  • Limitation
  • Usage
NOT NULL
06:31

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

  • AUTO_INCREMENT
  • Limitation
  • Usage
AUTO_INCREMENT
05:16

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

  • DEFAULT
  • Limitation
  • Usage
DEFAULT
08:31

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

Sectional Wrap-up
06:44

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

Wrap-up Document
7 pages
+
Using Joins to Combine Tables
6 Lectures 44:12

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
INNER JOIN
09:55

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
LEFT JOIN
07:21

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
RIGHT JOIN
07:28

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
FULL JOIN
11:27

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

Sectional Wrap-up
08:01

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

Wrap-up Document
6 pages
+
Concluding the MySQL with More to Come
4 Lectures 19:12

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.

Don't Stop Now
04:20

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

A Set of Requests
05:14

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

Lets Connect to Each Other
04:15

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

Thank you Students
05:23
About the Instructor
Vasandkumar Kunasekaran
4.2 Average rating
1,262 Reviews
22,620 Students
3 Courses
Certified Software & Cloud Developer.

I am Vasandkumar, a Certified Software and Cloud Developer with wide spread experience on new Technologies. I have completed my Post Graduate on Computer Science and Engineering. 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 youtuber 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.