Leave a comment

I recently joined Periscope, where we produce a data visualization tool. One of our core features is the ability to type in raw SQL to create charts. Also, our best customers are hardcore SQL users.

So, long story short, I need to learn SQL.

I jump into the basic terminology (database, query, console, table, column and row) and some simple SQL (select, from, where and join).

This is a series where I’ll be writing posts as I learn.

  • IK

    Ivan Kreimer

    almost 6 years ago #

    You should read SQL for Marketers, an amazing introductory book: http://www.amazon.com/SQL-Marketers-Quick-Start-Guide-ebook/dp/B00F9GPWEO

    You may also want to take a look at a course done by Justin Mares called SQL for Marketers. It's not that good, as he goes fast, and doesn't explain the concepts well enough. Still, you should check it out: https://www.udemy.com/sql-for-marketers/.

    Best of luck, and congrats on your new job!

  • AL

    Austin Lilley

    almost 6 years ago #

    Good stuff. I've been taking the Team Treehouse course on this and it's helped a ton!

  • MI

    Milan Ilic

    almost 6 years ago #

    This is gold. Thank you Jon. Learning SQL is on my do to list for a long time, but somehow I was delaying it.

    • JB

      Jon Bishop

      almost 6 years ago #

      Thank you! I'm lucky to have my team to help me out. They're all extremely good with SQL.

  • KW

    Kevin Waugh

    almost 6 years ago #

    This blog is great for introductory to SQL. The other more tech heavy blogs I am going to take a look at. SQL is a knife that should always be sharpened.

  • JS

    Jared Smith

    over 5 years ago #

    Fantastic article. I cannot stress how important and valuable basic programming and database skills can be in nearly any data driven job. You can seem to be a miracle worker when you save a company hours or even days worth of time, or manage to write the query that produces a report of correlated data that no one thought to correlate before that.

    I love seeing technical skill articles like this! Keep them coming!

  • EM

    Eric Metelka

    over 5 years ago #

    Love that you're blogging in public about your process. I also learned SQL earlier this year and it made me a lot better at my job. If it's helpful, here's a SQL syntax cheatsheet here: http://fullstackmarketing.co/blog/2014/1/26/how-and-why-to-learn-sql-to-be-a-better-marketer

  • RV

    Ruben Vicario

    over 5 years ago #

    Keep in mind that in SQL you perform CRUD actions, which stands for Create, Retrieve, Update and Delete

  • DS

    Dennis Still

    over 5 years ago #

    Great resource is @sqlkris and his blog www.essentialsql.com. I've known him for a few years now, always willing to jump in and lend hand. Great content for some who are less tech/code driven.

    Another suggestion I have is to find a champion, someone within organization who has tons more SQL experience than you, get to know them, get their help in queries, ideas for pulling data. I've found this ally at large organizations and small. Really helpful to get 1:1 help.