Video description
MySQL: Learn how to use MySQL and PHP to build Reports and work with Databases for Web Applications
About This Video
- Learn to build reports and web applications using MySQL and PHP
- Establish a strong foundation for databases and SQL
In Detail
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
The code bundle for this video course is available at https://github.com/PacktPublishing/The-Complete-MySQL-Developer-Course
Table of Contents
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
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
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
Chapter 4 : Update and delete rows
Update
00:05:33
Update based on comparison
00:10:33
Delete
00:02:27
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
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
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
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
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
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
Chapter 10 : Deploy to production
Deploy to production using a hosting service
00:01:27
Chapter 11 : Stored Procedures and Scheduled jobs
Thank you
00:00:52