An Introduction to MySQL Database Development

Name: An Introduction to MySQL Database Development
Brand: EDUmobile Academy
Price: 19.00 USD
Availability: Discontinued

2 Hours

$19.00

You save -375%

20 Lessons (2h)

Introduction and Installation
Installing MySQL5:33
Showing, Creating, and Using Databases2:46
Creating Tables, Inserting and Showing Data6:26
MySQL Data Types12:47
Creating an Auto Incrementing Primary Key8:06
MySQL Basic Query Statements
Describe Table Syntax3:59
Loading SQL Files into MySQL6:55
Select Query Syntax Introduction6:34
Select Query Demo5:16
MySQL Advance Statements
Update Query Syntax3:15
Mathematical Operations6:06
Distinct, Count, and Group by4:02
Table Relationships7:47
Intro to Joins5:55
MySQL Advanaced Statements Part 2
The Delete Query4:36
Types of Joins6:04
Joins Demo4:36
Creating and Using Views2:43
Setting up a Many to Many Relationship4:36
Demo of Many to Many Relationship6:32

DescriptionInstructorImportant DetailsRelated Products

A Practical, “How-To" Approach to Working with MySQL

EDUmobile AcademyEDUmobile Academy 4.2/5 Instructor Rating: ★ ★ ★ ★ ★ ★

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.

EDUmobile Academy was founded in 2008 when smartphones 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.

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, this course takes a practical “how-to” approach to working with data.

Learn to create databases & tables with 20 lectures & 2 hours of instruction
Add data to a table with INSERT
Read a table with SELECT
Study how to use WHERE to filter data
Use ORDER BY to sort data
Read from multiple tables with JOINs
Change data in a table with UPDATE
Remove one or more rows of data from a table with the DELETE query
Use a text file to load a database schema

Specs

Important Details

Length of time users can access this course: lifetime
Access options: web streaming, mobile streaming
Certification of completion not included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: beginner
Have questions on how digital purchases work? Learn more here

Requirements

Internet required

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

Your Cart

Your cart is empty. Continue Shopping!

Processing order...