PHP for Beginners 2020 Part 2: PDO, MySQL, phpMyAdmin - learn PHP

Link to this course(special discount)
PHP for Beginners 2020 Part 2: PDO, MySQL, phpMyAdmin - learn PHP
What you will learn in this course ?
What you'll learnCreate a databaseCreate database tablesPopulate a database table manually via phpMyAdminPopulate a database table via a CSV filePopulate a database table via a SQL dumpConnect to a database using a PHP PDO connectionUnderstand the CRUD acronymCreate records in a database table via PHPRead records from a database table via PHPUpdate records in a database table via PHPDelete records from a database table via PHPUse HTML forms to create, read, update and delete recordsUse Bootstrap to style forms and tablesShow moreShow less
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 STARSSTUDENT 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 STARSSTUDENT 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 phpMyAdminuse a SQL dump to create a MySQL database table and populate ituse a CSV file to populate a MySQL database 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 HTML form 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 BootstrapIMPORTANT: Please read carefullyYou are free to use ANY suitable development environment including the one that you are already using (if any and if suitable). Otherwise, I highly recommend using CodeAnywhere OR Visual Studio Code with MAMP to write your PHP code.  However, please note that CodeAnywhere is a PAID option whereas Visual Studio Code and MAMP are FREE.  Again, please note that using either is OPTIONAL.If you have never coded PHP before then you may not be aware that the code needs to be run by the server engine prior to being displayed on your browser as HTML.  You therefore need to set up your server environment correctly. If you do not have experience of setting up a server environment then simply use CodeAnywhere.  I realise that for some students this may seem like a daunting process and therefore I am offering an 'onboarding' conference call if you would like 1-1 support.  For 99% of users this is not required but I think that having the security of knowing that someone is there to support you is important.ZOOM or Webex Meeting: I am more than happy to arrange a time where I can help you set up CodeAnywhere and/or Visual Studio Code if you feel you need the additional support.  Having the 1-1 support is useful in getting you up and running quickly if you are new to coding.  Just send me a private message.Due to the huge number of possible platforms and editors I cannot offer support for third party development environments.  However, I will happily support you if using CodeAnywhere as it is the edito