SQL Fundamentals for Marketing Digital and Web Analytics | 2B5D31E45E1A80A8A39655FDA1C8E1C3C6B139D9

SQL Fundamentals for Marketing Digital and Web Analytics

Name	SQL Fundamentals for Marketing, Digital and Web Analytics	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	257.9 MB
Total Files	58
Hash	2B5D31E45E1A80A8A39655FDA1C8E1C3C6B139D9

/1. Introduction/
1. Introduction.mp4	25.0 MB
1. Introduction.vtt	2.4 KB
Must Read.txt	0.5 KB
Visit Coursedrive.org.url	0.1 KB
/
Visit Coursedrive.org.url	0.1 KB
Course Downloaded from coursedrive.org.txt	0.5 KB
/SQL Fundamentals for Marketing, Digital and Web Analytics/
ReadMe.txt	0.5 KB
Visit Coursedrive.org.url	0.1 KB
/.../2. Installation and Overview of SQL Environment (MySQL)/
1. Installing mySQL.mp4	9.7 MB
1. Installing mySQL.vtt	3.3 KB
2. My SQL Interface.mp4	10.8 MB
2. My SQL Interface.vtt	1.5 KB
/3. Database Fundamentals/
1. How databases are structured.mp4	19.8 MB
1. How databases are structured.vtt	3.5 KB
2. Understanding a schema in MySQL.mp4	5.3 MB
2. Understanding a schema in MySQL.vtt	3.0 KB
3. Missing Sakila Database and how to solve it.html	5.2 KB
ReadMe.txt	0.5 KB
Visit Coursedrive.org.url	0.1 KB
/.../4. Selecting the Data/
1. Write your first statement to select the data.mp4	5.2 MB
1. Write your first statement to select the data.vtt	2.7 KB
2. Narrowing down your result set with WHERE clause.mp4	11.9 MB
2. Narrowing down your result set with WHERE clause.vtt	4.6 KB
3. Sorting your result set.mp4	9.6 MB
3. Sorting your result set.vtt	4.0 KB
4. Using Numeric and Date Values to narrow down your result set.mp4	9.0 MB
4. Using Numeric and Date Values to narrow down your result set.vtt	3.3 KB
/.../5. Other Key SQL Statements/
1. Adding new records to the database.mp4	2.7 MB
1. Adding new records to the database.vtt	0.9 KB
2. Updating exiting records.mp4	7.4 MB
2. Updating exiting records.vtt	3.6 KB
3. Deleting records.mp4	7.5 MB
3. Deleting records.vtt	4.0 KB
/.../6. Some advanced Select Statements/
1. Aggregating the data to do sum and count.mp4	10.1 MB
1. Aggregating the data to do sum and count.vtt	4.6 KB
2. Joining multiple tables to get desired result set.mp4	13.7 MB
2. Joining multiple tables to get desired result set.vtt	6.9 KB
ReadMe.txt	0.5 KB
Visit Coursedrive.org.url	0.1 KB
/.../7. Marketing Use Cases/
1. Who are the top or bottom customers.mp4	19.7 MB
1. Who are the top or bottom customers.vtt	7.5 KB
2. How many products do we have in each category.mp4	14.3 MB
2. How many products do we have in each category.vtt	5.7 KB
/.../8. Using data from the database in other programs/
1. Exporting data to CSV or Excel file.mp4	6.6 MB
1. Exporting data to CSV or Excel file.vtt	2.2 KB
2. Connecting with Data Visualization Tool (Tableau).mp4	8.5 MB
2. Connecting with Data Visualization Tool (Tableau).vtt	3.3 KB
/9. Database Manipulation/
1. Creating a table.mp4	24.9 MB
1. Creating a table.vtt	13.9 KB
2. Few more table manipulation commands.mp4	19.6 MB
2. Few more table manipulation commands.vtt	10.4 KB
3. Importing data from a CSV file - Example uses Affiliate data.mp4	5.3 MB
3. Importing data from a CSV file - Example uses Affiliate data.vtt	3.5 KB
4. Importing data from Excel to mySQL.mp4	11.2 MB
4. Importing data from Excel to mySQL.vtt	4.6 KB
5. Bonus Lecture Coupons for my courses.html	0.3 KB
ReadMe.txt	0.5 KB
Visit Coursedrive.org.url	0.1 KB
Total files 58