This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL using MySQL for Marketing and Digital Analysis
Introduction
Introduction (1:20)
Installation and Overview of SQL Environment (MySQL)
Installing mySQL (3:35)
mySQL Interface (1:22)
Database Fundamentals
How Databases are structured (3:09)
Understanding a schema in mySQL (2:58)
New Lecture
Selecting the Data
Write Your First SQL statement to select the data from database (2:39)
Narrowing your result set (5:33)
Sorting your result set (4:01)
Using Numeric and Date Values to narrow down your result set (3:25)
Other Key SQL Statements
Adding new data to the dataabse (1:06)
Updating existing records in the database (3:23)
How to delete records from the database (3:41)
Some advanced Select Statements
How to select unique records from the database (2:11)
Aggregating the data to do sum and count (4:32)
Selecting data from multiple tables (6:44)
Marketing Use Cases
Who are the top or bottom customers? (7:31)
How many products do we have in each category? (5:09)
Using data from the database in other programs
Connecting with Data Visualization Tool (Tableau) (3:18)
Exporting data to CSV or Excel file (2:04)
Database Manipulation
Importing Data From Excel into the database (4:04)
Creating a new table (11:11)
Advanced Table Commands (8:53)
Importing data from a CSV file (2:58)
Who are the top or bottom customers?
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock