EDUmobile Academy – MySQL Database Development for Beginners

Name: EDUmobile Academy - MySQL Database Development for Beginners
Availability: InStock

$10.00

Instant Download: You will receive a download link via your order email immediately
Should you have any questions, please contact us: [email protected]

Category: IT & Technology Tags: EDUmobile Academy, EDUmobile Academy - MySQL Database Development for Beginners, MySQL Database Development for Beginners

Description
Reviews (0)

EDUmobile Academy – MySQL Database Development for Beginners

A Practical “how-to” Approach to Working with MySQL

MySQL is the fastest growing open-source relational database management system with 100 million downloads till date.

It is a popular choice of database for use in web applications and is currently used by many large websites, including Facebook, Twitter, Wikipedia, Flickr, YouTube, and a ton of other top sites!

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 you’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!

Your Instructor(s)

EDUmobile Academy

EDUmobile Academy developshigh 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.

Course Curriculum

Introduction and Installation

Installing MySQL (5:33)
Showing, Creating, and Using Databases (2:46)
Creating Tables, Inserting and Showing Data (6:26)
MySQL Data Types (12:47)
Creating an Auto Incrementing Primary Key (8:06)

MySQL Basic Query Statements

Describe Table Syntax (3:58)
Loading SQL Files into MySQL (6:55)
Select Query Syntax Introduction (6:34)
Select Query Demo (5:16)

MySQL Advance Statements

Update Query Syntax (3:15)
Mathematical Operations (6:06)
Distinct, Count, and Group by (4:02)
Table Relationships (7:47)
Intro to Joins (5:55)

MySQL Advanaced Statements Part 2

The Delete Query (4:36)
Types of Joins (6:04)
Joins Demo (4:36)
Creating and Using Views (2:43)
Setting up a Many to Many Relationship (4:36)
Demo of Many to Many Relationship (6:32)

Proof Content

Sale Page: https://portal.edufyre.com/p/mysql-database-development-for-beginners
Archive: https://archive.ph/wip/OhV8F

Delivery Method

– After your purchase, you’ll see a View your orders link which goes to the Downloads page. Here, you can download all the files associated with your order.

– Downloads are available once your payment is confirmed, we’ll also send you a download notification email separate from any transaction notification emails you receive from imcourse.biz.

– Since it is a digital copy, our suggestion is to download and save it to your hard drive. In case the link is broken for any reason, please contact us and we will resend the new download link.

– If you cannot find the download link, please don’t worry about that. We will update and notify you as soon as possible from 8:00 AM – 8:00 PM (UTC+8).

Thank You For Shopping With Us!