Why Learning SQL Will Change Your Life

Working with all your data in Excel is like trying to manage all of the financial transactions of a large bank with a pencil and paper.  Grossly inefficient, prone to errors that are hard to fix, and with the technology available to us today, rather unwise.  I think one of the reasons better analytics hasn’t taken hold in our organizations is because we are all still trying to use Excel for analytics and data processing.

To be a valuable analytics professional, you have to know how to leverage SQL.  You will be able to do things you’ve never imagined possible trying to pound things and program things and automate things in Excel.

SQL is the de facto standard coding language that is used to communicate with databases.  With it, there is no more downloading endless worksheets, manipulating them by hand, and doing complicated analysis that is not easily reproducible.  You can communicate directly with the database, extract exactly what you need, and because your procedure is there written in code and not lost in a series of manual copies, pastes, and filters, you can re-run it at any time and easily find and fix errors in your process.

Don’t get me wrong, Excel is still good for specific, limited cases – but if you are doing any kind of analyics that requires downloading data and taking that data through certain manipulations, you need SQL.  You will be so much more efficient you’ll wonder how you ever survived without it.  It is well worth the small learning curve to get acquainted with it.

And I wouldn’t just recommend it for analytics professionals.  If you are a marketer that knows how to use SQL, you are probably part of 1% of marketers who do, and with that ability you will be able to do analysis and make discoveries no one else in your organization can.

Take some time and learn SQL.  I recommend these free tutorials from the w3 schools.  Insane efficiency awaits you.

23 Comment

  1. […] students, my peers and I are being armed with knowledge that small few others have. According to Vault Analytics, only about 1% of marketers currently know how to use SQL (Structured Query Language). And I doubt […]

  2. […] gives you access to all the data you need. It is “the de facto standard coding language that is used to communicate with databases”.  You communicate directly with the […]

  3. […] Why Learning SQL WILL CHANGE YOUR LIFE! […]

  4. […] SQL or ‘Sequel’ is the de facto standard coding language that is used to communicate with databases.  With it, there is no more downloading endless worksheets, manipulating them by hand, and doing complicated analysis that is not easily reproducible.  You can communicate directly with the database, extract exactly what you need, and because your procedure is there written in code and not lost in a series of manual copies, pastes, and filters, you can re-run it at any time and easily find and fix errors in your process. -via VaultAnalytics […]

  5. […] MIS class and actually ran queries in SPSS in the Marketing Analysis class. After reading ‘Why Learning SQL Will Change Your Life,’ and ‘Why Every Startup Marketer Needs to Learn SQL,’ I wish more than […]

  6. […] also read this cool article,Why Learning SQL WILL CHANGE YOUR LIFE,that once again proved me wrong, and my thoughts on computer things such as SQL. “Don’t get […]

  7. […] If you are like myself, the words manipulating databases kind of freaks you out.  I automatically want to pass this over to one of my more techy cohorts, but I would in fact be doing myself a huge disservice.  If you haven’t caught on already, I am marketing major in on the brink of stepping into the marketing arena.  Learning SQL will be a valuable asset for me to craft.  Not convinced?  Read this article called “why every startup marketer needs to learn SQL.”  I love this article because the author had just recently learned SQL (like four weeks ago) and was already seeing astronomical changes in his start up companies marketing.  I won’t give examples because you NEED to read this!  Still not convinced, then read “why learning SQL will change your life.” […]

  8. […] which we all know as marketers is a key strategy to success. According to the article Why Learning SQL Will Change Your Life, “if you are a marketer that knows how to use SQL, you are probably part of 1% of marketers who […]

  9. […] with your database.  An article by Vault Analytics explains the impact it has exceptionally well: “with it, there is no more downloading endless worksheets, manipulating them by hand, and doing co… Trying to do all of this in the past using Excel meant that you would be looking forward to a day […]

  10. […] you will be able to DIRECTLY communicate with the database and extract EXACTLY what you need! From Why Learning SQL Will Change Your Life, if you are a marketer that knows how to use SQL, you will be a part of the 1% of marketers that DO […]

  11. […] So you may be wondering, what does SQL do, exactly? First off, think about the last time you used Excel to manage any sort of information (a database, in other words). It’s a great tool to use for small bits of it, but when you have thousands of identities it’s tough to organize or use in general because Excel can only do so much. SQL changes all of that. Vault Analytics explains it quite well in their article: […]

  12. […] want to work for a startup company then develop those skills and become the ultimate threat. From Why Learning SQL Will Change Your Life […]

  13. […] marketing, SQL is the new tool every marketer should know for a world of digital marketing. Vault Analytics told us that SQL will change our lives for the better. In order to become a better marketing analyst, “you have to know how to leverage […]

  14. […] Vault Analytics: Why Learning SQL Will Change Your Life […]

  15. […] spreadsheets, changing them by hand and doing complicated analysis are just some of the reasons why SQL will change your life, according to Vault […]

  16. […] Such practices are popular due to Excel’s functionality and ease of use. However, according to Vault Analytics, using Excel to manage data, to using a paper and pencil to keep track of company financial […]

  17. […] So how does one become said one man wrecking crew? Knowing your databases and your Structured Query Language is a good start. SQL is the de facto coding language that communicate with databases, need to find something in a database? Use SQL. If you truly known SQL you can extract the exact data you need from the database. It gives you an advantage in terms of knowledge that only 1% of your so-called marketing gurus have, according to an article by Vault Analytics.  […]

  18. […] more on SQL, the article “Why Every Startup Marketer Needs to Know SQL” it states the importance of knowing SQL and the small learning curve it takes to pick it up. Even […]

  19. […] last line of this post, learning the basics of SQL is just as important. By Vault Analytics’ estimate, learning SQL will put you in the top 1% of marketers. Assuming that number is even close to true, […]

  20. […] information needed to make their decisions, and that information is usually pulled and manipulated with SQL. Manipulated with Python, and analyzed with R. In more general terms, if your company is running an […]

  21. […] in a number of ways, including to directly reach out to customers. But, why not use Excel instead? This article from Vault Analytics, accuses the overused, maybe a little outdated, Excel of […]

  22. […] This article discusses the important of learning SQL, and its application in the industry today. It explains that excel is not sufficient for analytics and data processes; analytics professionals must know how to leverage SQL. […]

  23. […] isn’t the only company talking about SQL – Vault Analytics wrote a piece on it as well. However, Vault raises a point I want to reiterate: SQL is great but no one expects […]

Comments are closed.