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
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