coding

SQL: Learn to Communicate with Databases

What is SQL? SQL, (sequel) or Structured Query Language according to Vault Analytics, “is the de facto standard coding language that is used to communicate with databases.” Or it can be thought of as another important coding language to know in the marketing industry. SQL communicates directly with databases, and through codes it can extract specific information. Running SQL queries are an easier, faster way to manage and filter through data than Excel.

How does SQL work? The article, Learn SQL The Hard Wayexplains how SQL understands the fields of tables, and can find data based on the contents of the fields. All SQL operations are based off of four general table commands:

  1. Create – inserting data into tables
  2. Read – query data in a table
  3. Update – change data in a table
  4. Delete – remove data from a table

Benefits of knowing how to leverage SQL:

  • Differentiate yourself when applying to jobs
  • Need to understand to execute projects
  • Speeds up process of finding information
  • Can better analyzing information and identify relationships within data
  • Fix your own problems with websites
  • Can create and execute your own marketing campaigns
  • Can communicate better with developers, designers and analysts

SQL 300

Living in a digital age, marketing now has large role online. And as a marketing student, learning technical skills that are applicable to the marketing field are important for me to know. Moz’s article Every Marketer Should be Technicalexpands on the importance of having technical skills. Moz suggests the following are important technical skills to know:

  • Databases & SQL
  • Web Technology
  • Web Development
  • Web Design & UX
  • Copywriting
  • Analytics
  • Forecasting/Statistics
  • Excel
  • Technical SEO
  • Content Platforms
  • Email Technology
  • E-Commerce Technology

tumblr_mtmt8mZVsG1su8bpzo2_500

Code Academy: an easy FREE way to learn coding!

Coding: a tool that amplifies intellectual abilities – “the ultimate mental amplifier,” as put by David Evans in his Introduction to Computing textbookThroughout the ages, humans and animals have created tools in order for to help their physical abilities to become faster, stronger and better.

As said in the text, “tools that amplify intellectual abilities are much rarer… Only humans have developed tools to substantially amplify our intellectual abilities and it is those advances that have enabled humans to dominate the planet.” The two examples that were given were language, and writing. Language allowed humans to communicate thoughts, and use their minds more effectively. Writing created documentation, allowing people to share thoughts through time and over distances.

Then there was technology. Computing mechanizes “any intellectual activity we can imagine…” and “pervades nearly all human endeavors.” Which is why coding is so important!

43785896

Coding is a very useful and differentiating skill to have. A non-profit Coalition for Queens recently started a program called Access Code. A training program that teaches the Queens community how to code iOS applications. “Six months after the first Access Code class of 21 students completed the 18 week course, the 15 graduates who accepted job offers have seen their income rise from under $15,000 to an average of $72,190; the other six students are either still in college or have chosen to launch their own startups.” That is a tremendous income increase, just having the basic knowledge of coding. 

And guess what? Learning to code, isn’t hard. You can learn it yourself! Code Academyis a a website that has numerous coding tutorials, all for FREE! You can learn to code different languages such as Javascript, HTML/CSS, PHP, Python, Ruby, and API.

I made an account, and spend two hours on the site. In my two hour trial, I was able to get through multiple tutorials, and over 50 exercises! (I have had some previous experience with coding, having taken a couple of computer science classes) I really enjoyed these tutorials, they were very easy to use and follow along with. They are all hands on do it yourself tutorials, that provide extra help if you need it. Here are a few screen shots of some of the tutorials I completed, and what they look like!

Screen shot 2014-04-28 at 9.15.49 AM

Screen shot 2014-04-28 at 11.11.02 AM

In summary, coding is important and a excellent skill to know in the digital marketing realm. And if you don’t know how to do it, go make an account on Code Academy!

coding-problems