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. Thelessons are kept short and to the point. STUDENTREVIEW: “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 STARSSTUDENTREVIEW: “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 STARSSTUDENTREVIEW: “An amazing course. Very good for beginners.” 5 STARSThe 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 adatabase using phpMyAdminuse a SQL dump to create a MySQL database table and populate ituse a CSV file to populate a MySQLdatabase tablechange database user permissions using phpMyAdminconnect to a MySQL database using a PDO connectionunderstand the acronym CRUDcreate, read, update and delete records using phpMyAdmincreate, read, update and delete records using PHPcreate an input form using HTMLcreate, read, update and delete records by using a HTMLform and PHPuse Bootstrap to style the input formuse Font Awesome to add some icons for edit and delete actionspresent database table records in a table and style it using BootstrapTHEDEVELOPMENTENVIRONMENTIMPORTANT: Please read carefullyYou 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 Iwill 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 ANYsuitable development environment of your choosing. MYPROMISESTOYOUAs a registeredteacher (yes, Iteach in a real classroom every day), Istrongly believe it is my job to ensure you feel totally supported when taking my classes. Itherefore promise the following: to respect you as a student and individual with your own learning needsto be courteous and polite in our interactionsto answer your questions about the course content promptlyto fix any issues you may encounter with the lessonsto respondpromptly to feedbackIreally do look forward to welcoming you to this course. Iam confident you will enjoy the approach of learning what each line of code actually means. Join the course today.
