SQL BootCamp - Learn MySQL for Data Analysis

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

4.50 (16 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
67
students
15 hours
content
Apr 2021
last update
$54.99
regular price

What you will 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

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


Content

Introduction

Welcome
Course Outline
Introduction to SQL

Environment Setup

Downloading MySQL for Mac OS
Downloading MySQL for windows OS
Downloading sample database 1
Downloading sample database 2

ALL ABOUT SELECT

What you will learn in this Section
SELECT Using WHERE and DISTINCT
SELECT Using WHERE and DISTINCT Cont.
AND Operator 1
AND Operator 2
OR Operator
NOT Operator
AND, OR, NOT
ARITHMETIC OPERATIONS
COMPARISON OPERATIONS
IN OPERATIONS
BETWEEN OPERATOR
LIKE OPERATOR 1
LIKE OPERATOR 2
ALIASES
LIMIT, MAX AND MIN FUNCTIONS 1
LIMIT, MAX AND MIN FUNCTIONS 2
AVG, COUNT and SUM FUNCTIONS
Using Order and Group By Clauses
Using HAVING and ROLLUP CLAUSE
Section Recap
Coding Exercise on Select

Functions

All about Functions
Cast and Convert
Null Functions
Using COALESCE
DATE FUNCTION 1
DATE FUNCTION 2
DATE FUNCTIONS 3
DATE CHALLENGE ANSWER
Using CONCAT Function
String Function - INSTRING
String Function - LOWER and UPPER
Replace and Trim
SECTION RECAP
Coding Exercise on Functions

SQL JOINS

Section Intro
Inner Join
Left Join 1
Left Join 2
Right Join
Cross Join
Self Join 1
Self Join 2
SECTION RECAP
Coding exercise on SQL Joins

SET OPERATORS

Section Intro
UNION OPERATOR
FULL OUTER JOIN USING THE UNION OPERATOR
FULL OUTER JOIN USING THE UNION OPERATOR 2
INTERSECT OPERATOR
MINUS OPERATOR
SECTION RECAP
QUIZ ON SET OPERATORS

ADVANCED SELECT STATEMENTS

Section Intro
CASE STATEMENT
CASE STATEMENT 2
SUBQUERY
DERIVED TABLE 1
DERIVED TABLE 2
DERIVED TABLE 3
Using EXISTS
COMMON TABLE EXPRESSIONS (CTE)
SECTION RECAP
Coding Exercise on Advanced SQL statements

OTHER DML COMMANDS

Section Intro
INSERT STATEMENT
INSERT INTO SELECT 1
INSERT INTO SELECT 2
UPDATE STATEMENT
DELETE STATEMENT
REPLACE STATEMENT
SECTION RECAP
Coding Exercise on Other DML commands

Creating Databases and Tables

Section Intro
SQL Datatypes
SQL Constraints
Create Database and Table 1
Create Database and Table 2
Create Database and Table 3
Create Table Like
Coding Exercise on Creating Databases and Tables

OTHER DDL COMMANDS

Section Intro
DROP and TRUNCATE
ALTER TABLE
Quiz on Other DDL Commands

ADVANCED SQL STATEMENTS

Section Intro
VIEWS
INDEXES 1
INDEXES 2
SQL Trigger 1
SQL Trigger 2
STORED PROCEDURE
Stored procedure using In Parameter
Stored procedure using OUT Parameter.mp4
Remove, Alter, List Stored procedure
SECTION RECAP

Other Important Details

Importing and exporting CSV files
Identifying duplicates

Screenshots

SQL BootCamp - Learn MySQL for Data Analysis - Screenshot_01SQL BootCamp - Learn MySQL for Data Analysis - Screenshot_02SQL BootCamp - Learn MySQL for Data Analysis - Screenshot_03SQL BootCamp - Learn MySQL for Data Analysis - Screenshot_04

Reviews

Anele
January 22, 2023
Tutor seems unprepared and all over the place. I am not convinced that she actually went through her course content before doing the tutorial. She's making me anxious.
Winne
July 8, 2021
This course was exactly what I was looking for. As a beginner, I found it difficult understanding the basic concepts of SQL but this instructor really broke it down in a way I understood. Thanks Sandra
Odafe
April 15, 2021
Amazing course. Instructor took her time explaining all sql concepts from select to more advanced statements. I really enjoyed it

Charts

Price

SQL BootCamp - Learn MySQL for Data Analysis - Price chart

Rating

SQL BootCamp - Learn MySQL for Data Analysis - Ratings chart

Enrollment distribution

SQL BootCamp - Learn MySQL for Data Analysis - Distribution chart
3954348
udemy ID
4/2/2021
course created date
4/19/2021
course indexed date
Bot
course submited by