Squirming to Learn SQL

Are you looking for a way to set yourself apart from all the other freshly graduated marketing students? Here is your answer: Structured Query Language. We live in a digital age and having exceptional technical skills is a must when entering the job market. SQL is designed for managing data held in a relational database management system. As a simpler thought, for those of you that are having a hard time wrapping your mind around it, it is basically a database language that allows you to search through your data in a more efficient manner. SQL is the key to more efficient and interactive research of your data.

SQL is an incredible successful and solid technology. It is EVERYWHERE. All iPhones have easy access to a SQL database and many applications on your phone use it directly. It runs banks, hospitals, universities, governments, small businesses, and large ones.  How does it work exactly? SQL understands fields that are in tables, and how to find the data in the tables is based on the contents of the fields. Below are the four general steps of SQL operations:

Create:

Putting data into tables.

Read:

Query data out of a table.

Update:

Change data already in a table.

Delete:

Remove data from the table.

This is a fundamental set of features EVERY data storage system must have.

One aspect of marketing that really focuses on the use of SQL is research. Some common firms that use SQL are Nielson, ComScore, and Ipsos. I researched a few marketing positions that are currently up for grabs and having a basic understanding of SQL is necessary for all of them. So, for those of you that are about to pull your hair out due to the stress of having to learn ANOTHER language, just jump on this handy dandy sight http://www.w3schools.com/sql/default.asp . Trust me, it was not as intimidating as I initially thought. Plus, if worse comes to worse, there is always the SQL FAIRY!

logo

Halloween costume anyone?

But really, SQL skills are worth their weight in gold. It is time to dive into this intimidating world of structured query language and realize the true potential of this skill set. Not only will it set you apart, becoming an informed SQL user will enable you to make informed decisions and gain a deeper understanding of all databases.

Now that you are squirming in your seat to learn the ins and outs of SQL, here is a cute cat meme to ease your mind:

hEFE03B87

Okay, let’s get to it!!

Sources:

http://sql.learncodethehardway.org/book/introduction.html

http://vaultanalytics.com/marketinganalytics/2012/10/why-learning-sql-will-change-your-life/

http://moz.com/blog/every-marketer-should-be-technical

Advertisements

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