Data is a critical part of any job these days. Having SQL skills will help you accomplish many of the data task that your job requires. Whether you are trying to add new skills to enhance your career or looking for a new job, this course will help you add a critical skill that many jobs and employers seek today. SQL skills help you succeed in a large number of careers that range from technical to business.
This course will teach you everything you need to start using SQL and practicing SQL. I used to be a technical guy who turned into a marketer. In this course I have taken all the complex technical speak out so that anybody can learn SQL. This course is designed to make each step very easy to understand. I used the same methods that I use to teach business analysts and marketing analysts in my own group.
The course should not take full day, you can learn during your work day and practice as you go.
Note: This is a beginner level course. If you have prior knowledge of SQL than this course might serve as refresher but won't teach you advanced concepts.
First step of learn SQL is to get familiar with the interface on where you will be writing SQL. This lecture teaches you exactly that.
Before you can write SQL it is critical to understand what all is in the database. This lecture will help you with it.
In this quiz you will be tested on what you just learned.
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.
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.
This lecture will show you how to sort the result set to give you the order that you need.
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.
Marketing database are full of erroneous data. This lecture will teach you how to fix the data issues when you find them.
Counting and summing are two common functions that Marketers need to do to identify their targets. Learn the syntax in this lecture.
You will learn how to join multiple tables and use of table alias.
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.