SQL Fundamentals for Marketing, Digital and Web Analytics
1. Introduction
1. Introduction.mp4
23.83 MB
1. Introduction.vtt
2.32 KB
Must Read.txt
0.53 KB
Visit Coursedrive.org.url
0.12 KB
ReadMe.txt
0.53 KB
Visit Coursedrive.org.url
0.12 KB
2. Installation and Overview of SQL Environment (MySQL)
1. Installing mySQL.mp4
9.29 MB
1. Installing mySQL.vtt
3.24 KB
2. My SQL Interface.mp4
10.33 MB
2. My SQL Interface.vtt
1.48 KB
3. Database Fundamentals
1. How databases are structured.mp4
18.89 MB
1. How databases are structured.vtt
3.38 KB
2. Understanding a schema in MySQL.mp4
5.07 MB
2. Understanding a schema in MySQL.vtt
2.90 KB
3. Missing Sakila Database and how to solve it.html
5.07 KB
ReadMe.txt
0.53 KB
Visit Coursedrive.org.url
0.12 KB
4. Selecting the Data
1. Write your first statement to select the data.mp4
5.00 MB
1. Write your first statement to select the data.vtt
2.64 KB
2. Narrowing down your result set with WHERE clause.mp4
11.33 MB
2. Narrowing down your result set with WHERE clause.vtt
4.48 KB
3. Sorting your result set.mp4
9.16 MB
3. Sorting your result set.vtt
3.89 KB
4. Using Numeric and Date Values to narrow down your result set.mp4
8.63 MB
4. Using Numeric and Date Values to narrow down your result set.vtt
3.18 KB
5. Other Key SQL Statements
1. Adding new records to the database.mp4
2.56 MB
1. Adding new records to the database.vtt
0.92 KB
2. Updating exiting records.mp4
7.02 MB
2. Updating exiting records.vtt
3.47 KB
3. Deleting records.mp4
7.12 MB
3. Deleting records.vtt
3.94 KB
6. Some advanced Select Statements
1. Aggregating the data to do sum and count.mp4
9.63 MB
1. Aggregating the data to do sum and count.vtt
4.53 KB
2. Joining multiple tables to get desired result set.mp4
13.04 MB
2. Joining multiple tables to get desired result set.vtt
6.78 KB
ReadMe.txt
0.53 KB
Visit Coursedrive.org.url
0.12 KB
7. Marketing Use Cases
1. Who are the top or bottom customers.mp4
18.77 MB
1. Who are the top or bottom customers.vtt
7.30 KB
2. How many products do we have in each category.mp4
13.65 MB
2. How many products do we have in each category.vtt
5.59 KB
8. Using data from the database in other programs
1. Exporting data to CSV or Excel file.mp4
6.28 MB
1. Exporting data to CSV or Excel file.vtt
2.19 KB
2. Connecting with Data Visualization Tool (Tableau).mp4
8.10 MB
2. Connecting with Data Visualization Tool (Tableau).vtt
3.19 KB
9. Database Manipulation
1. Creating a table.mp4
23.72 MB
1. Creating a table.vtt
13.53 KB
2. Few more table manipulation commands.mp4
18.66 MB
2. Few more table manipulation commands.vtt
10.14 KB
3. Importing data from a CSV file - Example uses Affiliate data.mp4
5.09 MB
3. Importing data from a CSV file - Example uses Affiliate data.vtt
3.44 KB
4. Importing data from Excel to mySQL.mp4
10.71 MB
4. Importing data from Excel to mySQL.vtt
4.49 KB
5. Bonus Lecture Coupons for my courses.html
0.26 KB
ReadMe.txt
0.53 KB
Visit Coursedrive.org.url
0.12 KB
Visit Coursedrive.org.url
0.12 KB
Course Downloaded from coursedrive.org.txt
0.53 KB
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch SQL Fundamentals for Marketing, Digital and Web Analytics Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.