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)
Teach online with
Importing data from a CSV file
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock