The Complete MySQL Developer Course
The Complete MySQL Developer Course, available at $84.99, has an average rating of 4.44, with 137 lectures, based on 6237 reviews, and has 27575 subscribers.
You will learn about Apply for jobs as junior MySQL developers Build web applications using MySQL and PHP Establish a solid foundation for databases and SQL This course is ideal for individuals who are Anyone interested in learning MySQL and Database techonologies or Anyone interested in getting a job as a MySQL Developer or Anyone interested in building web applications or Anyone interested in making a career change to Tech industry It is particularly useful for Anyone interested in learning MySQL and Database techonologies or Anyone interested in getting a job as a MySQL Developer or Anyone interested in building web applications or Anyone interested in making a career change to Tech industry.
Enroll now: The Complete MySQL Developer Course
Summary
Title: The Complete MySQL Developer Course
Price: $84.99
Average Rating: 4.44
Number of Lectures: 137
Number of Published Lectures: 132
Number of Curriculum Items: 137
Number of Published Curriculum Objects: 132
Original Price: $159.99
Quality Status: approved
Status: Live
What You Will Learn
- Apply for jobs as junior MySQL developers
- Build web applications using MySQL and PHP
- Establish a solid foundation for databases and SQL
Who Should Attend
- 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
Target Audiences
- 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
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!
Course Curriculum
Chapter 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
Chapter 2: Creating Databases and Introduction to Queries
Lecture 1: Power of Databases
Lecture 2: Create a Database/Schema
Lecture 3: Create a Database/Schema – Text lecture
Lecture 4: Intro to tables and conventions used
Lecture 5: Working with tables
Lecture 6: Working with tables – Text lecture
Lecture 7: Inserting rows of data
Lecture 8: Inserting rows of data – Text lecture
Lecture 9: Select
Lecture 10: Select – Text lecture
Lecture 11: Concat and substring
Lecture 12: Concat and substring – Text lecture
Lecture 13: Homework challenge – bowling scores!
Lecture 14: Homework challenge – Text version
Lecture 15: Solution – bowling score challenge
Lecture 16: Solution – Text
Lecture 17: Alternate method of homework solution – script
Lecture 18: Alternate method of running queries – script – Text version
Lecture 19: MySQL, Oracle, SQL Server
Lecture 20: Limit, order by and distinct
Lecture 21: Limit, order by and distinct – Text lecture
Lecture 22: Count, like and group by
Lecture 23: Count, like and group by – Text lecture
Lecture 24: Min and max
Lecture 25: Min and max – Text lecture
Lecture 26: Code challenge project – create a new report
Lecture 27: Code challenge project – Text version
Chapter 3: Logical operators and dates
Lecture 1: Data types in MySQL
Lecture 2: Data types in MySQL – Text lecture
Lecture 3: Where and not equal
Lecture 4: Where and not equal – Text lecture
Lecture 5: Comparison operators
Lecture 6: Comparison operators – Text lecture
Lecture 7: Or
Lecture 8: Or – Text lecture
Lecture 9: Null and blanks
Lecture 10: Null and blanks – Text lecture
Lecture 11: Case statements
Lecture 12: Case statements – Text lecture
Lecture 13: Dates and times
Lecture 14: Dates and times – Text lecture
Lecture 15: Date, time and math
Lecture 16: Date, time and math – Text lecture
Lecture 17: Section 3 final project – Create a report on birthdays
Lecture 18: Text solution to final project on birthday reporting
Chapter 4: Update and delete rows
Lecture 1: Update
Lecture 2: Update – Text lecture
Lecture 3: Update based on comparison
Lecture 4: Update based on comparison – Text lecture
Lecture 5: Delete
Lecture 6: Delete – Text lecture
Chapter 5: Multiple tables and JOINS
Lecture 1: Primary keys, foreign keys
Lecture 2: Primary and foreign keys – Text lecture
Lecture 3: Data prep for joins
Lecture 4: Data prep for joins – Text lecture
Lecture 5: Joins and aliases
Lecture 6: Joins and aliases – Text lecture
Lecture 7: More about joins
Lecture 8: More about joins – Text lecture
Lecture 9: Inner, Left, Outer, Right joins
Lecture 10: Inner, Left, Outer and Right joins – Text lecture
Lecture 11: Left outer joins
Lecture 12: Left outer joins – Text lecture
Lecture 13: Fix a bad join challenge
Lecture 14: Fix a bad join challenge – Text lecture
Lecture 15: Subselects
Lecture 16: Subselects – Text lecture
Lecture 17: More subselects
Lecture 18: More subselects – Text lecture
Lecture 19: Section 5 – Final Project Part 1
Lecture 20: Final Project Part 1 – Text solution
Lecture 21: Section 5 – Final Project Part 2
Lecture 22: Final Project Part 2 – Text solution
Chapter 6: Web apps – Data collection from a survey
Lecture 1: Introduction to Web App Development
Lecture 2: HTML and CSS
Lecture 3: HTML and CSS – Text lecture
Lecture 4: Start form collector project
Lecture 5: Project start – Text lecture
Lecture 6: Add styling to form
Lecture 7: Add styling to form – Text follow-up
Lecture 8: Create table
Lecture 9: Create table – Text follow-up
Lecture 10: Learn php basics
Lecture 11: Config and other php
Lecture 12: Config and other php – Text follow-up
Lecture 13: Complete receiver
Lecture 14: Complete receiver – Text follow-up
Instructors
-
Rob Percival
Web Developer And Teacher -
Mashrur Hossain
Technology Professional and Entrepreneur -
Codestars • over 2 million students worldwide!
Teaching the Next Generation of Coders
Rating Distribution
- 1 stars: 67 votes
- 2 stars: 98 votes
- 3 stars: 625 votes
- 4 stars: 2437 votes
- 5 stars: 3010 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Digital Marketing Foundation Course
- Google Shopping Ads Digital Marketing Course
- Multi Cloud Infrastructure for beginners
- Master Lead Generation: Grow Subscribers & Sales with Popups
- Complete Copywriting System : write to sell with ease
- Product Positioning Masterclass: Unlock Market Traction
- How to Promote Your Webinar and Get More Attendees?
- Digital Marketing Courses
- Create music with Artificial Intelligence in this new market
- Create CONVERTING UGC Content So Brands Will Pay You More
- Podcast: The top 8 ways to monetize by Podcasting
- TikTok Marketing Mastery: Learn to Grow & Go Viral
- Free Digital Marketing Basics Course in Hindi
- MailChimp Free Mailing Lists: MailChimp Email Marketing
- Automate Digital Marketing & Social Media with Generative AI
- Google Ads MasterClass – All Advanced Features
- Online Course Creator: Create & Sell Online Courses Today!
- Introduction to SEO – Basic Principles of SEO
- Affiliate Marketing For Beginners: Go From Novice To Pro
- Effective Website Planning Made Simple