MySQL 101 for beginners
4.5 (9 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.
1,237 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

MySQL 101 for beginners

Learn to design and handle MYSQL with this quick and mobile optimized video training. 101 means no prerequisite !
4.5 (9 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.
1,237 students enrolled
Last updated 2/2015
English
Current price: $10 Original price: $100 Discount: 90% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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
View Curriculum
Requirements
  • 101 means no prior knowledge is required
  • MYSQL (installation video is available in course)
  • Windows or MAC basics are expected like opening a file
Description

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 is the target audience?
  • NOT for experts in MYSQL
  • Ideal for first time users of database
  • Students interested to go in Web or Mobile application development
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 21 Lectures Collapse 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
01:37
+
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
08:22

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
04:43

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
03:58

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
02:44

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
08:54

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
06:29

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
05:19

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
03:03

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
04:12

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
05:45

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
05:43

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
05:54

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
06:04

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
10:57
+
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
09:51
+
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
01:30
About the Instructor
Igneus Technologies
4.4 Average rating
1,765 Reviews
58,810 Students
31 Courses
Best Comprehensive Courses

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.