Microsoft SQL Server for Marketing Analysis
Learn how to use Microsoft SQL server for Marketing Analysis
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 Microsoft SQL Server to show how SQL works.
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.
Anil is a seasoned Digital Marketing and Analytics professional with 15 years of experience. He has worked with companies ranging from Fortune 50 to startups and has helped them improve marketing results. His customers include Microsoft, SmartMoney, ESPN, T-Mobile, Hoovers, RealNetworks, Starbucks, and TheStreet. He holds a B. Tech in Electronics and Communication Engineering from India and an MBA from University of Washington, Seattle.
Anil has taught and trained several Marketing and Analytics folks in past nine years of teaching at UBC, University of Washington and Bellevue College, and speaking engagements at various conferences as well as his blog. He teaches Digital Marketing, Digital Analytics, Google Analytics, Tableau and Social Media courses. He also served on the Board of Digital Analytics Association (DAA) and was instrumental in starting the DAA Symposiums.
Anil is the founder of Global Analytics Academy.
StartSQL Query to Select Data from a Table (12:39)
StartSelecting top N records (5:04)
StartNarrowing down result set with WHERE clause (7:20)
StartPattern Matching in WHERE clause using LIKE (4:46)
StartWhere In... SQL Clause - Using Multiple values from a column in Where Clause (5:05)
StartSorting the Result set (4:48)
StartSelecting unique values (3:08)
StartJoining multiple tables to get the desired result set (10:25)
StartUsing Alias in SQL (7:38)
StartAggregating the Data in SQL - Count, Min and Max (13:04)
StartAggregating Data - Sum and Average (4:05)
StartNull Values in Aggregations (3:52)
StartUsing Aggregated Values in WHERE Clause (4:04)