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.
|Section 1: Introduction|
|Section 2: MySQL Database Integration|
|1||Introduction to Databases||00:02:40|
|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|
|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|
|27||MySQL Update Records||00:07:07|
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.