MySQL 101 for beginners
- 2 hours on-demand video
- 2 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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
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.
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.
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.
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.
- 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.
- NOT for experts in MYSQL
- Ideal for first time users of database
- Students interested to go in Web or Mobile application development