Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add MySQL Database Development for Beginners to your Wishlist.

Add to Wishlist

MySQL Database Development for Beginners

We’ll Introduce the Basic Concepts of RDBMS in general with MySQL Database for Beginners
4.3 (150 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.
8,515 students enrolled
Last updated 9/2015
$10 $95 89% off
4 days left at this price!
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

MySQL is a general purpose relational database management system (RDBMS) used mainly to provide a back-end database for web applications. In this course, we'll introduce the concepts of relational database management systems in general, and how they relate to MySQL in particular.

Unlike traditional courses that concentrate mainly on theory, we'll take a practical “how-to” approach to working with data. Here's what yyou'll learn:

Creating databases and tables

Adding data to a table with INSERT

Reading a table with SELECT

How to use WHERE to filter data

Using ORDER BY to sort data

JOINs and how to use them to read from multiple tables

Changing data in a table with UPDATE

The DELETE query: removing one or more rows of data from a table

Using a text file to load a database schema

These topics and many more will be covered. The concentration in this course is on MySQL itself… not on how to use it to for any particular purpose. But this course makes a great introduction to our upcoming course about web databases using php and MySQL. So why wait… sign up today!

Who is the target audience?
  • Beginner who wants to Learn MySQL, or an Expert wants to refresh MySQL Knowledge
Students Who Viewed This Course Also Viewed
What Will I Learn?
Understand the Basic Relational Database Management System Concepts
Execute Basic to Advanced MySQL Queries
View Curriculum
  • Knowledge of RDBMS Concept is Helpful but Not Required
Curriculum For This Course
Expand All 20 Lectures Collapse All 20 Lectures 01:54:34
Introduction and Installation
5 Lectures 35:38

MySQL Data Types

Creating an Auto Incrementing Primary Key
MySQL Basic Statements
4 Lectures 22:44
Describe Table

Loading sql Files into MySQL

Introduction to SELECT Query

SELECT Query Demo
MySQL Advanced Statements
5 Lectures 27:05
MySQL Update Query

Mathematical Operations


Table Relationships

Introduction to Joins
MySQL Advanaced Statements Part 2
6 Lectures 29:07
The Delete Query

Types of Joins

Joins Demo

Creating and Using Views

Setting up a Many to Many Relationship

Demo of Many to Many Relationship
About the Instructor
4.2 Average rating
5,031 Reviews
135,161 Students
80 Courses
Programming Made Easy

EDUmobile Academy develops high quality video training courses around topics in mobile development including iPhone, Android, Windows Phone, Java, Responsive Web Design and other emerging technologies.

Every course is created by an expert developer AND a trained mentor in the area of expertise.

Each course undergoes a rigorous planning, review and an internal quality check phase - to ensure that the teaching is of highest standards available online.

EDUmobile Academy was founded in 2008 when smart phones were just emerging into the market. Founder Vishal Lamba is experienced in multiple areas of digital design, mobile development and design, web technologies and digital marketing. He has a mathematics and computer science degree from Lawrence University, USA.

Vishal works closely with content creators and teachers to ensure that every course released meets the internal rigorous quality standards.

All course creators and trainers are currently based in the USA. Support for each course on Udemy is provided with quick turn around by a small team of developers and trainers.

Report Abuse