** Tues. A/B Testing and Thurs. SQL

First, my apologies for not getting this to you earlier. Not to make excuses, but it’s related to the reason I’m probably going to have to teach class on Tuesday wearing sunglasses. (My regular eyeglasses broke.)

After the coding lesson on Thursday, we are going to continue the technical module of the class this week with A/B Testing and SQL. What is A/B Testing?

Here’s a tweet from this week that illustrates it in practice.

First to understand how it works read this short eBook “The Ultimate Guide to A/B Testing”.

The Ultimate Guide To A:B Testing | Smashing Magazine

Next, because you guys are so much smarter than everyone else, read this academic journal article by a bunch of Microsofties about how to do it right.

GuideControlledExperiments

Why is Digital Marketing so fantastic? Because everything is trackable and since everything is trackable, everything is also testable. Basically, you never have an excuse to have a crappy landing page, or email campaign or banner ad because of A/B testing. Blog about some good examples of A/B Testing that you have discovered.

For Thursday, 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”[4], sometimes pronounced /ˈskwəl/ ”sequel”; Structured Query Language[5][6][7][8]) 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.

Every Marketer Should Be Technical

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”.

Technical Mktg Blog Post_026

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:

Why Learning SQL Will Change Your Life

And this:

Why Every Startup Marketer Needs to Know SQL

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.

SQL Tutorial

For Thursday’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.

Enjoy!

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s