SQL Fundamentals for Marketing, Digital and Web Analytics/1. Introduction/1. Introduction.mp423.83MB
SQL Fundamentals for Marketing, Digital and Web Analytics/2. Installation and Overview of SQL Environment (MySQL)/1. Installing mySQL.mp49.29MB
SQL Fundamentals for Marketing, Digital and Web Analytics/2. Installation and Overview of SQL Environment (MySQL)/2. My SQL Interface.mp410.33MB
SQL Fundamentals for Marketing, Digital and Web Analytics/3. Database Fundamentals/1. How databases are structured.mp418.89MB
SQL Fundamentals for Marketing, Digital and Web Analytics/3. Database Fundamentals/2. Understanding a schema in MySQL.mp45.07MB
SQL Fundamentals for Marketing, Digital and Web Analytics/4. Selecting the Data/1. Write your first statement to select the data.mp45MB
SQL Fundamentals for Marketing, Digital and Web Analytics/4. Selecting the Data/2. Narrowing down your result set with WHERE clause.mp411.33MB
SQL Fundamentals for Marketing, Digital and Web Analytics/4. Selecting the Data/3. Sorting your result set.mp49.16MB
SQL Fundamentals for Marketing, Digital and Web Analytics/4. Selecting the Data/4. Using Numeric and Date Values to narrow down your result set.mp48.63MB
SQL Fundamentals for Marketing, Digital and Web Analytics/5. Other Key SQL Statements/1. Adding new records to the database.mp42.56MB
SQL Fundamentals for Marketing, Digital and Web Analytics/5. Other Key SQL Statements/2. Updating exiting records.mp47.02MB
SQL Fundamentals for Marketing, Digital and Web Analytics/5. Other Key SQL Statements/3. Deleting records.mp47.12MB
SQL Fundamentals for Marketing, Digital and Web Analytics/6. Some advanced Select Statements/1. Aggregating the data to do sum and count.mp49.63MB
SQL Fundamentals for Marketing, Digital and Web Analytics/6. Some advanced Select Statements/2. Joining multiple tables to get desired result set.mp413.04MB
SQL Fundamentals for Marketing, Digital and Web Analytics/7. Marketing Use Cases/1. Who are the top or bottom customers.mp418.77MB
SQL Fundamentals for Marketing, Digital and Web Analytics/7. Marketing Use Cases/2. How many products do we have in each category.mp413.65MB
SQL Fundamentals for Marketing, Digital and Web Analytics/8. Using data from the database in other programs/1. Exporting data to CSV or Excel file.mp46.28MB
SQL Fundamentals for Marketing, Digital and Web Analytics/8. Using data from the database in other programs/2. Connecting with Data Visualization Tool (Tableau).mp48.1MB
SQL Fundamentals for Marketing, Digital and Web Analytics/9. Database Manipulation/1. Creating a table.mp423.72MB
SQL Fundamentals for Marketing, Digital and Web Analytics/9. Database Manipulation/2. Few more table manipulation commands.mp418.66MB
SQL Fundamentals for Marketing, Digital and Web Analytics/9. Database Manipulation/3. Importing data from a CSV file - Example uses Affiliate data.mp45.09MB
SQL Fundamentals for Marketing, Digital and Web Analytics/9. Database Manipulation/4. Importing data from Excel to mySQL.mp410.71MB