On Monday, we’re going to learn about SQL. “What’s SQL?”, you ask. Well, according to this website I just learned about called Wikipedia “SQL (/ˈɛs kjuː ˈɛl/ ”S-Q-L”, sometimes pronounced /ˈsiːkwəl/ ”sequel”; Structured Query Language) is a special-purpose programming language designed for managing data held in a relational database management system(RDBMS).”
Great, well why should you care about it?
Recently, I discovered this blog post from the former CMO of MOZ, Jamie Steven (@jamies) entitled “Every Marketer Should Be Technical”. Please read it.
You’ll notice a lot of things, we’ve talked about this quarter and some other things we have not yet, but one of the things you will notice is the first skill listed in this graphic is “databases and sql”.
The importance of SQL was brought up to me again by other digital marketers I’ve spoken to over the last year. Many of them told me that the ability to do their own SQL queries would definitely get an entry level candidate noticed.
Don’t believe me? Read this:
And since I like the online certification courses so much, go to W3 Schools and get through the SQL Basic Tutorial (“SQL Home” to “SQL Injection”). Honestly, it won’t take you very long.
For Monday’s blog, write about companies that you have discovered that use SQL in their marketing and why you think it would be a beneficial skill to master.
To continue our data-based (see what I did there) discussion, on Wednesday we will look at what companies do with their data.
(If you’re wondering why this is in the Digital Marketing course, my theory is you can’t use data without computers and computers are digital.)
The first article is a short white paper from Forrester about how we can use data for personalized marketing.
How can that data be used? Well, maybe Orbitz will try to scam you for a couple extra bucks based on the computer you use.
Or maybe, Target wants to figure out if you’re pregnant. (Don’t buy candles, ever!)
Some companies have data they’re not sure what to do with.
My favorite use of data is for predictive modeling, like Hollywood is doing now.
But honestly, the most interesting use of database marketing of the last couple of years has been in the Obama re-election campaign. These two articles talk about what we as marketers can learn from their efforts.
And if you want to get super deep about the campaign, check out this #longread from The Atlantic, but you don’t have to read it like the other ones. (But, it’s still pretty cool.)
We’ll be joined by Ed Hallen from Klaviyo. I met him over Thanksgiving in PDX. (He’s my wife’s cousin’s husband’s sister’s boyfriend. Smart guy, and it turns out he graduated from UVa a few years after me. )
Here’e a great blog post about work that they did for an online pet store.
Have a great weekend!