[Packtpub] The Complete MySQL Developer Course

MySQL: Learn how to use MySQL and PHP to build reports and work with databases for web applications

Video Description

This course will take you on a journey where you’ll establish the strongest possible foundation in database development by learning how to use MySQL (the most popular open source database in the world), write queries, create reports, build web applications, and incorporate MySQL as the database layer. Turn your development dreams into a reality by taking this course and putting a check mark next to your growing development skillset. You will learn to Set up MySQL, Work with online IDE’s, Create databases and queries, Use logical operators, Manipulate tables/rows/data, Understand how joins work and use them, Create admin features, Implement deployment production and a lot more.

Style and Approach

This course is a seamless blend of text, videos, and code examples that will help you learn efficiently as you progress through the course. You’ll start with the absolute basics (installing and creating databases) and work your way through building web applications with MySQL as the database. By the end of this course, you’ll be able to apply what you’ve learnt and do virtually anything you want with databases.

What You Will Learn

• Build web applications using MySQL and PHP
• Establish a solid foundation for databases and SQL
• Learn how joins work and use them
• Build web applications with PHP, HTML, and CSS, with MySQL as the database layer
• Perform CRUD operations and authentication from web applications
• Create admin features
• Implement deployment production

Table of Contents

• INTRODUCTION TO THE COURSE AND MYSQL
• CREATING DATABASES AND INTRODUCTION TO QUERIES
• LOGICAL OPERATORS AND DATES
• UPDATE AND DELETE ROWS
• MULTIPLE TABLES AND JOINS
• WEB APPS – DATA COLLECTION FROM A SURVEY
• CRUD AND PHP
• AUTHENTICATION WITH PHP AND MYSQL
• CHALLENGE SECTION – BUILD A WEBADMIN SITE
• DEPLOY TO PRODUCTION
• STORED PROCEDURES AND SCHEDULED JOBS

Author – Mashrur Hossain, Rob Percival
Released Date – December 13, 2018
Duration – 9 hours 16 minutes

Size: 1.89 GB

Download Now

https://www.packtpub.com/web-development/complete-mysql-developer-course-video.