UST COMPLETELY REDONE! Master SQL, Work With Complex
Databases, Build Reports, and More!
What you'll learn:
- Create
your own database or interact with existing databases
- Write
complex SQL join queries across multiple tables
- Master
MySQL 8 Window Functions (LEAD, LAG, RANK, etc.)
- Model
real-world data and generate reports using SQL
- Answer
company performance or sales questions using data
- Learns
the ins and outs of MySQL 8. x syntax
This course was just completely redone and rebuilt from
the ground up, with over 325 brand-new videos recorded. The course now
uses MySQL 8. x and covers new topics including Windows
Functions, Views, and SQLmodes.
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
- 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
- Work
with MySQL 8. x Window Functions: RANK, LEAD, LAG, NTILE, etc.
- Create MySQL
database views and virtual tables
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 as 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 boot camp 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.
Comments