What is SQL?
So I guess we should first talk about what SQL stands for and what it does. SQL stands for Structured Query Language, and what it is, is a special programming language designed for managing data held in a relational database management. RDBMS
How to learn?
Now more than ever there are many options out there for learning to code. I know that in one of my recent blogs I talked about using HTML on codecademy, but there are many different sites to sharpen your teeth. I really liked the list provided in the blog by Jaime Steven called Every Marketer Should Be Technical. Also just a very good read.
SQL can do many things. SQL can execute queries, retrieve data, can update records, delete records, create new databases, create stored procedures, create views in database, and set permissions on tables, procedures, and views. Basically eliminating Excel from things dealing with your site or where you have to download data. I know that sounds like a lot, and don’t worry you aren’t crazy… it is. The learning curve isn’t terrible. As marketers, we don’t necessarily need to be a web developer, we just need to be able to manipulate pertinent information with out sabotaging what the developer has going on. You can more than double your speed in which you can learn and execute your marketing campaigns and stand to look like a marketing guru. Also just by learning SQL you will be among the few in the marketing arena. The percentage for marketers that know SQL is in single digits. Hello! Can you say differentiation? Differentiation and proficiency = JOB. The field is expansive and has many gaps from skill set to employment. It helps to have a formal education, but you don’t necessarily have to have a degree in computer science to land one of these jobs. I don’t want to take away from the fact that learning SQL takes an incredible amount of time of just sitting down and actually going through commands. There is much to learn. Once again though, as a marketer you really just need to know enough to use data in your marketing world.
So who is doing SQL well?
There are many companies that have enjoyed the success of using SQL. One I want to show is that of Chevron. You can check out many others on this informative Microsoft PDF. These are just an illustration of some companies that are viewable.
|“Chevron, one of the world’s largest oil companies, with assets in more than 100 countries, encourages its employees to analyze data and create rich reports. Information Technology Company, a business unit of Chevron, deployed Microsoft SQL Server 2008 R2 to provide Chevron employees with self-service analysis and report creation capabilities. Users will be able to create enhanced reports with new visualization and analysis tools. The company has also improved the performance of one of its critical business intelligence applications.
Chevron decided to take advantage of its substantial investment in SQL Server by upgrading to Microsoft SQL Server 2008 R2. The organization saw that the software could meet its needs for high availability, self-service reporting and enhanced analysis capabilities.
“The self-service business intelligence features in SQL Server 2008 R2 will give our subject matter experts the tools they need to create their own dynamic reports. They will…have easy access to all their data.”
Stephen Walker, Enterprise Database Architect, Chevron Data Management Solution”
Many companies experience success with the use of SQL in their data manipulation. The field of data is becoming more and more prevalent, and many of us have no idea how to use it in a meaningful way. This is why SQL is our friend. So if you are looking for a new career opportunity or just looking to build your resume, SQL is a great skill to put in your portfolio. I hope you enjoyed. Please feel free to leave your feedback. Always enjoy your insights.