Check out just a few key highlights for:
Join a community of other students taking this course.
Each lecture is recorded in HD 1920x1080p with clear audio.
All courses are rated by fellow community members.
All YouAccel courses are recorded and produced in 1920x1080p HD Quality.
Have a question? Contact our support team at any time using our chat feature, or built-in messaging console.
All YouAccel courses come with a Certificate of Completion. This helps Showcase your proficiency in a subject to prospective employers.
All YouAccel courses include lifetime on-demand access. Class lecture are also available for offline viewing.
Join a community of over 600,000 learners. Connect & Communicate through YouAccel's networking tools.
YouAccel's integration with Indeed makes it easy to search through thousands of jobs and apply with just a click.
A comprehensive list of all sections & lectures for this course can be found below.
Course Objectives - 00:37 [Play]
Introduction to Databases - 02:40 [Play]
Introduction PhpMyAdmin - 02:36
PhpMyAdmin Interface Overview - 01:13
MySQL Security and Root Superuser - 05:03
MySQL Creating a Database and Table - 05:24
MySQL Creating a New User - 05:34
MySQL Database and Table Specific Privileges - 03:05
MySQL Modifying and Deleting a Table - 04:31
MySQL Modifying and Deleting a Database - 04:08
Introduction to SQL - 01:35
SQL Statements in PhpMyAdmin - 04:05
Connect to MySQL Database using PHP - 05:03
MySQL Database - Import Data - 01:43
SQL Select - 02:27
SQL Distinct Keyword - 01:45
SQL Where Clause - 01:40
SQL And Operator - 01:43
SQL Or Operator - 01:01
SQL Order By - 01:37
MySQL Insert Into - 06:29
MySQL Get Last ID - 01:27
MySQL Insert Multiple Records - 01:44
MySQL Prepared Statements - 02:45
MySQL Delete Records - 07:49
PHP Header Function - 01:17
PHP Isset - 02:35
MySQL Update Records - 07:07
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.
All course reviews are written by students who have completed the course or are currently enrolled.
Solid lessons that are very well organized. The instructors are easy to follow and made the class enjoyable. I would highly recommend this course.
The course is very clear and organized. Well worth the price. Thank you!
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.
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.
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!
The lessons are simple and easy to follow. Highly recommend.
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!
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!
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.
Great tutorials that are easy to understand. Thank you!
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.
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.
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!
Fantastic course for anyone who is serious about learning MySQL. The course is very interactive and easy to follow. Highly recommend!
This course is worth every penny! They cover just about everything you need to know to create and update database records through php.
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.
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.
YouAccel is currently teaching 87 courses. All courses are currently open for enrollment.
YouAccel currently has 567,846 global enrollments across 87 courses that are active on the platform.
YouAccel has an average rating of 4.5/5 stars, across 87 courses.
YouAccel is a leading provider in online training, offering courses across numerous industries from IT and Development to Business, Marketing, Design, and Productivity.
The e-learning experience provided by YouAccel is Dynamic. Each course is streamed in High Definition with corresponding assignments, quizzes, and exams that are delivered and graded electronically. All YouAccel courses are taught by certified educators that have numerous years of work experience in the field for which they provide instruction.
The courses can be taken at one's own pace and are offered at several levels including beginner, intermediate and advanced. Online courses are also compatible with any mobile device for the ultimate in convenience.
Taking the experience to a new personalized level, live communication with instructors is available through an online messaging console. All courses come with a certificate of completion and no age restrictions apply.
You have nothing to lose. Give the course a try. If it's not what you expected, get a full refund within 30 days of purchase.