The Complete MySQL Developer Course

MySQL: Learn how to use MySQL and PHP to build Reports and work with Databases for Web Applications
The Complete MySQL Developer Course
File Size :
3.40 GB
Total length :
10h 28m

Category

Instructor

Rob Percival

Language

Last update

Last updated 6/2019

Ratings

4.5/5

The Complete MySQL Developer Course

What you’ll learn

Apply for jobs as junior MySQL developers
Build web applications using MySQL and PHP
Establish a solid foundation for databases and SQL

The Complete MySQL Developer Course

Requirements

No prior experience required
A browser and internet connection
Some prior experience in web technologies will be helpful but not necessary

Description

Novice to professional database developer in 4 weeks!
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 at will, build web applications, incorporate MySQL as the database layer – make your development dreams a reality by taking this course and putting a check mark next to your growing development skillset.
Database development with MySQL is one of the most fundamental skills that a technology professional needs to thrive in today’s workplace. This course gives you that skill. You’ll start with the absolute basics of 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 have learnt and do virtually anything you want with databases.
Regardless of whether you have experience with flashy new frameworks which try (and fail) to abstract the core of database queries, understanding and having the ability to manipulate these abstractions at will is fundamental to becoming a professional developer – which learning MySQL accomplishes!
This course has it all –
– Setting up MySQL, working with online IDE’s
– Creating Databases and Queries
– Using logical operators, manipulating tables/rows/data
– Learning 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
– Responsive support in Q & A and FREE LIVE HELP chatline!
I’m so confident that you’ll enjoy what you learn in this course that there is a no-questions asked 30-day money back guarantee (from the date of purchase). So what are you waiting for? Join today and I’ll see you in the course!

Overview

Section 1: Introduction to the course and MySQL

Lecture 1 Introduction

Lecture 2 Introduce yourself and learn how to get FREE LIVE HELP!

Lecture 3 Development environment overview

Lecture 4 IMPORTANT: Development Environment Setup – Overview

Lecture 5 Windows – Install/setup MySQL, users and create databases

Lecture 6 Mac – Install/setup MySQL, users and create databases

Lecture 7 AWS Cloud – Setup MySQL, users and create databases

Section 2: Creating Databases and Introduction to Queries

Lecture 8 Power of Databases

Lecture 9 Create a Database/Schema

Lecture 10 Create a Database/Schema – Text lecture

Lecture 11 Intro to tables and conventions used

Lecture 12 Working with tables

Lecture 13 Working with tables – Text lecture

Lecture 14 Inserting rows of data

Lecture 15 Inserting rows of data – Text lecture

Lecture 16 Select

Lecture 17 Select – Text lecture

Lecture 18 Concat and substring

Lecture 19 Concat and substring – Text lecture

Lecture 20 Homework challenge – bowling scores!

Lecture 21 Homework challenge – Text version

Lecture 22 Solution – bowling score challenge

Lecture 23 Solution – Text

Lecture 24 Alternate method of homework solution – script

Lecture 25 Alternate method of running queries – script – Text version

Lecture 26 MySQL, Oracle, SQL Server

Lecture 27 Limit, order by and distinct

Lecture 28 Limit, order by and distinct – Text lecture

Lecture 29 Count, like and group by

Lecture 30 Count, like and group by – Text lecture

Lecture 31 Min and max

Lecture 32 Min and max – Text lecture

Lecture 33 Code challenge project – create a new report

Lecture 34 Code challenge project – Text version

Section 3: Logical operators and dates

Lecture 35 Data types in MySQL

Lecture 36 Data types in MySQL – Text lecture

Lecture 37 Where and not equal

Lecture 38 Where and not equal – Text lecture

Lecture 39 Comparison operators

Lecture 40 Comparison operators – Text lecture

Lecture 41 Or

Lecture 42 Or – Text lecture

Lecture 43 Null and blanks

Lecture 44 Null and blanks – Text lecture

Lecture 45 Case statements

Lecture 46 Case statements – Text lecture

Lecture 47 Dates and times

Lecture 48 Dates and times – Text lecture

Lecture 49 Date, time and math

Lecture 50 Date, time and math – Text lecture

Lecture 51 Section 3 final project – Create a report on birthdays

Lecture 52 Text solution to final project on birthday reporting

Section 4: Update and delete rows

Lecture 53 Update

Lecture 54 Update – Text lecture

Lecture 55 Update based on comparison

Lecture 56 Update based on comparison – Text lecture

Lecture 57 Delete

Lecture 58 Delete – Text lecture

Section 5: Multiple tables and JOINS

Lecture 59 Primary keys, foreign keys

Lecture 60 Primary and foreign keys – Text lecture

Lecture 61 Data prep for joins

Lecture 62 Data prep for joins – Text lecture

Lecture 63 Joins and aliases

Lecture 64 Joins and aliases – Text lecture

Lecture 65 More about joins

Lecture 66 More about joins – Text lecture

Lecture 67 Inner, Left, Outer, Right joins

Lecture 68 Inner, Left, Outer and Right joins – Text lecture

Lecture 69 Left outer joins

Lecture 70 Left outer joins – Text lecture

Lecture 71 Fix a bad join challenge

Lecture 72 Fix a bad join challenge – Text lecture

Lecture 73 Subselects

Lecture 74 Subselects – Text lecture

Lecture 75 More subselects

Lecture 76 More subselects – Text lecture

Lecture 77 Section 5 – Final Project Part 1

Lecture 78 Final Project Part 1 – Text solution

Lecture 79 Section 5 – Final Project Part 2

Lecture 80 Final Project Part 2 – Text solution

Section 6: Web apps – Data collection from a survey

Lecture 81 Introduction to Web App Development

Lecture 82 HTML and CSS

Lecture 83 HTML and CSS – Text lecture

Lecture 84 Start form collector project

Lecture 85 Project start – Text lecture

Lecture 86 Add styling to form

Lecture 87 Add styling to form – Text follow-up

Lecture 88 Create table

Lecture 89 Create table – Text follow-up

Lecture 90 Learn php basics

Lecture 91 Config and other php

Lecture 92 Config and other php – Text follow-up

Lecture 93 Complete receiver

Lecture 94 Complete receiver – Text follow-up

Lecture 95 Start SQL Functons

Lecture 96 Start SQL Functions – Text lecture

Lecture 97 Preview and understand steps taken for web app

Lecture 98 Preview of web app – Text follow-up

Lecture 99 Add browser display

Lecture 100 Add browser display – Text follow-up

Lecture 101 Project – Convert to poll!

Lecture 102 Project – Solution text

Section 7: CRUD and PHP

Lecture 103 CRUD – Introduction

Lecture 104 CRUD – Intro – Text follow-up

Lecture 105 Create action

Lecture 106 Create action – Text lecture

Lecture 107 Read

Lecture 108 Read – Text lecture

Lecture 109 Update action

Lecture 110 Update action – Text lecture

Lecture 111 Delete action

Lecture 112 Delete action – Text lecture

Section 8: Authentication with PHP and MySQL

Lecture 113 Introduction to authentication

Lecture 114 Intro to authentication – Text lecture

Lecture 115 Complete user sign-up

Lecture 116 Complete user sign-up – Text lecture

Lecture 117 Login users

Lecture 118 Login users – Text lecture

Lecture 119 Enforce log in for app

Lecture 120 Enforce log in – Text lecture

Lecture 121 Sessions

Lecture 122 Sessions – Text lecture

Section 9: Challenge section – Build a WebAdmin site

Lecture 123 Challenge section intro and get started

Lecture 124 Challenge section intro – text reference

Lecture 125 Challenge section project day 2

Lecture 126 Project day 3, 4 and 5

Lecture 127 Project day 6, 7 and completion

Section 10: Deploy to production

Lecture 128 Deploy to production using a hosting service

Lecture 129 Deploy to production – Text lecture

Section 11: Database permissions

Lecture 130 Database permissions section doc

Section 12: Stored Procedures and Scheduled jobs

Lecture 131 Stored Procedures and Scheduled jobs section doc

Lecture 132 Thank you!

Anyone interested in learning MySQL and Database techonologies,Anyone interested in getting a job as a MySQL Developer,Anyone interested in building web applications,Anyone interested in making a career change to Tech industry

Course Information:

Udemy | English | 10h 28m | 3.40 GB
Created by: Rob Percival

You Can See More Courses in the Developer >> Greetings from CourseDown.com

New Courses

Scroll to Top