IIRF Online > Development > Database Design & Development > MySQL > The Complete MySQL Developer Course
The Complete MySQL Developer Course by Udemy
MySQL: Learn how to use MySQL and PHP to build Reports and work with Databases for Web Applications
Course Highlights
- Apply for jobs as junior MySQL developers
- Build web applications using MySQL and PHP
- Establish a solid foundation for databases and SQL
Skills you will learn!
Curriculum
7 Topics
Introduction
Introduce yourself and learn how to get FREE LIVE HELP!
Development environment overview
IMPORTANT: Development Environment Setup - Overview
Windows - Install/setup MySQL users and create databases
Mac - Install/setup MySQL users and create databases
AWS Cloud - Setup MySQL users and create databases
27 Topics
Power of Databases
Create a Database/Schema
Create a Database/Schema - Text lecture
Intro to tables and conventions used
Working with tables
Working with tables - Text lecture
Inserting rows of data
Inserting rows of data - Text lecture
Select
Select - Text lecture
Concat and substring
Concat and substring - Text lecture
Homework challenge - bowling scores!
Homework challenge - Text version
Solution - bowling score challenge
Solution - Text
Alternate method of homework solution - script
Alternate method of running queries - script - Text version
MySQL Oracle SQL Server
Limit order by and distinct
Limit order by and distinct - Text lecture
Count like and group by
Count like and group by - Text lecture
Min and max
Min and max - Text lecture
Code challenge project - create a new report
Code challenge project - Text version
18 Topics
Data types in MySQL
Data types in MySQL - Text lecture
Where and not equal
Where and not equal - Text lecture
Comparison operators
Comparison operators - Text lecture
Or
Or - Text lecture
Null and blanks
Null and blanks - Text lecture
Case statements
Case statements - Text lecture
Dates and times
Dates and times - Text lecture
Date time and math
Date time and math - Text lecture
Section 3 final project - Create a report on birthdays
Text solution to final project on birthday reporting
6 Topics
Update
Update - Text lecture
Update based on comparison
Update based on comparison - Text lecture
Delete
Delete - Text lecture
22 Topics
Primary keys foreign keys
Primary and foreign keys - Text lecture
Data prep for joins
Data prep for joins - Text lecture
Joins and aliases
Joins and aliases - Text lecture
More about joins
More about joins - Text lecture
Inner Left Outer Right joins
Inner Left Outer and Right joins - Text lecture
Left outer joins
Left outer joins - Text lecture
Fix a bad join challenge
Fix a bad join challenge - Text lecture
Subselects
Subselects - Text lecture
More subselects
More subselects - Text lecture
Section 5 - Final Project Part 1
Final Project Part 1 - Text solution
Section 5 - Final Project Part 2
Final Project Part 2 - Text solution
22 Topics
Introduction to Web App Development
HTML and CSS
HTML and CSS - Text lecture
Start form collector project
Project start - Text lecture
Add styling to form
Add styling to form - Text follow-up
Create table
Create table - Text follow-up
Learn php basics
Config and other php
Config and other php - Text follow-up
Complete receiver
Complete receiver - Text follow-up
Start SQL Functons
Start SQL Functions - Text lecture
Preview and understand steps taken for web app
Preview of web app - Text follow-up
Add browser display
Add browser display - Text follow-up
Project - Convert to poll!
Project - Solution text
10 Topics
CRUD - Introduction
CRUD - Intro - Text follow-up
Create action
Create action - Text lecture
Read
Read - Text lecture
Update action
Update action - Text lecture
Delete action
Delete action - Text lecture
10 Topics
Introduction to authentication
Intro to authentication - Text lecture
Complete user sign-up
Complete user sign-up - Text lecture
Login users
Login users - Text lecture
Enforce log in for app
Enforce log in - Text lecture
Sessions
Sessions - Text lecture
5 Topics
Challenge section intro and get started
Challenge section intro - text reference
Challenge section project day 2
Project day 3 4 and 5
Project day 6 7 and completion
2 Topics
Deploy to production using a hosting service
Deploy to production - Text lecture
1 Topic
Database permissions section doc
2 Topics
Stored Procedures and Scheduled jobs section doc
Thank you!
The Complete MySQL Developer Course
Related MySQL Courses
Thank You!
Your review has been submitted successfully.