Learning MySQL5 - An Easy Way To Master MySQL

Learn MySQL 5 With This Hands-On Tutorial Course. Comes Complete With Verifiable Certification of Completion
  • Lectures 91
  • Video 7 Hours
  • Skill level all level
  • 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 91 lectures and 6.5 hours of content!

Curriculum

Section 1: Introducing The Relational Database
Working Files - Download These First
Text
0101 What Is A Relational Database
01:22
0102 The Database Hierarchy
02:31
0103 Table Relations
02:38
0104 The Structured Query Language
01:25
Text
Instructions on how to obtain your Certificate of Completion for this Infinite Skills course. All Users of this course are eligible for a Certificate of Completion. Each certificate is issued with a unique number which allows verification that the user has undertaken the course listed. In order to o…
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
1302 MySQL Privilege Management Walkthrough
08:58
Section 14: Using PHP And MySQL
1401 Introduction to PHP and MySQL
05:33
1402 Querying Your MySQL Database With PHP
12:50

Instructor Biography

O'Reilly Media , High Quality Training

O'Reilly spreads the knowledge of innovators through its technology books, online services, magazines, research, and tech conferences. Since 1978, O'Reilly has been a chronicler and catalyst of leading-edge development, homing in on the technology trends that really matter and galvanizing their adoption by amplifying "faint signals" from the alpha geeks who are creating the future. An active participant in the technology community, O'Reilly has a long history of advocacy, meme-making, and evangelism.

Reviews

Average Rating
3.9
Details
  1. 5 Stars
    9
  2. 4 Stars
    3
  3. 3 Stars
    4
  4. 2 Stars
    0
  5. 1 Stars
    2
    • Tracy Blount

    Don't waste your money

    I this on a Groupon deal for $99. I thought I could learn the basic of programming and SQL. All I learned was how to listen to someone talk (not a good instructor).

    • Emily Ridder

    Helped me to realize SQL really was not so intimidating.

    • Todd Pigram

    Great course for a beginner

    This course really increased my knowledge of MySQL. This is great as at this stage of my career, I now have to support a MySQL database. Highly recommended!

    • Martin Robinson

    Another great course!

    • LarryB

    Good beginner MySQL or review for those familiar with other DB's.

What you get with this course

30 day money back guarantee

Lifetime access

Available on desktop, iOS and Android

Certificate of completion

Join the biggest student community

5,400,000

Hours of video content

21,000,000

Course enrollment

6,300,000

Students

Ready to start learning?
Preview this course