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
Facilities
Location
Start date
Online
Start date
Different dates availableEnrolment now open
About this course
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
Web Analysts
Digital Analyst
Marketers
Business Analyst
Questions & Answers
Add your question
Our advisors and other users will be able to reply to you
We are verifying your question adjusts to our publishing rules. According to your answers, we noticed you might not be elegible to enroll into this course, possibly because of: qualification requirements, location or others. It is important you consult this with the Centre.
Thank you!
We are reviewing your question. We will publish it shortly.
Or do you prefer the center to contact you?
Reviews
Have you taken this course? Share your opinion
This centre's achievements
2021
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 4 years
Subjects
Web
Digital Marketing
Marketing
Database training
SQL
Database
MySQL
Server
Course programme
Introduction
1 lecture01:20Introduction Marketers and Marketing Analysts generally rely on others to run SQL queries and get data. By learning SQL you will be doing a huge help to yourself so that you are not waiting on IT. This will also allow you to understand what data is available. This course is designed for Marketers by a Marketer. I won't do a lot of technical speak, just enough for you to understand. In addition to learning SQL, you will learn how you can apply it your marketing USE CASES. If your use case is not covered, I will be happy to add it.
Introduction
1 lecture01:20Introduction Marketers and Marketing Analysts generally rely on others to run SQL queries and get data. By learning SQL you will be doing a huge help to yourself so that you are not waiting on IT. This will also allow you to understand what data is available. This course is designed for Marketers by a Marketer. I won't do a lot of technical speak, just enough for you to understand. In addition to learning SQL, you will learn how you can apply it your marketing USE CASES. If your use case is not covered, I will be happy to add it.
Introduction Marketers and Marketing Analysts generally rely on others to run SQL queries and get data. By learning SQL you will be doing a huge help to yourself so that you are not waiting on IT. This will also allow you to understand what data is available. This course is designed for Marketers by a Marketer. I won't do a lot of technical speak, just enough for you to understand. In addition to learning SQL, you will learn how you can apply it your marketing USE CASES. If your use case is not covered, I will be happy to add it.
Introduction Marketers and Marketing Analysts generally rely on others to run SQL queries and get data. By learning SQL you will be doing a huge help to yourself so that you are not waiting on IT. This will also allow you to understand what data is available. This course is designed for Marketers by a Marketer. I won't do a lot of technical speak, just enough for you to understand. In addition to learning SQL, you will learn how you can apply it your marketing USE CASES. If your use case is not covered, I will be happy to add it.
Introduction Marketers and Marketing Analysts generally rely on others to run SQL queries and get data. By learning SQL you will be doing a huge help to yourself so that you are not waiting on IT. This will also allow you to understand what data is available. This course is designed for Marketers by a Marketer. I won't do a lot of technical speak, just enough for you to understand. In addition to learning SQL, you will learn how you can apply it your marketing USE CASES. If your use case is not covered, I will be happy to add it.
Introduction Marketers and Marketing Analysts generally rely on others to run SQL queries and get data. By learning SQL you will be doing a huge help to yourself so that you are not waiting on IT. This will also allow you to understand what data is available. This course is designed for Marketers by a Marketer. I won't do a lot of technical speak, just enough for you to understand. In addition to learning SQL, you will learn how you can apply it your marketing USE CASES. If your use case is not covered, I will be happy to add it.
Marketers and Marketing Analysts generally rely on others to run SQL queries and get data. By learning SQL you will be doing a huge help to yourself so that you are not waiting on IT. This will also allow you to understand what data is available. This course is designed for Marketers by a Marketer. I won't do a lot of technical speak, just enough for you to understand. In addition to learning SQL, you will learn how you can apply it your marketing USE CASES. If your use case is not covered, I will be happy to add it.
Marketers and Marketing Analysts generally rely on others to run SQL queries and get data. By learning SQL you will be doing a huge help to yourself so that you are not waiting on IT. This will also allow you to understand what data is available. This course is designed for Marketers by a Marketer. I won't do a lot of technical speak, just enough for you to understand. In addition to learning SQL, you will learn how you can apply it your marketing USE CASES. If your use case is not covered, I will be happy to add it.
Installation and Overview of SQL Environment (MySQL)
2 lectures04:57Installing mySQL This lecture will show you where to download MySQL. We will be using MySQL in this course. Anything that is taught in this course is applicable to other database such as MS SQL Server, Oracle etc.My SQL Interface This lecture will walk you through MySQL interface. This is where you will practice your SQL queries.
Installation and Overview of SQL Environment (MySQL)
2 lectures04:57Installing mySQL This lecture will show you where to download MySQL. We will be using MySQL in this course. Anything that is taught in this course is applicable to other database such as MS SQL Server, Oracle etc.My SQL Interface This lecture will walk you through MySQL interface. This is where you will practice your SQL queries.
Installing mySQL This lecture will show you where to download MySQL. We will be using MySQL in this course. Anything that is taught in this course is applicable to other database such as MS SQL Server, Oracle etc.
Installing mySQL This lecture will show you where to download MySQL. We will be using MySQL in this course. Anything that is taught in this course is applicable to other database such as MS SQL Server, Oracle etc.
Installing mySQL This lecture will show you where to download MySQL. We will be using MySQL in this course. Anything that is taught in this course is applicable to other database such as MS SQL Server, Oracle etc.
Installing mySQL This lecture will show you where to download MySQL. We will be using MySQL in this course. Anything that is taught in this course is applicable to other database such as MS SQL Server, Oracle etc.
This lecture will show you where to download MySQL. We will be using MySQL in this course. Anything that is taught in this course is applicable to other database such as MS SQL Server, Oracle etc.
This lecture will show you where to download MySQL. We will be using MySQL in this course. Anything that is taught in this course is applicable to other database such as MS SQL Server, Oracle etc.
My SQL Interface This lecture will walk you through MySQL interface. This is where you will practice your SQL queries.
My SQL Interface This lecture will walk you through MySQL interface. This is where you will practice your SQL queries.
My SQL Interface This lecture will walk you through MySQL interface. This is where you will practice your SQL queries.
My SQL Interface This lecture will walk you through MySQL interface. This is where you will practice your SQL queries.
This lecture will walk you through MySQL interface. This is where you will practice your SQL queries.
This lecture will walk you through MySQL interface. This is where you will practice your SQL queries.
Database Fundamentals
2 lectures06:08How databases are structured Learn about various elements of a database and learn what does relational database means. Understanding a schema in MySQL Before you can write SQL it is critical to understand what all is in the database. This lecture will help you with it.
Database Fundamentals
2 lectures06:08How databases are structured Learn about various elements of a database and learn what does relational database means. Understanding a schema in MySQL Before you can write SQL it is critical to understand what all is in the database. This lecture will help you with it.
How databases are structured Learn about various elements of a database and learn what does relational database means.
How databases are structured Learn about various elements of a database and learn what does relational database means.
How databases are structured Learn about various elements of a database and learn what does relational database means.
How databases are structured Learn about various elements of a database and learn what does relational database means.
Learn about various elements of a database and learn what does relational database means.
Learn about various elements of a database and learn what does relational database means.
Understanding a schema in MySQL Before you can write SQL it is critical to understand what all is in the database. This lecture will help you with it.
Understanding a schema in MySQL Before you can write SQL it is critical to understand what all is in the database. This lecture will help you with it.
Understanding a schema in MySQL Before you can write SQL it is critical to understand what all is in the database. This lecture will help you with it.
Understanding a schema in MySQL Before you can write SQL it is critical to understand what all is in the database. This lecture will help you with it.
Before you can write SQL it is critical to understand what all is in the database. This lecture will help you with it.
Before you can write SQL it is critical to understand what all is in the database. This lecture will help you with it.
Selecting the Data
5 lectures17:52Write your first statement to select the data SELECT is the statement that you will end up using majority of the time. Learn how to write a SELECT statement to find the data that you are looking for. Narrowing down your result set with WHERE clause Learn how to use WHERE clause to narrow down your data. Learn the usage of AND and OR operators to narrow down your result set.Sorting your result set This lecture will show you how to sort the result set to give you the order that you need.Using Numeric and Date Values to narrow down your result set You will learn how to use numeric and date values to narrow down your result set along with string values to get exactly the result set that you need. You will learn about =, >,<, >=, <= and between clauses.Distinct Statement
Selecting the Data.
5 lectures17:52Write your first statement to select the data SELECT is the statement that you will end up using majority of the time. Learn how to write a SELECT statement to find the data that you are looking for. Narrowing down your result set with WHERE clause Learn how to use WHERE clause to narrow down your data. Learn the usage of AND and OR operators to narrow down your result set.Sorting your result set This lecture will show you how to sort the result set to give you the order that you need.Using Numeric and Date Values to narrow down your result set You will learn how to use numeric and date values to narrow down your result set along with string values to get exactly the result set that you need. You will learn about =, >,<, >=, <= and between clauses.Distinct StatementWrite your first statement to select the data SELECT is the statement that you will end up using majority of the time. Learn how to write a SELECT statement to find the data that you are looking for.
Write your first statement to select the data SELECT is the statement that you will end up using majority of the time. Learn how to write a SELECT statement to find the data that you are looking for.
Write your first statement to select the data SELECT is the statement that you will end up using majority of the time. Learn how to write a SELECT statement to find the data that you are looking for.
Write your first statement to select the data SELECT is the statement that you will end up using majority of the time. Learn how to write a SELECT statement to find the data that you are looking for.
SELECT is the statement that you will end up using majority of the time. Learn how to write a SELECT statement to find the data that you are looking for.
SELECT is the statement that you will end up using majority of the time. Learn how to write a SELECT statement to find the data that you are looking for.
Narrowing down your result set with WHERE clause Learn how to use WHERE clause to narrow down your data. Learn the usage of AND and OR operators to narrow down your result set.
Narrowing down your result set with WHERE clause Learn how to use WHERE clause to narrow down your data. Learn the usage of AND and OR operators to narrow down your result set.
Narrowing down your result set with WHERE clause Learn how to use WHERE clause to narrow down your data. Learn the usage of AND and OR operators to narrow down your result set.
Narrowing down your result set with WHERE clause Learn how to use WHERE clause to narrow down your data. Learn the usage of AND and OR operators to narrow down your result set.
Learn how to use WHERE clause to narrow down your data. Learn the usage of AND and OR operators to narrow down your result set.
Learn how to use WHERE clause to narrow down your data. Learn the usage of AND and OR operators to narrow down your result set.
Sorting your result set This lecture will show you how to sort the result set to give you the order that you need.
Sorting your result set This lecture will show you how to sort the result set to give you the order that you need t marketers need to figure out? They want to know which customers are paying us the most money. Learn how to do this via SQL. You will also learn a new SQL syntax to find out TOP...
