Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

SQL BootCamp - Learn MySQL for Data Analysis

Name: SQL BootCamp - Learn MySQL for Data Analysis
Rating: 4.4 (16 reviews)

Learn SQL using MySQL the most popular SQL software. Land that Data Analyst job with this course.

Created bySandra Ezike, Orezime Learning

Last updated 4/2021

English

What you'll learn

Start using MySQL – the #1 Database Management System
Boost your resume by learning an in-demand skill
Prepare for SQL developer, Database administrator, Data Analyst, and Business Intelligence job opportunities
Develop business intuition while solving tasks with big data
Tons of exercises that will solidify your knowledge

Coding Exercises

This course includes our updated coding exercises so you can practice your skills as you learn.

Course content

12 sections • 98 lectures • 14h 48m total length

Welcome0:56
Explore how MySQL powers data analysis by mastering SQL functions, DDL commands, indexes, triggers, and procedures, taking you from beginner to expert.
Course Outline3:12
Explore MySQL fundamentals from beginner to advanced, including relational database concepts, select statements and joins, modifying data, creating tables, working with datasets, and practice with assignments and downloadable code.
Introduction to SQL7:40
Explore structured query language's role in storing, manipulating, and retrieving data in relational databases, and learn the building blocks of tables, columns, and rows with MySQL and other RDBMS examples.

Downloading MySQL for Mac OS8:00
Download the latest MySQL community server and MySQL Workbench for macOS, then install, configure a password, connect to the server, and open Cicely's database in the Workbench.
Downloading MySQL for windows OS13:47
Downloading sample database 18:58
Learn to download and set up three sample databases—employees, box office, and organization—for MySQL practice by downloading zip files, loading schemas, and running create table statements.
Downloading sample database 24:55

What you will learn in this Section1:01
SELECT Using WHERE and DISTINCT15:07
SELECT Using WHERE and DISTINCT Cont.7:03
Learn how to use select with where and distinct in MySQL, including single-column and multi-column distinct, from clauses, and practical examples involving titles, departments, and dates.
AND Operator 16:25
AND Operator 29:11
OR Operator9:40
NOT Operator12:24
Explore how to use the not operator alongside and and or in sql queries, with brackets for grouping, to filter current employees, departments, titles, and hire dates.
AND, OR, NOT13:08
ARITHMETIC OPERATIONS8:35
COMPARISON OPERATIONS8:52
IN OPERATIONS12:19
BETWEEN OPERATOR11:01
LIKE OPERATOR 111:09
LIKE OPERATOR 29:04
ALIASES14:32
LIMIT, MAX AND MIN FUNCTIONS 112:11
LIMIT, MAX AND MIN FUNCTIONS 29:30
AVG, COUNT and SUM FUNCTIONS17:45
Using Order and Group By Clauses19:57
Using HAVING and ROLLUP CLAUSE15:47
Learn how to use the having clause to filter grouped results. See how rollup yields totals of aggregates, with examples counting employees by department and computing overall totals.
Section Recap6:23
Clarify rollup rules, demonstrate grouping by product code, and sum quantity and price across joined tables using a single value rule.
Coding Exercise on Select

All about Functions1:19
Cast and Convert17:20
Null Functions11:54
Explore null handling in MySQL with is null, is not null, and coalesce, using real table examples to distinguish NULL, empty values, and how to retrieve first non-null values.
Using COALESCE10:19
Learn how to use coalesce to return the first non-null address components across two tables, joining customers and offices and handling missing city or country values.
DATE FUNCTION 19:16
DATE FUNCTION 213:30
DATE FUNCTIONS 312:14
DATE CHALLENGE ANSWER6:22
Using CONCAT Function14:15
String Function - INSTRING5:57
String Function - LOWER and UPPER11:40
Replace and Trim15:15
SECTION RECAP2:37
Coding Exercise on Functions

Section Intro1:04
Master SQL joins, including inner and outer joins, left and right joins, self joins, and cross joins, through theory and hands-on practice in this essential section of the SQL bootcamp.
Inner Join24:10
Left Join 18:00
Left Join 29:46
Right Join8:53
Cross Join10:03
Explore cross join behavior by multiplying all rows from two tables, note how unmatched left and right rows affect results, and consider size implications of full outer join.
Self Join 11:36
Self Join 216:54
SECTION RECAP3:36
Coding exercise on SQL Joins

Section Intro0:55
UNION OPERATOR14:02
FULL OUTER JOIN USING THE UNION OPERATOR5:41
Learn to simulate a full outer join in MySQL by combining two left joins with the union operator, using the customizable and staff tables with store_id as the key.
FULL OUTER JOIN USING THE UNION OPERATOR 24:25
Learn how to perform a full outer join using the union operator, combining departments and employees data with left joins on department numbers.
INTERSECT OPERATOR6:50
Explore the intersect operator, which returns the common rows between two queries, requiring identical column order and data types. When not supported, simulate it with distinct and an inner join.
MINUS OPERATOR8:52
SECTION RECAP1:29
QUIZ ON SET OPERATORS

Section Intro0:51
Master modifying data in MySQL by using insert, select, update, delete, and replace statements, including inserting multiple values and performing bulk updates.
INSERT STATEMENT8:42
learn to use the insert statement to add rows with values into a departments table, specify columns when needed, and insert multiple rows in one command.
INSERT INTO SELECT 18:52
INSERT INTO SELECT 29:12
UPDATE STATEMENT9:45
DELETE STATEMENT14:49
Understand delete statements in MySQL, including delete from, delete cascade, and on delete cascade, and how foreign key constraints control cascading deletions.
REPLACE STATEMENT9:27
SECTION RECAP2:39
Coding Exercise on Other DML commands

Requirements

No Prerequisites.

Description

Do you want to be able to gain insights from your data? Will you like to have a competitive advantage over your peers? Do you want to be work with Databases but do not know where to start? If your answer is Yes! then this course is for you.

This mega course offers over 14 hours of content and teaches you all you need to Land that SQL data analyst Job. SQL is one of the most in demand skills of Data analysts and with this course you will learn the foundations of SQL, Database concepts and practice writing SQL queries. I have also provided quizzes after every section to help you hone your skills.

Course Outline

1. Introduction

In this section we introduce SQL and what we are going to learn

2. Environment Setup

Here we install all the tools we will use (MySQL and all the sample databases)

3. All about select

Select is the backbone of SQL. Here we practice writing select queries and also different clauses in SQL

4. Functions

Here we discuss in detail MySQL in-built functions like Date Functions, Null functions etc

5. Joins

We discuss how you can join two different tables

6. Set Operators

Here we talk about the different set operators SQL handles

7. Advanced select statements

We look in More detail at the SQL select statements

8. Modifying Data

We talk about how you can modify existing data using SQL

9. Creating Databases and Tables

Here we look at how you can create your own Databases and Tables

10. Other DDL commands

We look into Other DML commands like Drop, Truncate etc

11.Advanced SQL

Here we look at Stored procedures, Indexes, views etc

12. Bonus Section

Here I give any important information that has helped me in the field. I will always be updating this for your benefit.

This is an exciting Journey that I hope you take with me. I am not expecting you to know anything at all about SQL and will start from scratch.

Cheers!

Sandra

Who this course is for:

Beginners Interested in Business Intelligence
Anyone interested in Learning SQL
Beginners interested in Data Analysis

SQL BootCamp - Learn MySQL for Data Analysis

What you'll learn

Explore related topics

Coding Exercises

Course content

Introduction3 lectures • 12min

Environment Setup4 lectures • 36min

ALL ABOUT SELECT21 lectures • 3hr 51min

Functions13 lectures • 2hr 12min

SQL JOINS9 lectures • 1hr 24min

SET OPERATORS7 lectures • 42min

ADVANCED SELECT STATEMENTS10 lectures • 1hr 26min

OTHER DML COMMANDS8 lectures • 1hr 4min

Creating Databases and Tables7 lectures • 1hr 4min

OTHER DDL COMMANDS3 lectures • 18min

Requirements

Description

Who this course is for: