Course Overview
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!
FAQ
FAQ area empty
Course curriculum
-
Introduction
95 Xem trước -
Introduce yourself and learn how to get FREE LIVE HELP!
195 Xem trước -
Development environment overview
72 Xem trước -
IMPORTANT: Development Environment Setup - Overview
-
Windows - Install/setup MySQL, users and create databases
681 Xem trước -
Mac - Install/setup MySQL, users and create databases
469 Xem trước -
AWS Cloud - Setup MySQL, users and create databases
578 Xem trước
-
Power of Databases
115 Xem trước -
Create a Database/Schema
423 -
Create a Database/Schema - Text lecture
-
Intro to tables and conventions used
285 -
Working with tables
768 -
Working with tables - Text lecture
-
Inserting rows of data
709 -
Inserting rows of data - Text lecture
-
Select
177 -
Select - Text lecture
-
Concat and substring
640 -
Concat and substring - Text lecture
-
Homework challenge - bowling scores!
187 -
Homework challenge - Text version
-
Solution - bowling score challenge
654 -
Solution - Text
-
Alternate method of homework solution - script
242 -
Alternate method of running queries - script - Text version
-
MySQL, Oracle, SQL Server
202 -
Limit, order by and distinct
554 -
Limit, order by and distinct - Text lecture
-
Count, like and group by
466 -
Count, like and group by - Text lecture
-
Min and max
400 -
Min and max - Text lecture
-
Code challenge project - create a new report
660 -
Code challenge project - Text version
-
Data types in MySQL
320 -
Data types in MySQL - Text lecture
-
Where and not equal
319 -
Where and not equal - Text lecture
-
Comparison operators
430 -
Comparison operators - Text lecture
-
Or
126 -
Or - Text lecture
-
Null and blanks
508 -
Null and blanks - Text lecture
-
Case statements
207 -
Case statements - Text lecture
-
Dates and times
397 -
Dates and times - Text lecture
-
Date, time and math
808 -
Date, time and math - Text lecture
-
Section 3 final project - Create a report on birthdays
1175 -
Text solution to final project on birthday reporting
-
Primary keys, foreign keys
344 -
Primary and foreign keys - Text lecture
-
Data prep for joins
667 -
Data prep for joins - Text lecture
-
Joins and aliases
502 -
Joins and aliases - Text lecture
-
More about joins
759 -
More about joins - Text lecture
-
Inner, Left, Outer, Right joins
268 -
Inner, Left, Outer and Right joins - Text lecture
-
Left outer joins
478 -
Left outer joins - Text lecture
-
Fix a bad join challenge
255 -
Fix a bad join challenge - Text lecture
-
Subselects
414 -
Subselects - Text lecture
-
More subselects
515 -
More subselects - Text lecture
-
Section 5 - Final Project Part 1
759 -
Final Project Part 1 - Text solution
-
Section 5 - Final Project Part 2
276 -
Final Project Part 2 - Text solution
-
Introduction to Web App Development
489 -
HTML and CSS
153 -
HTML and CSS - Text lecture
-
Start form collector project
808 -
Project start - Text lecture
-
Add styling to form
481 -
Add styling to form - Text follow-up
-
Create table
397 -
Create table - Text follow-up
-
Learn php basics
-
Config and other php
831 -
Config and other php - Text follow-up
-
Complete receiver
921 -
Complete receiver - Text follow-up
-
Start SQL Functons
760 -
Start SQL Functions - Text lecture
-
Preview and understand steps taken for web app
944 -
Preview of web app - Text follow-up
-
Add browser display
594 -
Add browser display - Text follow-up
-
Project - Convert to poll!
278 -
Project - Solution text
Requirment
-
No prior experience required
-
A browser and internet connection
-
Some prior experience in web technologies will be helpful but not necessary
Outcomes
-
Apply for jobs as junior MySQL developers
-
Build web applications using MySQL and PHP
-
Establish a solid foundation for databases and SQL
0 Student
1 Course
0 review