The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert udemy online courses
Become an In-demand SQL Master by creating complex databases and building reports through real-world projects download udemy videos free
This course includes
20 hours on-demand video
4 downloadable resources
Full lifetime access
Access on mobile and TV
Certificate of Completion
Expand all 319 lectures
Introduction and 5 Minutes of SQL
Getting Started: Overview and Installation
Creating Databases and Tables
Inserting Data (and a couple other things)
CRUD Challenge Section
The World Of String Functions
Refining Our Selections
The Magic of Aggregate Functions
Revisiting Data Types
The Power of Logical Operators
Section 12: One To Many
Section 13: Many To Many
Instagram Database Clone
Working With Lots Of Instagram Data
Section 16 – Introducing Node
Section 17 – Building Our Web App
Section 18 – Database Triggers
In this course, you will:
- Learn the ins and outs of SQL syntax
- Generate reports using sales and user data
- Analyze data using Aggregate Functions
- Run complex queries using MySQL logical operators and string functions
- Write all the common SQL joins
- Work with large datasets containing thousands of entries
- Build a web app using MySQL and NodeJS
- Design and implement complex database schemas
- Learn to navigate the treacherous world of storing dates and times
- Clone the database structure of a photo sharing social network
- Anyone interested in learning SQL to help with their current job or to find a new role. SQL is one of today’s most in-demand skills
- Anyone looking to answer complex business problems and generate reports using data
- Business owners, people in sales, or people in marketing roles who are interested in understanding company data better.
- Developers who are looking to build applications (e.g. social network, ecommerce site) using MySQL
4.6 Course Ratings
Colt is a fantastic teacher! Explains absolutely every single detail of every new part we’re introduced to. I would highly recommend you to go through this course! I personally started to work in a Data Warehouse department before I took this course and didn’t understand anything from SQL queries. Even after several sections I started to understand what’s going on and after I finished it, I can search for information in database writing my own queries without a problem!
Great course. Concepts are well explained and easy to follow. Trying to follow in goorm instead of cloud9 was challenging at times, however I was able to get through course without any issues.
It was a good (almost excellent) course until the whole C9 transition thing.
The course should be developed further to run on desktop mysql.
It will be valuable to go through the pain of manually installing mysql and all the integrating development environments.
It was an awesome course up until we started to have to use node. This would have been a five start course if it would not shifted in a different direction towards the end of the course. Colt’s teaching style made it so easy to learn MYSQL and only wished he would have instead focused on alter commands and more complex queries that involve multiple joins with case-statements within such queries. I think if this course was updated utilizing MYSQL and learning advanced queries, the instructors teaching styles would have given me the confidence to learn SQL and apply for jobs!
I was a complete beginner, Colt made this experience enjoyable. He explained with the assumption that students had no previous knowledge and the Videos from the TA were super helpful when the ide changed. I encountered similar errors many people did, but I was able to follow along easily when their questions were answered. Thank you for the awesome experience.
Colt is a good instructor and pretty funny in a natural way. The course is easy to understand. However, Node and Web App sections at the end are a bit underqualified compared to other sections. I had a hard time understanding those 2 sections, and gave up trying at the end. But the rest is perfect. Go for it! You will enjoy the course.
Content needs to be updated to reflect Goorm IDE and all of its nuances. Overall, I’m satisfied with the course.
it is a great course. it was clearly made with care. the instructor is really good and makes easy to follow something that could be a bit boring at times . it might be in need of an update because of the cloud9 / goormIDE differences.
I’m one of the students that took the Web Developer Bootcamp first, and then went and took this course to know what SQL really was. That being said, I learned a lot from SQL and MySQL from this course. It was exactly what I was looking for. I am a Software Engineer graduate and all of this stuff was explained really badly and quickly on university so I didn’t really learned this topic all that well.
It was absolutely amazing. I love the touch of humor added, takes away the difficulty of the course. Well done colt and you really should have allowed Siri sing the whole of “Hello”….lol
Nice meeting Blue. It was a good distraction
Great course, very informative and full of valuable information. I was only hindered by wanting to use MySQL natively on my Windows10 machine and needed to download MySQL, VS Code, NodeJS and Express to do the whole course without using an online environment. I will definitely be using the information I have learnt and have already recommended this course to someone else. It is a great introduction course for anyone who has some Excel knowledge and wants to add to their skillset.
Perfect progression. Keeps me engaged. And I don’t feel like I’m assumed to know much more than what is taught. I love how cognizant Colt is of this. He throws minimal curveballs to keep you thinking but the notes and instructions he gives are clear.
Download Udemy Course File 2.32 GB ↓