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.
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.
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.
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.
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.
We at Igneus have trained students from IIT's, NIT's and reputed companies. Students from all over the globe have trusted our High quality and affordable trainings from 10+ countries and have opted for our Certification programs.
IGNEUS stands for the Revolutionary and a quality enhanced change that we’ve tried to come up with in the modern world of Internet education. We’ve come up bearing in mind the maximum emphasis on the quality dealing with every new technology which has made us distinguished from the throng at internet. And this revolution of choice will keep continuing. Today IGNEUS Technologies has proudly lifting up the tag of being the world's most trusted provider of myriad of services and training programs aiding constantly in every corner of the globe along with web security aspects, and open source technology.
IGNEUS Technologies Pvt. Ltd is a dream shared and brought up by two computer geniuses to make the society upgraded and aware of the cyber crimes that curb the innocence of environment, thus starting a revolution in favor of cyber security.
Igneus stands for the Revolutionary and a quality enhanced change in every aspect of its touch to internet. Quality dealing with every new technology makes us different from the crowd of internet. The revolution of choice continues. Today Igneus Technologies is the world's most trusted provider of mentioned services and training along with web security aspects, and open source technology.