MySQL Fundamentals

Learn to create database driven web applications using MySQL

Created by:

YouAccel

Lectures:

28

Duration:

Skill Level:

Beginner

Requirements:

PC or MAC

Language:

English

Students Enrolled:

9,001

Rating:

(69)

Certification Type:

Completion Certificate

Price:


Course Description

This course is part-eight of the nine-part Web Development Masterclass Series.

Students learn to integrate and administer MySQL databases as part of PHP web application development.

The course begins with an in-depth look into PhpMyAdmin to create, delete and modify databases. We also explore security considerations and user privileges.

Next, students learn to build connections to existing databases in PHP, and execute commands using several essential SQL statements.

Course Prerequisites: Internet and Web Development Fundamentals, HTML Fundamentals, CSS Fundamentals, JavaScript Fundamentals, jQuery Fundamentals, Bootstrap Fundamentals, PHP Fundamentals

This course is part-eight of the nine-part Web Development Masterclass Series.

Students learn to integrate and administer MySQL databases as part of PHP web application development.

The course begins with an in-depth look into PhpMyAdmin to create, delete and modify databases. We also explore security considerations and user privileges.

Next, students learn to bui...

Curriculum
Section 1: Introduction
1 Course Objectives 00:00:37
Section 2: MySQL Database Integration
1 Introduction to Databases 00:02:40
2 Introduction PhpMyAdmin 00:02:36
3 PhpMyAdmin Interface Overview 00:01:13
4 MySQL Security and Root Superuser 00:05:03
5 MySQL Creating a Database and Table 00:05:24
6 MySQL Creating a New User 00:05:34
7 MySQL Database and Table Specific Privileges 00:03:05
8 MySQL Modifying and Deleting a Table 00:04:31
9 MySQL Modifying and Deleting a Database 00:04:08
10 Introduction to SQL 00:01:35
11 SQL Statements in PhpMyAdmin 00:04:05
12 Connect to MySQL Database using PHP 00:05:03
13 MySQL Database - Import Data 00:01:43
14 SQL Select 00:02:27
15 SQL Distinct Keyword 00:01:45
16 SQL Where Clause 00:01:40
17 SQL And Operator 00:01:43
18 SQL Or Operator 00:01:01
19 SQL Order By 00:01:37
20 MySQL Insert Into 00:06:29
21 MySQL Get Last ID 00:01:27
22 MySQL Insert Multiple Records 00:01:44
23 MySQL Prepared Statements 00:02:45
24 MySQL Delete Records 00:07:49
25 PHP Header Function 00:01:17
26 PHP Isset 00:02:35
27 MySQL Update Records 00:07:07
Course Reviews
image
Student

Carmen Quinette
6 months ago

image
Student

Enzo Urling
6 months ago

image
Student

Codi Wylie
7 months ago

image
Student

Latashia Angel
3 years ago

Excellent course.

Solid lessons that are very well organized. The instructors are easy to follow and made the class enjoyable. I would highly recommend this course.
image
Student

Odell Sauer
3 years ago

Great.

The course is very clear and organized. Well worth the price. Thank you!
image
Student

Gracie Cardwell
3 years ago

All good.

I had some issues with this course because I did not know how to setup a testing server. I would agree with some of the others here - you should take the prerequisites before jumping into this course. Even if you have a bit of experience with mysql, you still need to know how to setup wamp and lamp stack on a virtual server in order for mysql to work! I hadn?t done that before and it through me off. The instructors are extremely helpful and respond to questions within minutes.
image
Student

Bianca Villarreal
3 years ago

Excellent.

This was a great class. The information was very easy to understand and I will definitely continue with the other parts of the masterclass series.
image
Student

Blythe Kimball
3 years ago

Fantastic course!

The course is very fun and motivating. It will definitely get you up and running with mysql and php. I had a bit of prior knowledge working as a web developer which helped. If you are a beginner I would recommend taking the other parts of the course where they teach you how to install wamp/mamp. If you take this course without the pre-requisites you will get stuck!
image
Student

Codi Wylie
3 years ago

Simple.

The lessons are simple and easy to follow. Highly recommend.
image
Student

Charmaine Dyer
3 years ago

Great.

I really appreciate that the instructor uses actual databases when teaching the material. They go over all the key areas like phpmyadmin, mysql and executing sql commands through php. Could not have asked for more!
image
Student

Ludie Nealy
3 years ago

Superb.

Very detailed instructions and great pace. It was very encouraging as a beginner to be able to follow along with the lectures. I have taken other courses which taught the same content but left me confused. Thank you for this learning opportunity!
image
Student

Hollis Golden
3 years ago

Good course.

This course is entertaining and informative. I have already taken all the other parts of the series and each one has left me eagerly waiting for more. The instructor does a fantastic job with the videos. I highly recommend the course.
image
Student

Yajaira Hopper
3 years ago

Nice.

Great tutorials that are easy to understand. Thank you!
image
Student

Deloris Murry
3 years ago

Clean.

Great course for beginners. The lessons all come with sample data sets which makes learning much easier. The instructor is also very helpful in case you have issues understanding the material. The explanations are thorough and I really enjoyed the training.
image
Student

Santa Whatley
3 years ago

Needs more.

This course needs more examples so we can try on our own. It was a good introduction and they do cover all the concepts, but for a beginner it?s hard to put it all together without some real-world demonstrations. I would recommend this course if you plan on taking more advanced courses afterwards. Most employers would require you to have much more knowledge than what is taught here.
image
Student

Rosalina Gavin
3 years ago

Great.

Learned some very useful information in a short time. I now feel confident putting this as a skill on my resume to apply for jobs. Looking forward to the remaining parts of the series and earning my certificate!
image
Student

Ellamae Barela
3 years ago

Amazed.

Fantastic course for anyone who is serious about learning MySQL. The course is very interactive and easy to follow. Highly recommend!
image
Student

Savannah Parent
3 years ago

Awesome.

This course is worth every penny! They cover just about everything you need to know to create and update database records through php.
image
Student

Clarissa Lavoie
3 years ago

Good.

Had fun with this course. They teach a lot of material within a short time. It?s also great that they explore PhpMyAdmin for database administration.
image
Student

Dorathy Glaser
3 years ago

Excellent course!

This is a great introduction into MySQL. I have been trying to understand how to connect and manage records through php for quite some time. Took a bunch of courses but it wasn?t sinking in. The instructor makes learning very easy. The lessons include real demonstrations so all you have to do is follow along! Some courses focus to much on theory. I found these courses to be a great balance between theory and and practical hands-on exercises.


Copyright © 2019 YouAccel.com.