Back to articles list April 2, 2020 - 7 minutes read Are There Any Good SQL Courses for Marketers? Kate Stolarek Hi, I’m Kate! I’m a growth marketer striving for excellence. I work in the cold emailing sector where I focus on finding innovative ideas to drive user acquisition. I also host webinars and write (mainly) about SQL. Let’s connect on LinkedIn or Twitter and grow something together! :) Tags: sql learn sql marketing jobs and career Looking for places to learn SQL online and level up your marketing efforts? Check out these SQL courses. Introduction With the help of IT experts, meticulous marketers analyze information to create advertising strategies. This commonplace state of affairs forces the marketer to rely on data experts and sometimes wait for their availability. But what if marketers could pull the data themselves? They can – by turning into a technical marketer. SQL (Structured Query Language) plays quite an important role in the dynamics of marketing. And no wonder: it is the easiest and most common language used for data analysis. SQL has had its ups and downs, but its versatility means it's getting back on track. It’s even stronger because both data professionals and business professionals have started to understand the power of SQL. In this article, I’m reviewing four SQL courses designed with marketers in mind: SQL Tutorial for Marketers by DataCamp An Introductory SQL Tutorial: How to Write Simple Queries by HubSpot SQL for Marketers on Udemy SQL Basics by LearnSQL.com #1 SQL Tutorial for Marketers DataCamp’s SQL Tutorial for Marketers is an interactive online course. It teaches the fundamentals of SQL: simple SELECT statements, filtering rows, limiting results, and counting data. The course is a mix of exercises, including writing SQL queries to answer exercise questions. Sometimes you can guess the answer without writing any code, e.g. when there’s no space for coding or when the assertion is not implemented (meaning your code is not being verified). Solving exercises gains you XP points. Whenever you take a Hint or Show Solution, XP points are deducted from your total. Fun fact: You cannot exchange your points for anything. Pros The course is free. No prior experience in SQL or databases needed. There is a space to write SQL queries. The first few exercises introduce you to the platform and explain how to use it. You collect XP points, which is satisfying. There is no certificate, but you can download a “Statement of Accomplishment.” Cons In some exercises, the code is not checked, so it’s possible to just guess the answer. Some instructions ask for providing the first item listed in the query result, which is not how SQL works. In SQL, order is not an inherent property of a dataset. Thus, there’s no guarantee that data will come back in a certain (and repetitive) order unless your query includes the ORDER BY clause. This information is important, especially for beginners, and may help you avoid some stupid mistakes. You won’t find out how to set up SQL tools on your computer. Switching between a dark or light interface is not global – you can only change the color of the console where you type SQL queries. What’s the point of that? My eyes hurt even more from the contrast. The last exercise was a disappointment. I gave away 3 XP to see the hint, which was “Will you continue to learn SQL?”. It could have been a discount code, at least... #2 An Introductory SQL Tutorial: How to Write Simple Queries This short HubSpot tutorial is a pleasant introduction to SQL. Because it only presents how simple SQL statements work, I wouldn’t call it a course. Still, a hesitant learner will definitely appreciate it, so I couldn’t not mention it. The author clearly describes what SQL is and why you should use it. They also underline the importance of understanding database hierarchy and give examples of how to: Retrieve data with a simple SELECT. Filter records using WHERE. Group rows with the GROUP BY clause and differentiate GROUP BY from ORDER BY. Count the number of times a criterium meets a condition. Join tables with INNER JOIN. Pros The tutorial is free. It’s short and concisely covers the very basics of SQL. It’s a good primer for learning SQL. Cons There are no exercises to solve. The tutorial lacks graphics that illustrate the various descriptions. #3 SQL for Marketers SQL for Marketers is an online course by Justin Mares that you can purchase on Udemy. The course consists of videos (over four hours of lectures) and some assignments. It covers: What SQL is. How data is structured in SQL. How the SELECT, FROM, WHERE, GROUP BY statements work. How to limit, sort, and join tables. How to set up SQL tools. Why you should use SQL. I did some research about the course author and he describes himself as “on a mission to improve the health and wellness of 1mm+ people over the next decade”. Not sure how this is connected with SQL and marketing. (Justin, if you’re reading this, you need to get your bio fixed.) The guy is definitely smart. But is he good at teaching SQL? Don’t get me wrong. Justin could have experience working with SQL, but there’s no info about it. And the way he teaches SQL through the course doesn’t meet best practices: It’s chaotic and jumps from subject to subject. Generally speaking, I’m not a fan of learning marketplaces because you never know who the tutor is – anyone can teach there! The quality of the courses is somewhere between excellent and terrible. But hey, if you like surprises, it’s the right place for you. Pros The course price (a one-time payment) is fair. The author provides a link to a test database where students can try their SQL queries. The author adds premium content for no extra charge. You will find out how to set up SQL tools on your computer. You get a certificate for completing the course. If you don’t like the course, Justin personally claims to refund your entire purchase amount. Cons There’s a lot of theory and a little practice. The author doesn’t mention credentials in his bio. There is no dedicated space to try out newly-learned SQL queries. The teaching process is chaotic. #4 SQL Basics SQL Basics at LearnSQL.com is an interactive online course that consists of 129 hands-on exercises. It lets you practice on the go, with everything you need right in the browser. It starts with simple SQL queries performed on a single table and goes deeper into using more advanced SQL functions, including creating simple reports. This course is suitable for people who have no experience with databases. Although they doesn’t use marketing data, the course’s instructions are clear and show how to use SQL to solve day-to-day challenges. In the SQL Basics course, you will learn how to: Retrieve information from an SQL database. Build basic reports from scratch. Write complex WHERE conditions. Use the LIKE, ILIKE, IN, and BETWEEN operators. Work with multiple tables. Use INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN. Create simple client reports using GROUP BY and aggregate functions. Write subqueries and complex instructions. Understand SQL set operations ( UNION, INTERSECT, and EXCEPT). After finishing the course, you can practice what you’ve learned or extend your knowledge with further SQL courses; the platform offers plenty of them, ranging in difficulty from beginner to advanced. Additionally, LearnSQL.com has a library where you can find many related tutorial articles and cookbooks, e.g. “How to LEFT JOIN Multiple Tables in SQL” or “Data-Driven Marketing with SQL”. There’s lots to be learned there! Pros LearnSQL.com offers subscription plans at a fair price. No prior SQL or database experience needed. Get hands-on practice writing SQL queries. Receive a certificate of completion when you finish the course. Courses are designed by SQL professionals; they have knowledge backed by experience. Cons There is no answer key for students. If you get stuck, you have to check the exercise discussion (using the “Disqus” tab) or reach out to LearnSQL support. You won’t learn how to set up SQL tools on your computer. Good SQL Courses for Marketers Do Exist In this article, I’ve reviewed my picks for the best SQL courses for marketers. I hope it helps you choose the right one(s) for your personal needs. SQL is a beast that, if well mastered, levels up your working efficiency. Do you know any other good SQL course for marketers? Tell us in the comments section. Tags: sql learn sql marketing jobs and career You may also like Advanced SQL Courses for Data Analysts – A Complete Review Data analysts, do you want to improve your skills and move to a higher level of SQL? Here’s an overview of 8 online SQL courses for advancing analysts. Read more Top 3 Platforms to Learn SQL Online: A Complete Comparison What is the best place to learn SQL online? It is hard to choose without enough information. I tested and compared 3 major platforms to help you decide. Read more What is the Best SQL Training Online? What is the best way to learn and practice SQL? Find out where you can improve your skills with real-world business problems. Read more Choose the Best Way to Learn SQL It's easy to get lost in the jungle of SQL books, tutorials, and courses. Here's how to learn SQL quickly and effectively. Read more 50 Best Resources for Learning SQL in 2020 Want to know where to learn SQL? Here’s the ultimate list of the best SQL courses, books, communities, and tutorials. Dig in! Read more Video Tutorial or Interactive SQL Course – Which Is Better? Decide what SQL learning method will be best for you - tutorial or course. Don't waste your time or money! Read more The Top 7 Platforms with the Best SQL Courses for 2020 Learn SQL and master your skills online. Here are the best platforms with SQL courses. Choose the right ones for what you need. Read more What Online SQL Courses Are Best for Finance and Economics Majors? Looking to augment your knowledge of economics and finance with in-demand technical skills? This article looks at the best online SQL courses for students, data analysts, and others. Read more 19 Top SQL Articles for Beginners Published in 2019 If you are only starting in SQL, don’t stop expanding your knowledge and developing new skills. Continue to learn SQL with top SQL articles designed for beginners. Read more YouTube Tutorials That Actually Teach You Some SQL Do you want to learn SQL but do not want to read books or do online courses? YouTube SQL tutorials can be the answer. Here are those worth watching. Read more Our Picks for 2020’s 7 Best Online SQL Schools Looking for the best online SQL courses but aren’t sure where to start? I evaluated the top 7 ranked online SQL schools to help you find your match. Read more 15 Best SQL Articles for Beginners Published in 2017 If you're looking for articles on SQL for beginners, take a look at my comprehensive list of best SQL articles from 2017! Read more How to Learn SQL: 6 Ideas for Newbies Wondering how to learn SQL? Thanks to the Internet, there are a lot of options you can use for your SQL training! Read more Should I Learn SQL? 4 Convincing Reasons There are 250+ computer programming languages in popular use. However, there are good reasons why you should learn SQL, or Structured Query Language. Read more How to Study Online: 5 Steps to Becoming an Effective Learner Want to learn how to study online more effectively? Check out our 5 steps guide for online learners. Read more Video Tutorial or Interactive SQL Course – Which Is Better? Decide what SQL learning method will be best for you - tutorial or course. Don't waste your time or money! Read more Subscribe to our newsletter Join our weekly newsletter to be notified about the latest posts.