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!
Introduce yourself to the class and learn how to get help in Q & A section and free live chat
Why we will use an online IDE to develop code in this course
Use cloud9 to sign up for development environment
Text follow-up material for sign-up for cloud based IDE video
How to create a database/schema
Text information for Create a Database/Schema video
A look at tables, structures for queries and syntax used in the course
Learn how to work with tables in databases
Learn how to insert data into tables
Text follow-up to inserting rows of data video
Working with select in MySQL
Text follow-up for working with select video
Working with the concat and substring operators
Text follow-up lecture to working with concat and substring operators
Homework code challenge
Text version of homework challenge
Solution to homework assignment
Text solution to homework challenge
Using scripts to develop code and running them instead of using the console
Text description of how to run queries via scripts
A look at SQL
Learn how to use additional features like limit, order by and distinct
Text follow-up to limit, order by and distinct features
Learn how to use count, like and group by features
Text follow-up for video lecture on using count, like and group by
Learn how to use min and max
Text follow-up to video lecture on min and max operators
Code challenge to create a new report
Text solution to report
Learn about different data types and their features
Text lecture follow-up to video on data types
Learn the details about where and how to use it, along with not equal
Text lecture follow-up to where and not equal
Working with comparison operators
Text lecture follow-up to comparison operators video
Working with or
Text lecture follow-up for working with Or
Working with null entries and blanks
Text lecture follow-up for working with null and blank video
Working with case
Text lecture follow-up for working with case statements
Working with date and time formats
Text lecture follow-up for video on working with dates and times
More date, time and date math
Text lecture follow-up to video on more date, time and math
Final project for section 3, report on working with birthdays
Text solution to final project on section 3 - birthday reporting
Update rows of data in tables
Text lecture follow-up to updating
More info and usage of update
Text follow-up to more use of updates
How to use delete to remove data
Text lecture follow-up on how to use delete
Learn what are primary and foreign keys
Text version of primary and foreign keys video
Setup our tables and data to work with joins
Text follow up to data prep for joins video
Learn about joins and using aliases
Text follow-up to Joins and aliases video
Joins more in-depth
Text follow-up to more about joins video
Learn about inner, left, outer and right joins
Text follow-up to video on different types of joins
Learn about left joins
Text follow-up to video on left joins
Code challenge to fix a bad join
Text follow up to fixing a bad join challenge
Learn about subselects
Text follow-up to lecture on subselects
Subselects more in-depth
Text followup to video on subselects more in-depth
Part 1 of final project for section 5
Text solution to final project part 1
Part 2 of final project for section 5
Text solution to final project part 2 of section 5
Working with HTML and CSS - web building blocks
Text follow-up to video on HTML and CSS
Start the web app
Text follow-up to form collector project
Add styling to the form collector
Text follow-up lecture to adding styling
Create a table for the app using sql
Text follow-up to creating a table with sql
Create a config file along with other php
Text lecture follow-up to config and other php
Complete the code for receiver.php
Text lecture follow-up to complete receiver.php file
Start working on SQLFunctions file
Text lecture follow-up to SQL Functions
Preview the web app and steps taken
Text lecture follow-up to preview web app video
Add a browser display for the web app
Text follow-up to adding browser display video
Final project for section 6 - convert to poll
Text solution to final project for section 6
An introduction to CRUD - what is it?
Text follow-up for introduction to CRUD lecture
Build the create action for the To Do app
Text lecture follow-up to create action
Implement Read action for app
Text lecture follow-up to Read action
Implement update action for the app
Text lecture follow-up to update action video
Implement the delete action for to-do's
Text follow-up to delete action video
Intro to authentication - what is it?
Text lecture follow-up to introduction to authentication
Continue with and complete signing up users
Text lecture follow-up to signing up users
Implement log in and log out functionality
Text lecture follow-up to log in and log out video
Add requirements to users to be logged in
Text lecture follow-up to enforcing log in
Implementing and working with Sessions
Text lecture follow-up to working with sessions
Challenge section introduction and start admin site
Text reference for challenge section
Day 2 items
Challenge section project days 3, 4 and 5
Project day 6 and 7 leading to completion
Deploy web apps to production using a hosting service
Hi! I'm Rob. I have a degree in Mathematics from Cambridge University and you might call me a bit of coding geek.
After building websites for friends and family for fun, I soon learned that web development was a very lucrative career choice. I gave up my successful (and sometimes stressful) job as a teacher to work part time and today, couldn't be happier.
I'm passionate about teaching kids to code, so every summer I run Code School in the beautiful city of Cambridge. I also run the popular web hosting and design service, Eco Web Hosting which leaves me free to share my secrets with people like you.
You wouldn't believe the freedom that being a web developer offers. Sign up and find out for yourself why so many people are taking and recommending this course. I genuinely believe it's the best on the market and if you don't agree, I'll happily refund your money.
Sign up to my courses and join me in this amazing adventure today.
Hi, I'm Mashrur, I have been a technology professional for over a decade and have degrees in Computer Science and Economics
I have worked with Enterprise Software Systems throughout my career with roles played in analysis, development and management. I lead projects using both agile and waterfall methodologies and am well versed in the inner workings of the software development and delivery world.
During my career, I've realized how much I enjoyed training new hires and new team members and helping them succeed. I've dedicated a good amount of time over the last 7 years on-boarding new analysts and developers and working with them to build and maintain systems which puts me in a very unique position of knowing what new entrants to a field or subject need to succeed. I strongly believe in a focus on fundamentals and practice and not in shortcuts or gimmicks.
I'm very passionate about web application development and I prototype and build web apps in entrepreneurial pursuits. Ruby on Rails has proven to be a very strong force in this field and is especially powerful for startups looking to prototype ideas rapidly and subsequently building on that platform as the ideas catch on.
So join me for my comprehensive Ruby on Rails Developer courses as I guide you through the world of web application development using Rails and bringing your ideas to life.
Best-selling Udemy instructor Rob Percival wants to revolutionize the way people learn to code by making it simple, logical, fun and, above all, accessible. But as just one man, Rob couldn’t create all the courses his students - more than half a million of them - wanted.
That’s why Rob created Codestars. Together, the instructors that make up the Codestars team create courses on all the topics that students want to learn in the way that students want to learn them: courses that are well-structured, super interactive, and easy to understand. Codestars wants to make it as easy as possible for learners of all ages and levels to build functional websites and apps.