You can learn anything on Udemy. Start today with one of our 10,000+ online courses

Learning MySQL5 - An Easy Way To Master MySQL

Learn MySQL 5 With This Hands-On Tutorial Course. Comes Complete With Verifiable Certification of Completion
18 reviews
WHAT'S INSIDE
  • Lifetime access to 91 lectures
  • 6+ hours of high quality content
  • A community of 5200+ students learning together!
  • 60+ discussions
TAUGHT BY
  • Infinite Skills High Quality Training

    InfiniteSkills is a Canadian based company that offers an ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples. The emphasis is on teaching real life skills that are essential in today's commercial environment. All InfiniteSkills.com courses are taught by experts who have a true passion for teaching.

SHARE

Learning MySQL5 - An Easy Way To Master MySQL

Learn MySQL 5 With This Hands-On Tutorial Course. Comes Complete With Verifiable Certification of Completion
18 reviews
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

    • Over 91 lectures and 6.5 hours of content!

CURRICULUM

  • SECTION 1:
    Introducing The Relational Database
  • 1
    Working Files - Download These First
    Text
  • 2
    0101 What Is A Relational Database
    01:22
  • 3
    0102 The Database Hierarchy
    02:31
  • 4
    0103 Table Relations
    02:38
  • 5
    0104 The Structured Query Language
    01:25
  • 6
    How to obtain your Certificate of Completion for this Infinite Skills course.
    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…
  • 7
    0106 Conclusion
    01:07
  • SECTION 2:
    Installing And Configuring MySQL
  • 8
    0201 Introduction To MySQL
    03:21
  • 9
    0202 MySQL Features
    09:18
  • 10
    0203 Installing MySQL - Introduction
    00:35
  • 11
    0204 Downloading MySQL
    01:54
  • 12
    0205 Installing MySQL - Part 1
    03:17
  • 13
    0206 Installing MySQL - Part 2
    01:54
  • 14
    0207 Configuring MySQL
    05:19
  • 15
    0208 Setting The System Path - Part 1
    01:04
  • 16
    0209 Setting The System Path - Part 2
    02:48
  • 17
    0210 Installing MySQL On The Mac
    02:47
  • 18
    0211 The Sakila Database
    01:38
  • 19
    0212 Installing The Sakila Database
    02:32
  • SECTION 3:
    Connecting To MySQL And Creating Your First Database
  • 20
    0301 Introduction To MySQL Connections
    00:48
  • 21
    0302 Role Of The Root User
    01:42
  • 22
    0303 Logging In For The First Time
    04:40
  • 23
    0304 Change The Root Password
    01:25
  • 24
    0305 Creating Your First Database
    06:43
  • 25
    0306 Creating Your First User Account
    04:17
  • 26
    0307 Creating Your First Table
    03:48
  • SECTION 4:
    Introducing MySQL's Data Types
  • 27
    0401 Intro To Data Types
    02:53
  • 28
    0402 String Data Types - Part 1
    04:30
  • 29
    0403 String Data Types - Part 2
    02:07
  • 30
    0404 Data Attributes
    02:14
  • 31
    0405 Customers Table Revised
    03:36
  • 32
    0406 Numerical Data Types - Part 1
    03:30
  • 33
    0407 Numerical Data Types - Part 2
    01:45
  • 34
    0408 Numerical Data Attributes
    02:38
  • 35
    0409 Date And Time Types
    08:46
  • 36
    0410 Multiple Timestamp Columns In Table
    04:20
  • SECTION 5:
    Primary And Foreign Keys
  • 37
    0501 Primary Keys - Part 1
    02:41
  • 38
    0502 Primary Keys - Part 2
    06:27
  • 39
    0503 Creating A Primary Key
    02:42
  • 40
    0504 Foreign Key Introduction
    08:44
  • 41
    0505 Create Foreign Key
    04:23
  • SECTION 6:
    Introducing phpMyAdmin, MySQL Workbench, SQLyog
  • 42
    0601 Graphical MySQL
    04:54
  • 43
    0602 phpMyAdmin Intro
    09:59
  • 44
    0603 MySQL Workbench Intro
    02:01
  • 45
    0604 MySQL Workbench SQL Development Intro
    08:39
  • 46
    0605 MySQL Workbench Data Modeling Intro
    09:03
  • 47
    0606 MySQL Workbench Server Administration Intro
    02:35
  • 48
    0607 SQLyog Introduction
    01:26
  • 49
    0608 SQLyog Creating A Database
    05:00
  • 50
    0609 SQLyog Navigating And Modifying Data
    03:33
  • 51
    0610 SQLyog Scheduling Backups
    05:02
  • SECTION 7:
    Creating, Retrieving, Updating And Deleting Data
  • 52
    0701 Performing CRUD Operations
    01:58
  • 53
    0702 Creating Data
    06:29
  • 54
    0703 Retrieving Data
    05:04
  • 55
    0704 Ordering Results
    02:28
  • 56
    0705 Filtering Results
    04:51
  • 57
    0706 Grouping Results
    07:06
  • 58
    0707 Removing Duplicate Rows
    01:31
  • 59
    0708 The LIKE Clause
    03:54
  • 60
    0709 The LIMIT Clause
    03:34
  • 61
    0710 Updating Data
    05:31
  • 62
    0711 Deleting Data
    03:03
  • SECTION 8:
    Using String, Numeric, Temporal And Stored Functions
  • 63
    0801 Introduction To Functions
    00:56
  • 64
    0802 String Functions
    09:55
  • 65
    0803 Numeric Functions
    05:21
  • 66
    0804 Temporal Functions - Introduction
    02:26
  • 67
    0805 Temporal Functions - Example
    11:13
  • 68
    0806 Stored Functions - Part 1
    01:18
  • 69
    0807 Stored Functions - Part 2
    06:32
  • 70
    0808 Stored Functions - Part 3
    06:18
  • SECTION 9:
    Introducing Subqueries
  • 71
    0901 Subqueries Intro
    02:40
  • 72
    0902 Subqueries
    10:18
  • SECTION 10:
    Introducing SQL Joins
  • 73
    1001 SQL Joins
    01:43
  • 74
    1002 The Inner Join
    11:52
  • 75
    1003 The Left Join
    07:36
  • SECTION 11:
    Optimizing MySQL
  • 76
    1101 Optimizing MySQL
    00:49
  • 77
    1102 Column Indexing
    01:39
  • 78
    1103 Column Indexing Explained
    08:14
  • 79
    1104 Optimizing The MySQL Configuration
    07:17
  • 80
    1105 Query Caching
    01:17
  • 81
    1106 Query Caching Explained
    03:48
  • 82
    1107 Optimizing MySQL Conclusions
    00:34
  • SECTION 12:
    Importing, Exporting And Backing Up MySQL Databases
  • 83
    1201 Introduction To MySQL Data Tasks
    00:53
  • 84
    1202 Exporting Data With MySQL Workbench
    05:38
  • 85
    1203 Importing Data With Phpmyadmin
    02:39
  • 86
    1204 Automatically Backing Up Your MySQL Database
    01:21
  • 87
    1205 Automating Your Backups With mysqldump And cron
    09:05
  • SECTION 13:
    Managing MySQL User Privileges
  • 88
    1301 Managing MySQL Privileges
    00:59
  • 89
    1302 MySQL Privilege Management Walkthrough
    08:58
  • SECTION 14:
    Using PHP And MySQL
  • 90
    1401 Introduction to PHP and MySQL
    05:33
  • 91
    1402 Querying Your MySQL Database With PHP
    12:50

RATING

  • 9
  • 3
  • 4
  • 0
  • 2
AVERAGE RATING
NUMBER OF RATINGS
18

REVIEWS

  • 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.