MySQL Database Development for Beginners
4.3 (239 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
8,676 students enrolled

MySQL Database Development for Beginners

We’ll Introduce the Basic Concepts of RDBMS in general with MySQL Database for Beginners
4.3 (239 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
8,676 students enrolled
Created by EDUmobile Academy
Last updated 9/2015
English
English [Auto]
Current price: $65.99 Original price: $94.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 8 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Understand the Basic Relational Database Management System Concepts
  • Execute Basic to Advanced MySQL Queries
Requirements
  • Knowledge of RDBMS Concept is Helpful but Not Required
Description

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 this course is for:
  • Beginner who wants to Learn MySQL, or an Expert wants to refresh MySQL Knowledge
Course content
Expand all 20 lectures 01:54:33
+ MySQL Basic Statements
4 lectures 22:44
Describe Table
03:59
Loading sql Files into MySQL
06:55
Introduction to SELECT Query
06:34
SELECT Query Demo
05:16
+ MySQL Advanced Statements
5 lectures 27:05
MySQL Update Query
03:15
Mathematical Operations
06:06
DISTINCT, COUNT and GROUP BY Clauses
04:02
Table Relationships
07:47
Introduction to Joins
05:55
+ MySQL Advanaced Statements Part 2
6 lectures 29:07
The Delete Query
04:36
Types of Joins
06:04
Joins Demo
04:36
Creating and Using Views
02:43
Setting up a Many to Many Relationship
04:36
Demo of Many to Many Relationship
06:32