by Mashrur Hossain, Codestars by Rob Percival | Released December 2018 | ISBN: 9781789953053

MySQL: Learn how to use MySQL and PHP to build Reports and work with Databases for Web ApplicationsAbout This VideoLearn to build reports and web applications using MySQL and PHPEstablish a strong foundation for databases and SQLIn DetailThis 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 moreThe code bundle for this video course is available at https://github.com/PacktPublishing/The-Complete-MySQL-Developer-Course Show and hide more

1. Chapter 1 : Introduction to the course and MySQL
   • Introduction 00:01:19
   • Development environment overview 00:01:35
   • Sign up for cloud based IDE for development 00:13:40
2. Chapter 2 : Creating Databases and Introduction to Queries
   • Power of Databases 00:01:55
   • Create a Database/Schema 00:07:03
   • Intro to tables and conventions used 00:04:46
   • Working with tables 00:12:48
   • Inserting rows of data 00:11:50
   • Select 00:02:58
   • Concat and substring 00:10:40
   • Homework challenge - bowling scores! 00:03:08
   • Solution - bowling score challenge 00:10:54
   • Alternate method of homework solution – script 00:04:03
   • MySQL, Oracle, SQL Server 00:03:23
   • Limit, order by and distinct 00:09:14
   • Count, like and group by 00:07:47
   • Min and max 00:06:41
   • Code challenge project - create a new report 00:11:00
3. Chapter 3 : Logical operators and dates
   • Data types in MySQL 00:05:21
   • Where and not equal 00:05:20
   • Comparison operators 00:07:10
   • Or 00:02:06
   • Null and blanks 00:08:29
   • Case statements 00:03:28
   • Dates and times 00:06:38
   • Date, time and math 00:13:28
   • Section 3 final project - Create a report on birthdays 00:19:35
4. Chapter 4 : Update and delete rows
   • Update 00:05:33
   • Update based on comparison 00:10:33
   • Delete 00:02:27
5. Chapter 5 : Multiple tables and JOINS
   • Primary keys, foreign keys 00:05:44
   • Data prep for joins 00:11:08
   • Joins and aliases 00:08:22
   • More about joins 00:12:40
   • Inner, Left, Outer, Right joins 00:04:28
   • Left outer joins 00:07:59
   • Fix a bad join challenge 00:04:15
   • Subselects 00:06:54
   • More subselects 00:08:36
   • Section 5 - Final Project Part 1 00:12:39
   • Section 5 - Final Project Part 2 00:04:37
6. Chapter 6 : Web apps – Data collection from a survey
   • Introduction to Web App Development 00:08:10
   • HTML and CSS 00:02:34
   • Start form collector project 00:13:28
   • Add styling to form 00:08:01
   • CREATE TABLE IF NOT EXISTS 00:06:37
   • Config and other php 00:13:52
   • Complete receiver 00:15:21
   • Start SQL Functons 00:12:40
   • Preview and understand steps taken for web app 00:15:45
   • Add browser display 00:09:55
   • Project - Convert to poll! 00:04:39
7. Chapter 7 : CRUD and PHP
   • CRUD – Introduction 00:14:49
   • Create action 00:17:12
   • Read 00:10:00
   • Update action 00:20:00
   • Delete action 00:12:14
8. Chapter 8 : Authentication with PHP and MySQL
   • Introduction to authentication 00:10:11
   • Complete user sign-up 00:09:46
   • Login users 00:12:18
   • Enforce log in for app 00:07:50
   • Sessions 00:17:16
9. Chapter 9 : Challenge section - Build a WebAdmin site
   • Challenge section intro and get started 00:03:23
   • Challenge section project day 2 00:01:34
   • Project day 3, 4 and 5 00:02:34
   • Project day 6, 7 and completion 00:01:46
10. Chapter 10 : Deploy to production
    • Deploy to production using a hosting service 00:01:27
11. Chapter 11 : Stored Procedures and Scheduled jobs
    • Thank you 00:00:52
Show and hide more