Learning MySQL5 - An Easy Way To Master MySQL

Learn MySQL 5 With This Hands-On Tutorial Course. Comes Complete With Verifiable Certification of Completion

Video Error

We tried several times to play your video but there was an unforeseen error. We have notified our engineers.

Visit https://helpx.adobe.com/flash-player.html to check that Flash is enabled on your browser.

With Flash enabled, please try again in a few minutes or contact support.

  • Lectures 90
  • Video 6.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

Course Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.

MySQL is the world's most popular relational database solution used in businesses and independent projects, with thousands of new developers and users coming on board every day. Because it continues to evolve and integrate into the biggest technologies on the web, there has never been a better time to learn, and this hands-on MySQL 5 tutorial course makes it easy. With a step-by-step approach tailored for beginners, course author Jason Gilmore introduces the fundamental concepts underlying relational databases and helps you learn how to build your own functional database and manage it using standard techniques and tools. You'll get 91 lessons taking you from MySQL installation and configuration through learning and using different data types, retrieving and filtering data, working with functions, performing backup and security tasks and more. No prior experience is needed. Matching work files are included so that you can follow the course point by point through the development process.


What You Will Learn

- The basic building blocks of relational databases and how they apply, including strings, numerical data types, primary and foreign keys, functions and queries.
- How to install and set up a usable MySQL server on Windows.
- How to access, modify and manage your data within a MySQL database.
- How to use relational databases to solve problems in business and software or web development.


Who Should Take This Course

- Anyone who wants to learn to create functional, flexible databases for archival, organization or software development purposes.
- Users moving from software-centered solutions such as Microsoft Access or FileMaker looking for a greater degree of control.
- Anyone who wants to increase their employment or promotion prospects by learning a current, relevant technology standard.


What People Are Saying

"I thought MySQL was over my head...the books I'd bought didn't help but these videos have already made a huge difference in what I can do."
- Darrel Nixa

"Jason is awesome as a teacher, and I can't say enough how helpful having the files were in following along."
- Rachel Black

"The section on optimization is where it really came together for me...there's some serious power here if you've got a lot of data to work with."
- Tom Leippi

What am I going to get from this course?

  • Over 90 lectures and 6.5 hours of content!

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introducing The Relational Database
Working Files - Download These First
Preview
Article
0101 What Is A Relational Database
Preview
01:22
0102 The Database Hierarchy
Preview
02:31
0103 Table Relations
Preview
02:38
0104 The Structured Query Language
Preview
01:25
0106 Conclusion
01:07
Section 2: Installing And Configuring MySQL
0201 Introduction To MySQL
03:21
0202 MySQL Features
09:18
0203 Installing MySQL - Introduction
00:35
0204 Downloading MySQL
01:54
0205 Installing MySQL - Part 1
03:17
0206 Installing MySQL - Part 2
01:54
0207 Configuring MySQL
05:19
0208 Setting The System Path - Part 1
01:04
0209 Setting The System Path - Part 2
02:48
0210 Installing MySQL On The Mac
02:47
0211 The Sakila Database
01:38
0212 Installing The Sakila Database
02:32
Section 3: Connecting To MySQL And Creating Your First Database
0301 Introduction To MySQL Connections
00:48
0302 Role Of The Root User
01:42
0303 Logging In For The First Time
04:40
0304 Change The Root Password
01:25
0305 Creating Your First Database
06:43
0306 Creating Your First User Account
04:17
0307 Creating Your First Table
03:48
Section 4: Introducing MySQL's Data Types
0401 Intro To Data Types
02:53
0402 String Data Types - Part 1
04:30
0403 String Data Types - Part 2
02:07
0404 Data Attributes
02:14
0405 Customers Table Revised
03:36
0406 Numerical Data Types - Part 1
03:30
0407 Numerical Data Types - Part 2
01:45
0408 Numerical Data Attributes
02:38
0409 Date And Time Types
08:46
0410 Multiple Timestamp Columns In Table
04:20
Section 5: Primary And Foreign Keys
0501 Primary Keys - Part 1
02:41
0502 Primary Keys - Part 2
06:27
0503 Creating A Primary Key
02:42
0504 Foreign Key Introduction
08:44
0505 Create Foreign Key
04:23
Section 6: Introducing phpMyAdmin, MySQL Workbench, SQLyog
0601 Graphical MySQL
04:54
0602 phpMyAdmin Intro
09:59
0603 MySQL Workbench Intro
02:01
0604 MySQL Workbench SQL Development Intro
08:39
0605 MySQL Workbench Data Modeling Intro
09:03
0606 MySQL Workbench Server Administration Intro
02:35
0607 SQLyog Introduction
01:26
0608 SQLyog Creating A Database
05:00
0609 SQLyog Navigating And Modifying Data
03:33
0610 SQLyog Scheduling Backups
05:02
Section 7: Creating, Retrieving, Updating And Deleting Data
0701 Performing CRUD Operations
01:58
0702 Creating Data
06:29
0703 Retrieving Data
05:04
0704 Ordering Results
02:28
0705 Filtering Results
04:51
0706 Grouping Results
07:06
0707 Removing Duplicate Rows
01:31
0708 The LIKE Clause
03:54
0709 The LIMIT Clause
03:34
0710 Updating Data
05:31
0711 Deleting Data
03:03
Section 8: Using String, Numeric, Temporal And Stored Functions
0801 Introduction To Functions
00:56
0802 String Functions
09:55
0803 Numeric Functions
05:21
0804 Temporal Functions - Introduction
02:26
0805 Temporal Functions - Example
11:13
0806 Stored Functions - Part 1
01:18
0807 Stored Functions - Part 2
06:32
0808 Stored Functions - Part 3
06:18
Section 9: Introducing Subqueries
0901 Subqueries Intro
02:40
0902 Subqueries
10:18
Section 10: Introducing SQL Joins
1001 SQL Joins
01:43
1002 The Inner Join
11:52
1003 The Left Join
07:36
Section 11: Optimizing MySQL
1101 Optimizing MySQL
00:49
1102 Column Indexing
01:39
1103 Column Indexing Explained
08:14
1104 Optimizing The MySQL Configuration
07:17
1105 Query Caching
01:17
1106 Query Caching Explained
03:48
1107 Optimizing MySQL Conclusions
00:34
Section 12: Importing, Exporting And Backing Up MySQL Databases
1201 Introduction To MySQL Data Tasks
00:53
1202 Exporting Data With MySQL Workbench
05:38
1203 Importing Data With Phpmyadmin
02:39
1204 Automatically Backing Up Your MySQL Database
01:21
1205 Automating Your Backups With mysqldump And cron
09:05
Section 13: Managing MySQL User Privileges
1301 Managing MySQL Privileges
00:59

Instructor Biography

Infinite Skills, High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Ready to start learning?