17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
SQL Fundamentals For Marketing, Digital And Web Analytics
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
SQL Fundamentals for Marketing, Digital and Web Analytics Download
Learn SQL for Marketers, Marketing, Digital and Web Analytics. Learn the only SQL required for Marketing Analysis
What you'll learn
Write and Understand SQL to pull the data for marketing Grasp Database fundamentals Understanding of how data is structures and stored in databases Master common SQL commands used by Marketing analysts Import data into MySQL from CSV and Excel files Export data from MySQL into Excel files Connect MySQL with Tableau for data visualization Use Databases and SQL with confidence Learn some common uses cases for Marketing, Web and Digital Analytics
Requirements
Basic computer skills
Description
Data is a requirement these days to run effective marketing campaigns. Application of Big Data starts with understanding the fundamentals of data and SQL.
If you are already familiar with SQL then you can skip this course. This course teaches you all the SQL you need as a Digital Marketing Analyst or a Web Analyst. This course won't go into advanced level SQL concepts as that is not required to your job as as a Digital Marketing Analyst/Web Analyst. I strongly believe in short and simple courses that can get you ready in few hours as opposed to days.
However, if you ever get stuck or need something that I don't cover in this course then feel free to reach out to me.
Marketers and Marketing Analysts generally depend on the tools or IT department to help them pull the data for marketing purposes. IT leaves you hanging because they have other priorities as a results Marketing Analysts have to know how write SQL on their own so that they are not dependent on IT. This course is for those marketers who would like to know how to use SQL to conduct their marketing analysis.
If you are trying for a job as a Marketing Analysts then this course is a must for you. This will help your resume shine and put you ahead of other similar candidates. The more you can handle technology and data these days the better it differentiates you from the rest of the pack.
The course uses MYSQL to show how SQL works but all the leanings and syntax are applicable to other databases such Microsoft SQL Server and Oracle as well.
This course is a must have for Web Analytics, Digital Analytics and Marketing Analytics. This course will put you way ahead of other folks doing or seeking similar jobs. I have used the same course to train members of my team so you can be assured that this is tried and tested curriculum.
Why you should learn from me?
I have been in Digital Marketing and Analytics for over 15 years. I have trained people from diverse backgrounds and have converted them into high performing Digital Marketers and Analysts. I understand both the technology and marketing side of business. I have dealt with many analytics technologies way before Google Tag manager existed and know the inner working of Digital Analytics.
I have extensively worked with companies like Microsoft, Starbucks, Wall Street Journal, ESPN, T-Mobile to name few and helped them Data Driven Marketing Decisions.
In addition, I have developed various course and taught students from all over the world. I am online instructor for University of British Columbia (Canada), University of Washington (USA), Bellevue College (USA) and Digital Analytics Association.
I have an engineering degrees and an MBA.
Who this course is for:
Web Analysts Digital Analyst Marketers Business Analyst
Visit the udemy course downloader
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
SQL Fundamentals for Marketing, Digital and Web Analytics/1. Introduction/1. Introduction.mp4
23.8 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/1. Introduction/1. Introduction.vtt
2.3 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/1. Introduction/Must Read.txt
540 B
SQL Fundamentals for Marketing, Digital and Web Analytics/2. Installation and Overview of SQL Environment (MySQL)/1. Installing mySQL.mp4
9.3 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/2. Installation and Overview of SQL Environment (MySQL)/1. Installing mySQL.vtt
3.2 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/2. Installation and Overview of SQL Environment (MySQL)/2. My SQL Interface.mp4
10.3 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/2. Installation and Overview of SQL Environment (MySQL)/2. My SQL Interface.vtt
1.5 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/3. Database Fundamentals/1. How databases are structured.mp4
18.9 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/3. Database Fundamentals/1. How databases are structured.vtt
3.4 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/3. Database Fundamentals/2. Understanding a schema in MySQL.mp4
5.1 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/3. Database Fundamentals/2. Understanding a schema in MySQL.vtt
2.9 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/3. Database Fundamentals/3. Missing Sakila Database and how to solve it.html
5.1 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/3. Database Fundamentals/ReadMe.txt
538 B
SQL Fundamentals for Marketing, Digital and Web Analytics/4. Selecting the Data/1. Write your first statement to select the data.mp4
5 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/4. Selecting the Data/1. Write your first statement to select the data.vtt
2.6 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/4. Selecting the Data/2. Narrowing down your result set with WHERE clause.mp4
11.3 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/4. Selecting the Data/2. Narrowing down your result set with WHERE clause.vtt
4.5 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/4. Selecting the Data/3. Sorting your result set.mp4
9.2 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/4. Selecting the Data/3. Sorting your result set.vtt
3.9 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/4. Selecting the Data/4. Using Numeric and Date Values to narrow down your result set.mp4
8.6 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/4. Selecting the Data/4. Using Numeric and Date Values to narrow down your result set.vtt
3.2 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/5. Other Key SQL Statements/1. Adding new records to the database.mp4
2.6 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/5. Other Key SQL Statements/1. Adding new records to the database.vtt
944 B
SQL Fundamentals for Marketing, Digital and Web Analytics/5. Other Key SQL Statements/2. Updating exiting records.mp4
7 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/5. Other Key SQL Statements/2. Updating exiting records.vtt
3.5 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/5. Other Key SQL Statements/3. Deleting records.mp4
7.1 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/5. Other Key SQL Statements/3. Deleting records.vtt
3.9 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/6. Some advanced Select Statements/1. Aggregating the data to do sum and count.mp4
9.6 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/6. Some advanced Select Statements/1. Aggregating the data to do sum and count.vtt
4.5 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/6. Some advanced Select Statements/2. Joining multiple tables to get desired result set.mp4
13 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/6. Some advanced Select Statements/2. Joining multiple tables to get desired result set.vtt
6.8 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/6. Some advanced Select Statements/ReadMe.txt
538 B
SQL Fundamentals for Marketing, Digital and Web Analytics/7. Marketing Use Cases/1. Who are the top or bottom customers.mp4
18.8 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/7. Marketing Use Cases/1. Who are the top or bottom customers.vtt
7.3 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/7. Marketing Use Cases/2. How many products do we have in each category.mp4
13.6 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/7. Marketing Use Cases/2. How many products do we have in each category.vtt
5.6 KB
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.mp4
6.3 MB
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.vtt
2.2 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/8. Using data from the database in other programs/2. Connecting with Data Visualization Tool (Tableau).mp4
8.1 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/8. Using data from the database in other programs/2. Connecting with Data Visualization Tool (Tableau).vtt
3.2 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/9. Database Manipulation/1. Creating a table.mp4
23.7 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/9. Database Manipulation/1. Creating a table.vtt
13.5 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/9. Database Manipulation/2. Few more table manipulation commands.mp4
18.7 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/9. Database Manipulation/2. Few more table manipulation commands.vtt
10.1 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/9. Database Manipulation/3. Importing data from a CSV file - Example uses Affiliate data.mp4
5.1 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/9. Database Manipulation/3. Importing data from a CSV file - Example uses Affiliate data.vtt
3.4 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/9. Database Manipulation/4. Importing data from Excel to mySQL.mp4
10.7 MB
SQL Fundamentals for Marketing, Digital and Web Analytics/9. Database Manipulation/4. Importing data from Excel to mySQL.vtt
4.5 KB
SQL Fundamentals for Marketing, Digital and Web Analytics/9. Database Manipulation/5. Bonus Lecture Coupons for my courses.html
269 B
SQL Fundamentals for Marketing, Digital and Web Analytics/9. Database Manipulation/ReadMe.txt
538 B
SQL Fundamentals for Marketing, Digital and Web Analytics/ReadMe.txt
