MySQL 101 for beginners

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.