When I took marketing courses at business school, I learned few technical skills. Professors focused on marketing frameworks, like the 4 P’s, 5 C’s, STP, and SWOT. This is great if you work at McKinsey. But if you’re at a small digital agency or are an entrepreneur, you need hard skills to get things done. Few start-ups can to hire four employees to develop a marketing strategy, draft the creative, write the code, and measure the analytics. An excellent online marketer is one part Seth Godin, one part Chris Pirillo. Our generation’s marketer is a digital Ben Franklin.
Where do you start? Most marketers have never heard of above subjects. Let’s start with MySQL.
Storing Information on the Internet
Are you familiar with Excel? You probably use it to store data. When you connect multiple spreadsheets together, it creates a database. Many websites, such as Yelp, use databases to store information. Yelp’s database, for example, likely has a table (spreadsheet) devoted to restuarants. Each restaurant has a row with information on the location, price range, and hours. It probably looks like this:
Besides Yelp, sites such as YouTube, Craigslist, and even this blog handle data in exactly the same way! Like Microsoft Excel, there’s a “brand” of databases for storing information. The most popular for online marketing is MySQL.
Displaying and Editing Information
Programmers invented special code (PHP, ASP, we’ll cover this in the future) to request information from the database. If Yelp wanted to create a web page with information from the above table on Per Se, they would write a bunch of code that requests certain cells from the table. Those cells would be output and formatted so that it is readable and user-friendly in the context of the web page.
Suppose you wanted to edit the information? Imagine editing a spreadsheet remotely, where you could change a cell by typing text into a field on a website:
MySQL is dynamic; so Yelp and its users should be able to easily edit Pe Se’s information (i.e., the Per Se table). Check out this page Yelp created to do just that.
In Short: MySQL is a brand of online databases. An online database is a bunch of spreasheets connected and stored for access on the Internet. Websites can retrieve and edit stored information easily.
This covers the basics of MySQL–I’ll go deeper in future posts. If you would like to get started, check out this tutorial for MySQL; it gives a great overview and a short example.