Learning MySQL5 - An Easy Way To Master MySQL
4.4 (106 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7,573 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learning MySQL5 - An Easy Way To Master MySQL to your Wishlist.

Add to Wishlist

Learning MySQL5 - An Easy Way To Master MySQL

Learn MySQL 5 With This Hands-On Tutorial Course. Comes Complete With Verifiable Certification of Completion
4.4 (106 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7,573 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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

Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 90 Lectures Collapse All 90 Lectures 06:17:33
+
Installing And Configuring MySQL
12 Lectures 36:27

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
+
Connecting To MySQL And Creating Your First Database
7 Lectures 23:23
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
+
Introducing MySQL's Data Types
10 Lectures 36:19
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
+
Primary And Foreign Keys
5 Lectures 24:57
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
+
Introducing phpMyAdmin, MySQL Workbench, SQLyog
10 Lectures 52:12
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
+
Creating, Retrieving, Updating And Deleting Data
11 Lectures 45:29
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
+
Using String, Numeric, Temporal And Stored Functions
8 Lectures 43:59
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
+
Introducing Subqueries
2 Lectures 12:58
0901 Subqueries Intro
02:40

0902 Subqueries
10:18
+
Introducing SQL Joins
3 Lectures 21:11
1001 SQL Joins
01:43

1002 The Inner Join
11:52

1003 The Left Join
07:36
4 More Sections
About the Instructor
Infinite Skills
4.4 Average rating
38,098 Reviews
689,255 Students
331 Courses
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.