Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development MySQL

The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

Become an In-demand SQL Master by creating complex databases and building reports through real-world projects
Bestseller
Rating: 4.6 out of 54.6 (51,375 ratings)
230,199 students
Created by Colt Steele, Ian Schoonover
Last updated 2/2021
English
English [Auto], French [Auto], 
30-Day Money-Back Guarantee

What you'll learn

  • Create your own database or interact with existing databases
  • Write complex SQL queries across multiple tables
  • Build a web app using NodeJS and MySQL
  • Model real-world data and generate reports using SQL
  • Answer company performance or sales questions using data
Curated for the Udemy for Business collection

Course content

18 sections • 322 lectures • 20h 25m total length

  • Preview01:08
  • Preview01:25
  • Preview04:18
  • Note about SQL Editor
    00:14
  • Preview06:13
  • Preview00:29
  • Preview03:44

  • Section Introduction
    01:02
  • What Is a Database?
    07:16
  • SQL Vs. MySQL
    05:50
  • Installation Overview - WATCH BEFORE INSTALLING
    05:10
  • Cloud9 Registration IMPORTANT - PLEASE READ!!!
    00:54
  • Mac Installation
    11:41
  • CODE: Mac Installation
    00:32
  • Windows Installation
    03:32

  • Section 3 Introduction
    01:09
  • Creating Databases
    05:20
  • CODE: Creating Databases
    00:07
  • Dropping Databases
    01:46
  • CODE: Dropping Databases
    00:06
  • Using Databases
    03:00
  • CODE: Using Databases
    00:02
  • Introduction to Tables
    05:09
  • The Basic Datatypes
    07:52
  • Note about INT max size
    00:08
  • Basic Datatypes Challenge
    02:35
  • Basic Datatypes Challenge - Solution
    00:00
  • Creating Your Own Tables
    03:06
  • CODE: Creating Your Own Tables
    00:03
  • How Do We Know It Worked?
    02:33
  • CODE: How Do We Know It Worked?
    00:02
  • Dropping Tables
    01:36
  • CODE: Dropping Tables
    00:03
  • Creating Your Own Tables Challenge
    04:29
  • CODE: Creating Your Own Tables Challenge
    00:03

  • Section 4 Introduction
    01:40
  • Inserting Data
    05:03
  • CODE: Inserting Data
    00:04
  • Super Quick Intro To SELECT
    02:07
  • CODE: Super Quick Intro To SELECT
    00:00
  • Multiple INSERT
    03:00
  • CODE: Multiple Insert
    00:03
  • INSERT Challenges
    01:35
  • Note about using quotes inside of inserted values
    00:15
  • INSERT Challenges Solution
    04:43
  • CODE: INSERT Challenges Solution
    00:13
  • NOTE: MySQL Warnings
    00:12
  • MySQL Warnings
    05:35
  • CODE: MySQL Warnings
    00:15
  • NULL and NOT_NULL
    06:54
  • CODE: NULL and NOT NULL
    00:21
  • Setting Default Values
    07:17
  • CODE: Setting Default Values
    00:26
  • A Primer On Primary Keys
    12:21
  • CODE: A Primer on Primary Keys
    00:30
  • Table Constraints Exercise
    01:51
  • Table Constraints Exercise Solution
    03:34
  • CODE: Table Constraints Exercise Solution
    00:21

  • Section 5 Introduction
    01:30
  • Introduction to CRUD
    01:44
  • CODE: Introduction to CRUD
    00:01
  • Preparing Our Data
    02:29
  • CODE: Preparing Our Data
    00:18
  • Official Introduction to SELECT
    04:18
  • CODE: Official Introduction to SELECT
    00:11
  • Introduction to WHERE
    05:04
  • CODE: Introduction to WHERE
    00:07
  • SELECT Challenges
    02:00
  • SELECT Challenges Solution
    02:45
  • CODE: SELECT Challenges Solution
    00:08
  • Introduction to Aliases
    02:55
  • CODE: Introduction to Aliases
    00:05
  • The UPDATE Command
    03:58
  • CODE: The UPDATE Command
    00:05
  • UPDATE Challenges
    00:37
  • UPDATE Challenges Solution
    03:58
  • CODE: UPDATE Challenges Solution
    00:16
  • Introduction to DELETE
    04:41
  • CODE: Introduction to DELETE
    00:06
  • DELETE Challenges
    01:10
  • DELETE Challenges Solution
    02:45
  • CODE: DELETE Challenges Solution
    00:09

  • Section 6 Introduction
    01:52
  • CRUD Exercise Overview
    07:26
  • CRUD Exercise Create Solution
    05:55
  • CODE: CRUD Exercise Create Solution
    00:22
  • CRUD Exercise Read Solution
    01:48
  • CODE: CRUD Exercise Read Solution
    00:04
  • CRUD Exercise Update Solution
    04:10
  • CODE: CRUD Exercise Update Solution
    00:17
  • CRUD Exercise Delete Solution
    03:21
  • CODE: CRUD Exercise Delete Solution
    00:11

  • Section 7 Introduction
    02:04
  • Important Note about Running SQL Files (please read)
    00:13
  • Running SQL Files
    10:15
  • CODE: Running SQL Files
    00:09
  • Loading Our Book Data
    05:25
  • CODE: Loading Our Book Data
    00:51
  • Working with CONCAT
    11:07
  • CODE: Working With CONCAT
    00:20
  • Introducing SUBSTRING
    10:04
  • CODE: Introducing SUBSTRING
    00:21
  • Introducing REPLACE
    06:39
  • CODE: Introducing REPLACE
    00:24
  • Using REVERSE
    03:39
  • CODE: Using REVERSE
    00:04
  • Working with CHAR LENGTH
    04:54
  • CODE: Working with CHAR LENGTH
    00:04
  • Changing Case with UPPER and LOWER
    03:20
  • CODE: Changing Case with UPPER and LOWER
    00:06
  • Note about string functions
    00:46
  • String Function Challenges
    04:42
  • String Function Challenges Solution
    13:08
  • CODE: String Function Challenges Solution
    00:22

  • Section 8 Introduction
    00:35
  • Seed Data: Adding A Couple New Books
    02:47
  • CODE: Seed Data: Adding A Couple New Books
    00:09
  • Using DISTINCT
    08:24
  • CODE: Using DISTINCT
    00:06
  • Sorting Data with ORDER BY
    11:19
  • CODE: Sorting Data with ORDER BY
    00:32
  • Using LIMIT
    09:03
  • CODE: Using LIMIT
    00:31
  • Better Searches with LIKE
    07:42
  • CODE: Better Searches with LIKE
    00:10
  • LIKE Part 2: More Wildcards
    06:09
  • CODE: LIKE Part 2: More Wildcards
    00:11
  • Refining Selections Exercises
    04:52
  • Refining Selections Exercises Solution
    12:29
  • CODE: Refining Selections Exercises Solution
    00:20

  • Section 9 Introduction
    03:56
  • The Count Function
    08:38
  • CODE: The Count Function
    00:10
  • The Joys of Group By
    12:22
  • CODE: The Joys of Group By
    00:20
  • Min and Max Basics
    04:12
  • CODE: MIN and MAX Basics
    00:06
  • SUBQUERIES - A Problem with Min and Max
    07:14
  • CODE: A Problem with Min and Max
    00:15
  • Using Min and Max with Group By
    06:39
  • CODE: Using Min and Max with Group By
    00:08
  • The Sum Function
    04:27
  • CODE: The Sum Function
    00:07
  • The Avg Function
    06:00
  • CODE: The Avg Function
    00:08
  • Aggregate Functions Challenges
    04:27
  • Aggregate Functions Challenges Solution
    09:10
  • CODE: Aggregate Functions Challenges Solution
    00:22

  • Section 10 Introduction
    01:56
  • CHAR and VARCHAR
    14:29
  • Note about CHAR and VARCHAR
    00:05
  • CODE: CHAR and VARCHAR
    00:11
  • DECIMAL
    06:07
  • CODE: DECIMAL
    00:06
  • FLOAT and DOUBLE
    07:44
  • CODE: FLOAT and DOUBLE
    00:07
  • Note about setting the timezone in Cloud9
    00:07
  • DATE, TIME, and DATETIME
    04:31
  • Creating Our DATE data
    05:49
  • CODE: Creating Our DATE data
    00:09
  • CURDATE, CURTIME, and NOW
    05:15
  • Note about formatting dates
    00:09
  • Formatting Dates
    14:29
  • CODE: Formatting Dates
    00:24
  • Date Math
    09:40
  • CODE: Date Math
    00:17
  • Working with TIMESTAMPS
    10:54
  • CODE: Working with TIMESTAMPS
    00:25
  • Data Types Exercises
    04:50
  • Data Types Exercises Solution
    13:58
  • CODE: Data Types Exercises Solution
    00:36

Requirements

  • No Database, SQL, or MySQL experience needed! Complete beginners to MySQL are welcome.
  • All you need is a working computer for this course; PC, Mac, and Linux users are all welcome.
  • No previous programming language experience required, but it won't hurt :)

Description

If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today.  

Whether you work in sales or marketing, you run your own company, or you want to build your own apps, mastering MySQL is crucial to answering complex business problems and questions using insights from data. The Ultimate MySQL Bootcamp introduces you to a solid foundation in databases in a way that’s both informative and engaging. Yes, that’s right, it’s possible to make an engaging course on databases.  

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

  • Write Javascript code to generate fake data sets

  • And more!

This course is also chock full of exercises, challenges, projects, and opportunities for you to practice what you’re learning. Apply what you’re learning to real-world challenges such as finding a website’s power users, calculating your top students, identifying bots on a site, or determining which hashtags generate the most traction on a site. Along the way, you’ll also get to meet my pet cat, Blue! (She’s really cute.)

Why Learn MySQL

Consistently ranked the most in-demand skill in recent employer surveys, SQL is a fantastic way to increase your income and boost your professional development. So many companies today use MySQL, including Twitter, Uber, Airbnb, Dropbox, Github, Kickstarter, Udemy, Slack, and many others. Unsure about the difference between SQL and MySQL? MySQL is the most popular open source SQL database out there, so it’s a great choice to begin your learning journey. We’ll talk a lot more about the difference between SQL and MySQL in the course, but 95% of what you learn about MySQL in this course will apply to other databases such as Postgres, Oracle, and Microsoft SQL Server.

Why This Course Is Different  

This isn’t going to be a course where you watch me code for 20 hours; it’s a course with ample opportunity for you to get your hands dirty writing code (even within the first 7 minutes of the course).

My teaching experience is rooted in the classroom. I’ve spent years teaching programming, web development, and databases to my in-person bootcamp students. This course combines the best of my offline courses with the convenience of learning online, in a setting that’s best for you.   

Upon completing this course, you’ll be able to interact with and query any SQL database out there. You’ll also be able to generate reports with ease, answer company performance questions using data, and integrate MySQL into complete applications.

So let’s do this! Enroll today and start learning SQL!

Who this course is for:

  • 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

Featured review

Nassim Badaoui
Nassim Badaoui
39 courses
2 reviews
Rating: 5.0 out of 5a year ago
The course was great. Colt gives a lot of detailed information and breaks it down into small chunks with many excercises. Although this can make the course seem slow at times one can always skip something that is already known or speed up the playback rate. I was very satisfied with what I got and will pursue other courses created by Colt.

Instructors

Colt Steele
Developer and Bootcamp Instructor
Colt Steele
  • 4.7 Instructor Rating
  • 308,045 Reviews
  • 949,890 Students
  • 10 Courses

Hi! I'm Colt. I'm a developer with a serious love for teaching. I've spent the last few years teaching people to program at 2 different immersive bootcamps where I've helped hundreds of people become web developers and change their lives. My graduates work at companies like Google, Salesforce, and Square.

Most recently, I led Galvanize's SF's 6 month immersive program as Lead Instructor and Curriculum Director. After graduating from my class, 94% of my students went on to receive full-time developer roles. I also worked at Udacity as a Senior Course Developer on the web development team where I got to reach thousands of students daily.

I’ve since focused my time on bringing my classroom teaching experience to an online environment. In 2016 I launched my Web Developer Bootcamp course, which has since gone on to become one of the best selling and top rated courses on Udemy. I was also voted Udemy’s Best New Instructor of 2016.

I've spent years figuring out the "formula" to teaching technical skills in a classroom environment, and I'm really excited to finally share my expertise with you. I can confidently say that my online courses are without a doubt the most comprehensive ones on the market.

Join me on this crazy adventure!

Ian Schoonover
Full Stack Developer and Coding Instructor
Ian Schoonover
  • 4.7 Instructor Rating
  • 54,221 Reviews
  • 900,936 Students
  • 4 Courses

Ian has been enveloped in technology since childhood. By age 13 he was building websites and graphics for his online gaming teams. This hobby eventually turned into a profession.

He has taught web development at several popular bootcamps, including General Assembly, Galvanize, iXperience, DevMountain, and Tech Talent South.

Ian truly enjoys helping others learn to code. Feel free to send him a message if you have questions about changing careers or learning a new skill.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.