Back to articles list March 4, 2020 - 9 minutes read Should I Learn SQL as a Data Analyst? Marija Ilic Marija works as a data scientist in the banking industry. She specializes in big data platforms (Cloudera and Hadoop) with software and technologies such as Hive/Impala, Python and PySpark, Kafka, and R. Marija has an extensive background in DWH/ETL development in the banking industry. Her main interests are predictive modeling, real-time decision-making, and social network analysis. Outside of work, Marija enjoys listening to her favorite LPs on her old gramophone—and never grows tired of its soothing crackle. Tags: sql jobs and career data analyst So, you are a data analyst—someone who relies on data. You like to gather, clean, and transform data and come to conclusions based on data. You are a data detective. Which tool do you choose to do your job in an elegant, reproducible, and simple way? Excel? R? Python? Or should you learn SQL? Stay tuned! In this article, I will explain why SQL is a must-have skill for data analysts. I will cover Dreyfus's skill acquisition model and show you where you can learn SQL no matter your ability. Should I Learn SQL? SQL has been used since the 1970s for data retrieval from relational database systems. Nowadays, businesses deal with a lot of data. SQL is a skill that’s in high demand, and trust me — that fact will not change for a long time. Why? SQL is stable, well-established, and present in every company that stores data in a structured format. And as long there is a need for structured data storage, there will also be a need for SQL developers. No matter what industry you are in, you will need to access data stored in databases, and SQL is the best and only way. Learning SQL might not sound as sexy and exciting as learning R or Python, but it is an essential skill for data analysts. Now that you know why it is important to learn SQL, in the next section, we will discuss how and where to learn SQL. Dreyfus Model of Skill Acquisition Whether you are a novice, beginner, or advanced user, you can always grow, get out of your comfort zone, and improve your SQL skills. It’s a long-term investment that will pay off. Acquiring skills (like SQL), is a lengthy process. Once you have found a skill you want to develop, the next phase is the learning phase. In this phase, you learn the basics. You find some rules for your SQL cookbook. Following these rules allows you to start retrieving data using simple select statements. You find yourself deleting your first SQL table and updating values in another table. Congratulations, you’ve learned the basic syntax (select, update, insert, delete) for data manipulation! In this initial phase, you aren’t yet confident with the syntax. However, you are proud that you learned something new and are utilizing what you have learned so far. According to the Dreyfus model, you are now called a novice. It’s the first of five steps: Novice Advanced beginner Competent Proficient Expert From Novice to Advanced Beginner Most data analysts start their SQL learning path by taking one of the many online courses offered on the internet. This first course will be the hardest one. It opens you to a new world. So, it’s important to choose the right introductory course. It needs to keep you motivated and must be friendly, intuitive, and interactive with a lot of examples. My recommendation for a novice is SQL Basics on LearnSQL.com. I love this platform especially because I’m one of its course and article writers. Once you complete this course, you will have a good foundation that will motivate you to move to the next step — advanced beginner. The transformation from novice to advanced beginner happens with practice. An advanced beginner has more experience writing code. Both novices and advanced beginners possess the same basic knowledge. The main difference is that advanced beginners don’t need supervision when performing simple tasks. So, if you are a novice and want to go further, it’s time to take some new online courses with a lot of exercises. Along with courses, try connecting to a database at work and performing simple selects (select all clients or client transactions) on your company’s data. From Advanced Beginner to Competent It feels good to perform simple tasks without a supervisor, doesn’t it? At this point, you feel ready to move up another step. You know that the sky's the limit and that you can easily adopt more complex SQL syntax into your daily routine. As the days go by, you are using SQL more and more. Remember — practice will bring you from advanced beginner to competent. How do you gain more experience? You can take additional courses that will give you more practice. On LearnSQL.com, you can find a great learning path intended for upgrading your coding skills. This learning path, SQL Practice, made up of two interactive courses: SQL JOINs — a course that covers the important types of SQL JOINs, which are widely used by SQL programmers to query databases daily. SQL Practice Set — a practice set that tests your basic SQL knowledge and shows where you need improvement. This course is all about practice, practice, and practice. Use these courses to gain more practice. In addition to taking courses, try to use SQL for some day-to-day tasks that were previously done in Excel or another tool. Every day, find at least one new SQL challenge — practice on your own data. For example, if you are a pricing manager or revenue analyst, try doing your pricing calculations in SQL. There is actually a special SQL course about this subject. The Revenue Trend Analysis in SQL course will help you build revenue reports from scratch. Keep in mind that you must be persistent and incorporate SQL in your daily work. Experience makes us professionals. Once you have gained more confidence and complete more complex tasks on your own, you have become competent. You are no longer just following the rules. Now, intuition helps you write SQL queries. From Competent to Proficient Competent is a desirable level because you can now manage most tasks without any help. You are a confident problem solver and can write SELECT, WHERE, and GROUP BY statements even with ease. So, what happens now? Now, you are so good at SQL that you are starting to ask yourself questions: Can this SQL query be written more efficiently? How can I improve my queries so that they run more quickly? Is this code reproducible? Congratulations, these are great questions! You are on your way to becoming a proficient SQL developer. You need to gain more advanced knowledge and take time to adopt new concepts to answer these questions. It is time for new learning paths that will help you move to the next level. There is a learning path on LearnSQL.com just for that, Advanced SQL, and it contains three courses: Window Functions — a course that covers the syntax and semantics of SQL window functions. It shows how powerful these functions are, how you can build complex aggregations much more simply, and how to use ORDER BY and PARTITION BY to set up a frame for window functions. GROUP BY Extensions in SQL — a course that teaches you how to use advanced features in SQL, like ROLLUP, CUBE, and GROUPING SETS operations. Recursive Queries — a course that teaches you about subqueries or common table expressions (CTEs). You will learn how to manage your SQL queries with CTEs, how and when to use nest CTEs, and how to use recursive CTEs to move through hierarchical data models. Once you get familiar with these more advanced SQL concepts and start using them in your daily work, you will notice how your code is simpler, prettier, and easier to maintain. At this point, you are guided by intuition, and you know when a certain SQL code is appropriate to use and when it is not. Now, you are a proficient SQL user — someone who sees the overall picture and how individual actions fit within it, someone who can deal with complex situations holistically and take full responsibility for your work. At this point, only one last step remains — expert level. This is where you can do something called SQL magic. From Proficient to Expert It is hard to tell the difference between a proficient user and an expert user. At first, they look the same. But if you look deeper, you will notice small differences that make an expert almost like a magician. Everything the expert does looks effortless and magical. Experts are guided by strong intuition that comes from years of focused experience. This level is excellently described in an article by Ransom Patterson. It is a long journey from a novice to an expert, and not everyone ends their journey with an expert badge. In fact, studies have shown that people are not evenly distributed throughout the skill levels. Most of us are just advanced beginners, and only 2% of us are experts. Yes, most of us are just advanced beginners. To quote Nat Eliason: “If you don’t look first inside yourself to assess your intuition around goals and actions, and instead choose to look for more recipes, you are not proficient or an expert.” The Dreyfus model is wonderfully explained by Nat Eliason here. Do not let these numbers discourage you. They should instead motivate you. Remember, if you get to the competent or proficient level, you have surpassed 60% to 90% of others. Isn’t that good motivation? Summary Today, when almost every business stores a lot of data, it is important to learn SQL programming skills. So, the question is not whether you should learn SQL but where to learn SQL and how to further improve this highly desired skill. In this article, we talked about the Dreyfus model and five basic steps through which we pass when developing our SQL programming skills. Once you start learning SQL by taking some online courses, you are at the first, novice, level. Further learning through practice brings you to the advanced beginner level. More and more experience brings you to the competent level. At this level, you have a better sense of what is relevant and what isn’t and why something does or doesn’t work. With persistence and SQL practice, you gain enough experience to be led by your intuition instead of rules and recipes. One way of practicing is to take interactive SQL courses found on LearnSQL.com. They can help you progress from one level to another. At the end of this journey are the last two levels, proficient and expert, which are the most difficult to reach. Only 2% of people are experts in a skill for which they trained. Would you like to be in that 2%? If your answer is yes, this article can help you with your journey. I encourage you to get there. Good luck! Tags: sql jobs and career data analyst You may also like Is SQL a Programming Language? SQL is a great tool for talking to relational databases. But is it a programming language? Learn why the answer is definitely yes. Read more Is SQL Worth Learning? Is learning SQL something to consider? Or is it yet another useless skill that employers don’t value? Read more How Will Learning SQL Improve My Daily Work? Do you think that learning SQL is only for people in IT? Not true! A knowledge of SQL is good for most professions. Read more How to Start Writing SQL Reports Learn how to write SQL reports. Reporting in SQL will benefit you professionally, regardless of your role or industry. Read more Should I Learn SQL as a Data Analyst? Are you a data analyst wondering if you should learn SQL? You should, and here's how! Read more What Programming Language Should You Learn? Guide to what programming language should you learn first when starting learning to code Read more How to Become an SQL Developer Have you ever wondered what it takes to become an SQL developer? What does an SQL developer do, what are job requirements, and which training you should attend? Read more How Long Does It Take to Learn SQL? Top Tips for SQL Proficiency How long does it take to Learn SQL? We break it down so you know exactly how long you’ll need to achieve SQL proficiency. Read more Why Use SQL Over Excel If you're using Excel as a data analyst, you're missing something valuable. In this article, I explain why the use of SQL over Excel is the right choice. Read more Career Change: From Accountant to Database Designer Personal insight into career change, learning SQL, becoming a database designer, and how your life choices can help you accomplish all that and more. Read more Forget About Excel, High Five With SQL Find out how easy it is to learn SQL, why it can make you work better, and how LearnSQL.com makes the learning process fun. Read more How SQL supports data-driven organization Businesses face many decisions. Most of them are driven by intuition, but organizations that make the most business impact use data-driven decision-making. Read more Why Learn SQL Over the Summer For the love of SQL, we decided to motivate you (yes, you) to learn SQL over the summer. Here's why! Read more Key Insights for Mastering SQL Queries Using Tinder Data Example We’ll take a look at key insights that will help you understand the nuances of mastering SQL queries. If you’ve never used SQL, you’re in the right place. Read more Here’s Why You Should Learn SQL Why learn SQL? We asked LearnSQL users about it. This is what we’ve learned. Read more 5 Great Benefits of Learning SQL Data analysis will help you and your business grow. What are the main benefits of learning SQL? You’ll find out in this article! Read more Why Is SQL Worth Learning? With an increasing amount of data comes the need for databases that can store information for retrieval and analysis by trained specialists. Read more Four Reasons You Must Learn SQL in Data Science SQL can help you build a solid foundation for your analytical career. Let’s see how seasoned professionals use SQL in data science. Read more SQL Mythbuster – 5 Reasons Why No One Should Be Afraid of SQL Anyone can learn SQL. It’s not as hard as you think! And you don’t have to be a hard-core nerd. Let me tell you my story. 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 Common Entry Level SQL Developer Interview Questions Learn about the eight interview questions usually asked for an entry-level SQL position and how to answer them well to make a good impression Read more Subscribe to our newsletter Join our weekly newsletter to be notified about the latest posts.