SQL – MySQL for Data Analytics and Business Intelligence at Udemy

Overview
Curriculum
Instructor
Reviews

SQL that will get you hired – SQL for Business Analysis, Marketing, and Data Management

Well, when you can work with SQL, it means you don’t have to rely on others sending you data and executing queries for you. You can do that on your own. This allows you to be independent and dig deeper into the data to obtain the answers to questions that might improve the way your company does its business. For instance, Database management is the foundation for data analysis and intelligent decision making.

* Photos and promotional materials on this page are copyrighted on udemy.com.

We only endorse high-quality online courses and educational content. This page contains affiliate links and we may earn a small commission when you click on the link at no additional cost to you. Thank you!

Read the full policy here.

Introduction to databases, SQL, and MySQL
- What does the course cover?
- Why SQL?
- Why MySQL?
- Introduction to databases
SQL theory
- SQL as a declarative language
- Data definition language (DDL)
- SQL keywords
- Data manipulation language (DML)
- Data control language (DCL)
- Transaction control language (TCL)
Basic database terminology
- Relational database essentials
- Databases vs spreadsheets
- Database terminology
- Relational schemas – Primary key
- Relational schemas – Foreign key
- Relational schemas – Unique key and null values
- Relationships
Installing MySQL and getting acquainted with the interface
- Installing MySQL
- Setting up a connection
- New Authentication Plugin – Creating a New User
- Introduction to the MySQL interface
First steps in SQL
- Creating a Database – Part I
- Creating a Database – Part II
- Introduction to data types
- String data types
- Integers
- Fixed and floating-point data types
- Other useful data types
- Creating a table
MySQL constraints
- PRIMARY KEY constraint
- FOREIGN KEY constraint – Part I
- FOREIGN KEY constraint – Part II
- UNIQUE Constraint
- DEFAULT Constraint
- NOT NULL Constraint – Part I
- NOT NULL Constraint – Part II
SQL best practices
- Coding techniques and best practices – Part I
- Coding techniques and best practices – Part II
Loading the 'employees' database
- Loading the ’employees’ database
SQL SELECT statement
- SELECT – FROM
- WHERE
- AND
- OR
- Operator precedence
- IN – NOT IN
SQL INSERT statement
- The INSERT statement – Part I
- The INSERT statement – Part II
- Inserting data INTO a new table
SQL UPDATE Statement
- TCL’s COMMIT and ROLLBACK
- The UPDATE Statement – Part I
- The UPDATE Statement – Part II
SQL DELETE Statement
- The DELETE Statement – Part I
- The DELETE Statement – Part II
- DROP vs TRUNCATE vs DELETE
MySQL - Aggregate functions
- COUNT()
- SUM()
- MIN() and MAX()
- AVG()
- ROUND()
- IFNULL() and COALESCE()
- Another Example of Using COALESCE()
SQL Joins
- Introduction to JOINs
- INNER JOIN – Part I
- INNER JOIN – Part II
- A Note on Using Joins
- Duplicate Records
- LEFT JOIN – Part I
- LEFT JOIN – Part II
- RIGHT JOIN
- The new and the old join syntax
SQL Subqueries
- SQL Subqueries with IN nested inside WHERE
- SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE
- SQL Subqueries nested in SELECT and FROM
SQL Self Join
- Self Join
SQL Views
- Views
Stored routines
- Introduction to stored routines
- Stored procedures – Example – Part I
- Stored procedures – Example – Part II
- Another way to create a procedure
- Stored procedures with an input parameter
- Stored procedures with an output parameter
Advanced SQL Topics
- Types of MySQL Variables – Local Variables
- Session Variables
- Global Variables
- User-Defined vs System Variables
- MySQL Triggers
- MySQL Indexes
- The CASE Statement
Combining SQL and Tableau - Introduction
- The Advantages of Software Integration
- Why Combining SQL and Tableau is useful
- Installing Tableau Public
- Loading the ’employees_mod’ Database
Combining SQL and Tableau - Task 1
- Task 1
- Task 1: SQL Solution
- Transferring a Dataset from SQL to Tableau
- Chart 1: Visualizing and Analyzing the Solution in Tableau – Part I
- Chart 1: Visualizing and Analyzing the Solution in Tableau – Part II
Combining SQL and Tableau - Task 2
- Task 2
- Task 2: SQL Solution
- Chart 2: Visualizing and Analyzing the Solution in Tableau
Combining SQL and Tableau - Task 3
- Task 3
- Task 3: SQL Solution
- Chart 3: Visualizing and Analyzing the Solution in Tableau
Combining SQL and Tableau - Task 4
- Task 4
- Task 4: Solution in SQL
- Chart 4: Visualizing and Analyzing the Solution in Tableau
Combining SQL and Tableau - Task 5
- Task 5: Organizing Charts 1-4 into a Beautiful Dashboard using Tableau
Practice SQL - 10 Final Query Questions
- Practice SQL – 10 Final Query Questions
BONUS LECTURE
- Bonus Lecture: Next Steps

UDEMY

0.0

0 total

SQL – MySQL for Data Analytics and Business Intelligence at Udemy

SQL – MySQL for Data Analytics and Business Intelligence at Udemy

Introduction to databases, SQL, and MySQL

SQL theory

Basic database terminology

Installing MySQL and getting acquainted with the interface

First steps in SQL

MySQL constraints

SQL best practices

Loading the 'employees' database

SQL SELECT statement

SQL INSERT statement

SQL UPDATE Statement

SQL DELETE Statement

MySQL - Aggregate functions

SQL Joins

SQL Subqueries

SQL Self Join

SQL Views

Stored routines

Advanced SQL Topics

Combining SQL and Tableau - Introduction

Combining SQL and Tableau - Task 1

Combining SQL and Tableau - Task 2

Combining SQL and Tableau - Task 3

Combining SQL and Tableau - Task 4

Combining SQL and Tableau - Task 5

Practice SQL - 10 Final Query Questions

BONUS LECTURE

Leave A Reply Cancel reply

More courses you might like

What you'll learn

B2B Marketing at LinkedIn Learning

What you'll learn

Diane von Furstenberg Teaches Building a Fashion Brand at MasterClass

What you'll learn

David Axelrod and Karl Rove Teach Campaign Strategy and Messaging at MasterClass

What you'll learn

Howard Schultz Business Leadership at MasterClass

Join Our Mailing List

Access exclusive discount codes and special offers for premium courses​

Explore

Connect

Follow Us

Modal title

Access exclusive discount codes and special offers for premium courses