The Complete MySQL Developer Course

Description

In this course, you will learn:

• Setting up MySQL, working with online IDE's
• Creating databases and queries
• Using logical operators, manipulating tables/rows/data
• How joins work and using them at will
• Building web applications with PHP, HTML and CSS along with MySQL as the database layer
• Performing CRUD and authentication from web applications
• Creating admin features and deploying to production

Syllabus :

• 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​​​​​​​
• Database permissions
• Stored Procedures and Scheduled jobs