MySQL 101 for beginners
4.2 (19 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,300 students enrolled

MySQL 101 for beginners

Learn to design and handle MYSQL with this quick and mobile optimized video training. 101 means no prerequisite !
4.2 (19 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,300 students enrolled
Last updated 2/2015
English [Auto-generated]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Introduction to MYSQL
  • You'll learn to create your first database
  • Perform CRUD (Create, Read, Update and Delete) Operation
  • Handle any existing database in MYSQL
  • You'll be able to understand future jargon's of database technology
Course content
Expand all 21 lectures 01:59:13
+ Lets get started
3 lectures 09:02

This video will give you a brief about why there is a need of database. We have excel and word to store data but still we need to switch to database for few reasons which are discussed in this movie.

Preview 02:51

There are a lot of terms which are discussed a lot in database world. Terms like RDBMS which stands for Relational DataBase Management System. There are many such terms which are covered in this movie.

Preview 04:34

Our goal in this series is not very high. We just want to make sure students who are taking this course are able to understand MySQL. They are able to create small scale projects immediately after this course and soon after practice they can create some extra ordinary projects with this training.

Our goal in this series
+ Installation and getting friendly with MySql
6 lectures 24:30

Installation of MySQL is very simple and can be done on Windows, MAC and linux. This video will show you the link to download relevant file for your system. After installation please got through next movie as there are few important steps.

Installation for MySQL

There are few default configuration in MySQL, which are mandatory to be changed. There is a root user which don't have any password but in this movie we will learn to set password for root user.

Root user account and password

Before creating a database it is very important to understand and tour the existing database. We will explore the existing database information_schema. we will display tables from this database as well as will display their columns.

Preview 04:43

Time to create things of our own. In this movie we will create our own database. Creating database in MySQL is really simple. Also we will explore to drop or delete a database too. May be for reason you have created database that you don't need that drop a database is important.

Creating and deleting the databases

After creating database you want to populate that database with some tables. In order to do that you have to first select the database. USE database-name is the command that will help you to select the existing database.

selecting a database

MySQL consists a variety of datatypes. This presentation is designed to quickly summarize the database and discuss the crucial features of each datatypes. We would recommend NOT TO SKIP this presentation as it is going to really helpful to all.

DataTypes in Mysql
12 pages
+ Working with MySql Database
10 lectures 01:02:20

After creating a database, that database needs to be populated with different tables. In this movie we will learn to create new tables with different rules in those tables. We will also learn to delete a table in MySQL.

creating and deleting tables in mysql

A table after imposing rules needs to be populated with relevant data. Inserting data into tables also have special syntax. Explore that syntax in this movie. All though we can insert data into variety of ways but we will first learn just the easy way to learn that syntax.

inserting values in tables in mysql

Updating the existing information is very important as there are high chances that information can be mistypes or may got changed with time. In this movie we will explore the ways to change the information by using the WHERE clause.

where clause and updating the database

Time to learn to remove some information completely from the table. Remember this can be dangerous as there is no UNDO option in this case. Make sure you select the information correctly because once gone is completely gone.

deleting values from database

This video is all about getting different information from the database. We don't need to display all the content of the database all the time. So this movie will help you to display selective information on the screen.

Getting the result from database

There are a variety of JOIN possible in database but we will start with short and baby steps. We will learn to join two table and collectively display some information from it. tables from the database can be called using dot syntax.

Joining the two tables for result

NULL is a kind of special thing in database as it represent nothing. Nothing means not even zero because even zero is a value. This entire movie will display the concept of NULL and guide you where NULL values can alter the results.

Null values in database

Many time in our application we just want to store some information for temporary basis. That information might be valuable for few hours and after that, that information should be deleted. We can do this kind of task in temporary tables.

Temporary tables

Bending the rules in not good in database but there are few situation where you need to do so. Or you might want to change the name of existing table. Instead of dropping the table, you can use the ALTER clause to fix up the things.

using ALTER in mysql

Having duplicate data is good but not in the case of database. You don't want to store one detail a thousand time. So in this video you will learn a couple easy way to deal up with this problem of duplication. You can even restrict the user based if the data is entered as duplicate.

Duplicates in Mysql
+ Additional work and projects
1 lecture 09:51

Time to get your hand dirty with this simple yet knowledgeable project. You have to create a simple back end to store first name , last name and mobile numbers. Make sure that Mobile number are repeated as duplicate. Latter on we want to add email column in the database.

Project of Mobile number storage
+ Final words
1 lecture 01:30

Best way to enhance the knowledge is to make sure that you are working continuously with MySQL. Starting up with small scale project will lead to big application one day. Talking with the same community is also great way to solve problem.

What to do after learning MySQL
  • 101 means no prior knowledge is required
  • MYSQL (installation video is available in course)
  • Windows or MAC basics are expected like opening a file

MySQL is a great place to get started with database. Many experienced programmers recommend to beginners to get your dirty with MySQL first as it is considered as basic element in database world. This MySQL 101 is one of the ideal practical training that will help you to learn quickly about databases. After completing this training you will be able to create back end of web as well as mobile application.

MySQL, the world's second most extensively used open-source relational database management system (RDBMS). It is named behind co-founder Michael Widenius's daughter, MyThe SQL contraction stands for Structured Query Language.

The MySQL development project has made its source code accessible under the terms of the GNU General Public License, as well as under a diversity of proprietary agreements. MySQL was owned and sponsored by a solitary for-profit firm, the Swedish corporation MySQL AB, now owned by Oracle Corporation.

MySQL is a fashionable preference of database for use in web applications, and is a fundamental factor of the extensively used LAMP open source web application software stack (and other 'AMP' stacks). LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python." Free-software-open source projects that oblige a full-featured database management system often use MySQL.

Features of MySQL:

Because of its exclusive storage engine architecture MySQL performance is very high.

Supports large amount of embedded applications which makes MySql very supple.

Use of Triggers, Stored procedures and views which allows the developer to provide a advanced efficiency.

Allows transactions to be rolled back, commit and crash recovery.

We hope that this training will be valuable to you, to put into practice the knowledge gained in this course, to your dream project.

This course will have future updates to make sure that course remains updated in future. Students are requested to discuss so that we can understand their problems and create more videos to address their problems.

Who this course is for:
  • NOT for experts in MYSQL
  • Ideal for first time users of database
  • Students interested to go in Web or Mobile application development