Tag Archives: Efficiency

Not all Businesses are Created SQL

sql-joins-two-tables

What is SQL?

Structured Query Language is a database inquiry system which allows you to access and manipulate the data that your company has collected. The data is stored in the form of tables which display the records in an array of columns and rows. SQL is a language that developers know, however one that is not considered common knowledge by the marketing community.

Many SQL databases are available online as open source software. Some examples are MySQL, ProgreSQL, and Firebird SQL. In order for it to be considered SQL, it must include at least the following commands: Update, Delete, Insert, Where.

SQL query:

–          Select: the data that you access from the tables you have access to

–          From: these are the table that you access in order to get the data you seek.

–          Where: what are the conditions you want to have met, how are you going to connect the tables with the data

–          Group by- filtering you data based on a similarity

–          Order by: arrange your data in an order than makes sense to accomplish your goals

–          Limit: specify! (ex: only bring me 20 rows of data)

It doesn’t stop there however because SQL can include commands in categories such as Syntax, Select, Distinct, And & Or, and so on.

In order to use SQL In building your website, you must have access to a Relational Database Management System (RDBMS) such as Microsoft Access, SQL Server, or MySQL.

Examples of SQL in the Business World

In the finance world, Garanti Bank of Turkey, which is their second largest in the country increased productivity greatly by starting to use Microsoft SQL Server. Efficiency increased by over 50% and performance increased by over 70%.

Banco Central do Brasil increased their performance, reporting speed, and their scalability when they switched.

Read about more financial services that have benefited by clicking (here http://blogs.technet.com/b/dataplatforminsider/archive/2012/09/26/financial-services-companies-rely-on-sql-server-2012-to-deliver-the-new-standard-in-mission-critical-platforms.aspx)

These are real companies making real differences to the strength and value of their business by integrating SQL into their processes. Don’t ignore the numbers.

What can SQL do for Marketers?

SQL can be used for many tasks, the most relevant to marketers being to input or delete entries, retrieve data from your company’s database, and build new databases and manipulate old ones.

SQL is a valuable tool that can be used by marketers to manage your businesses data by running search queries within your database. Understanding SQL can open up opportunities to learn more about your customers and do so in a shorter period of time. Creating queries within your database helps you to search out specific criteria about your customers and categorize them in categories such as country, first name, last name, and length of time since their last purchase.

How does a marketer use this information?

Let’s say you are interested in running a campaign to recapture a group of customers who haven’t purchased in a while. You could run a query that identifies the name and email address of customers who have purchased product from you in the past, however have not purchased in the past month. You then are able to include only these customers in an email blast offering them 20% off their next purchase for a limited time only.

While narrowing down the scope of your campaign, SQL will enable you to effectively target and provide discounts to only those people whose purchasing has decreased. This eliminates frequent customers from receiving discounts, and offers an incentive to buy to those who you are trying to capture as frequent customers.

 

Why is it important to know as a marketer?

The efficiency that SQL allows is something that can take a marketer with knowledge, and turn them into a marketing team who is able to get things done. The more that you become a specialist on all of the tools that are used by your team, the more valuable you make yourself, as well as making yourself less expendable. In today’s business environment, the more skills you have, and the more technical work you are able to do yourself will have a great impact on your ability to get entry level jobs and impress employers. Learning SQL could be the clinch that seals the deal on your job search, so go out there are start training learning.

Where can you learn about SQL?

Find someone who knows what they’re talking about and ask them for a lesson. If there are questions that you want answered, then run your queries trying to answer those questions. When you run into a snag, ask a question. Learn by doing, and be productive while you do so.

If you don’t have any SQL experts in your network, there are also online resources available to help you out. http://www.w3schools.com/sql/default.asp?PHPSESSID=300ae3404d5fa2612f238abeebb8869c has a great training program to help you learn the basics of SQL and even offer a quiz at the end so you can test your knowledge. Besides that, just start searching the web, there are a number of free websites out there designed to help people like you learn this database language. Start exploring now.

Advertisements