MySQL Database Development for Beginners

We’ll Introduce the Basic Concepts of RDBMS in general with MySQL Database for Beginners

Created byEDUmobile Academy

Last updated 9/2015

English

English [Auto],

What you'll learn

Understand the Basic Relational Database Management System Concepts
Execute Basic to Advanced MySQL Queries

Course content

4 sections • 20 lectures • 1h 54m total length

Installing MySQL5:33
install mysql by downloading a bundle that includes apache, php, and mysql; start all servers and log in as root with no password to begin exploring mysql.
Database Creation2:46
View existing databases, create a new database named course, and switch to it; then show tables to see an empty set, noting information_schema and performance_schema and not deleting test.
Table Creation with SELECT and INSERT6:26
Create a simple names table with first and last text columns, insert a row like John Doe, and retrieve data with select queries using where filters.
MySQL Data Types12:47
Understand MySQL data types: numeric (tinyint to bigint), floating (float, double) and decimal, character (char, varchar, binary, blob), and date types (date, datetime, timestamp) with not null.
Creating an Auto Incrementing Primary Key8:06
Create a names table with an auto incrementing primary key id (mediumint, not null, unique). Insert sample names and query by name or id to see the key in action.

Describe Table3:59
Describe table demonstrates how to create a small contacts database with names and addresses using a sql file. It explains table structure, primary keys, autoincrement, and the name_id relation.
Loading sql Files into MySQL6:55
Drop and recreate database, switch to it, create names and addresses tables, then insert test data and use insert into ... select to link IDs via names using source.
Introduction to SELECT Query6:34
Learn how to use select queries to read data from tables, choosing specific or all columns, and apply where, like, order by, and limit clauses.
SELECT Query Demo5:16
Learn how to use the select statement to query the names table, apply where and like filters, order results, and limit rows for precise results.

MySQL Update Query3:15
Master the MySQL update query to modify values in one or more columns across rows, using update table set column=value pairs with an optional where clause.
Mathematical Operations6:06
Explore how to perform arithmetic in MySQL queries and updates, using plus, minus, times, divide, modulus, and integer division, with table creation, insertion, updates, and aliases.
DISTINCT, COUNT and GROUP BY Clauses4:02
Learn to use distinct to list unique last names, count rows, and apply group by to tally occurrences by last name in a names table, with sorting options.
Table Relationships7:47
Explore relational database concepts in MySQL by examining one-to-one, one-to-many, and many-to-many relationships, and learn how primary keys, foreign keys, and join tables connect data across tables.
Introduction to Joins5:55
Join the names and addresses tables on names.id (the primary key) and addresses.name_id (the foreign key) to show first names, last names, and their addresses in a one-to-many relationship.

The Delete Query4:36
Learn how to delete rows from a table using the delete query, including the importance of a where clause and how auto-incremented IDs are not reused.
Types of Joins6:04
Explore the four types of joins in MySQL—inner, left, right, and full cartesian joins—using example tables Names and Colors, and learn how join syntax and data setup affect results.
Joins Demo4:36
Explore inner, left, right, and full joins in MySQL with practical examples that link names and colors using on clauses and key matching.
Creating and Using Views2:43
Create and use a view in MySQL to save a complex left join query, name it favorite colors, and query or drop it as needed.
Setting up a Many to Many Relationship4:36
Drop and recreate a database demonstrating a many-to-many relationship between names and items. Create names and items tables and a names_items join table with name_id and item_id to map ownership.
Demo of Many to Many Relationship6:32
Demonstrates a many-to-many relationship using a three-table join (names, items, join table) with inner joins, aliases, and a view to query paired names and items.

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

MySQL Database Development for Beginners

What you'll learn

Explore related topics

Course content

Introduction and Installation5 lectures • 36min

MySQL Basic Statements4 lectures • 23min

MySQL Advanced Statements5 lectures • 27min

MySQL Advanaced Statements Part 26 lectures • 29min

Requirements

Description

Who this course is for: