Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 51 Minute(s)
Language
English
Taught by
Coding Academy
Rating
2 views
Course Overview
Every line of code explained. Learn PHP, PDO, MySQL, phpMyAdmin to create data driven websites. Award winning teacher.
Welcome to PHP, PDO and MySQL for Beginners!
This course is intended for those who wish to develop their understanding and skills in PHP and MySQL in order to develop data driven websites.
Every line of code is explained as I teach. The lessons are kept short and to the point.
STUDENT REVIEW: "Patrick is an excellent, thorough and easy to understand teacher. I bought this course as soon as it was available because I was so impressed with his first course. Thank you Patrick!" 5 STARS
STUDENT REVIEW: "I learned a lot in this "close to real live" education. It was very helpful to get into connection with some important things close to PHP. By taking a look at bootstrap, emmet, SQL and little bit of CSS and other things was very helpful to get an overview of the most important tools and languages around PHP. I really love to listen to and learn from Patrick. He is giving very good and easy to understand comprehensive explanations, he is setting tasks that are a challenge but feasible and he is showing the solutions. By listening to all that and writing the code myself in the tasks I really learned a lot. Great Stuff !" 5 STARS
STUDENT REVIEW: "An amazing course. Very good for beginners." 5 STARS
The unique difference about my courses is that you are given exercises to complete after each section. This enables you to try what you have learnt with my full support. Students who have taken this course appreciate the level of clear explanation and strengthening of their skills.
The course has been developed following years of teaching students in a real classroom environment and watching and analysing their reactions to new concepts. Therefore, each lesson has been designed to quickly help you understand the processes involved in connecting to and actively using databases within websites.
At the end of the course you will be able to:
create a database using phpMyAdmin
use a SQL dump to create a MySQL database table and populate it
use a CSV file to populate a MySQL database table
change database user permissions using phpMyAdmin
connect to a MySQL database using a PDO connection
understand the acronym CRUD
create, read, update and delete records using phpMyAdmin
create, read, update and delete records using PHP
create an input form using HTML
create, read, update and delete records by using a HTML form and PHP
use Bootstrap to style the input form
use Font Awesome to add some icons for edit and delete actions
present database table records in a table and style it using Bootstrap
THE DEVELOPMENT ENVIRONMENT
IMPORTANT: Please read carefully
You are free to use ANY development environment including the one that you are already using (if any). In this course, I show you how to download and install Visual Studio Code and MAMP (both of which are FREE and available for Mac and Windows).
If you are unsure about which code editor option is best for you then I encourage you to contact me and I will be happy to discuss the options with you.
You can also follow this course using your own preferred code editor.
Once again, using Visual Studio Code with MAMP is OPTIONAL. You can use ANY suitable development environment of your choosing.
MY PROMISES TO YOU
As a registered teacher (yes, I teach in a real classroom every day), I strongly believe it is my job to ensure you feel totally supported when taking my classes. I therefore promise the following:
to respect you as a student and individual with your own learning needs
to be courteous and polite in our interactions
to answer your questions about the course content promptly
to fix any issues you may encounter with the lessons
to respond promptly to feedback
I really do look forward to welcoming you to this course. I am confident you will enjoy the approach of learning what each line of code actually means.
Join the course today.
Course Content
- 5 section(s)
- 30 lecture(s)
- Section 1 Introduction
- Section 2 The Basics of phpMyAdmin
- Section 3 Basic CRUD
- Section 4 Using HTML with PHP
- Section 5 Bonus
What You’ll Learn
- Create a database
- Create database tables
- Populate a database table manually via phpMyAdmin
- Populate a database table via a CSV file
- Populate a database table via a SQL dump
- Connect to a database using a PHP PDO connection
- Understand the CRUD acronym
- Create records in a database table via PHP
- Read records from a database table via PHP
- Update records in a database table via PHP
- Delete records from a database table via PHP
- Use HTML forms to create, read, update and delete records
- Use Bootstrap to style forms and tables
Reviews
-
TTheresa Rossi
Code anywhere is completely different so I cannot follow along. Need update.
-
MMasaki Adachi
easy to understand for php and mysql beginner
-
MMary B.
I don't believe it's possible to take a class with Patrick Morrow and not learn something. This class is no exception, however, I'm rather disappointed as I took his other class, PHP for Beginners Part 1, first, which was remarkable. In that course, each line of code was fully explained along with differences and use cases. A good example of this would've been the use cases he offered for different types of loops, which really helped the student to fundamentally understand what they are, what the differences are, and when to use them. In this course, you can exec() or prepare() then execute() with no explanation of the differences or potential use cases for each. It also isn't really explained what PDO is. Those videos read more like a tutorial than a comprehensive education. With that said, where this course shines is in the demonstration of MySQL and phpMyAdmin. He teaches you where to find the different MySQL query structures and how to use them. You will walk away with an understanding of how to populate database tables; create, read, update, and delete records; and more. At the end of the day, I still got my money's worth, but I still believe that there are things that could be improved with this course.
-
FFrank Juel Nielsen
A very good course on PHP, PDO and MySQL for Beginners . I highly recommend this beginners course. Also to take the instructors first course on PHP. The instructor does a very well job. He is a easy to understand teacher and thorough in an non-complicated way. As it say in the course description, every line of code is explained in detail. And that is done without very lengthy videos. Thereby your attention is kept. The videos are mixed with relevant tasks throughout the course. This style is very motivating, so you go on to the very end and achieve a good beginner knowledge.
