Getting Started with SQL (Structured Query Language)

Getting Started with SQL (Structured Query Language)

Definition and History

SQL pronounced ess-que-el or see-quel is short for Structured Query Language is a computer language initially invented by an American multinational technology and consulting company known as IBM(International Business Managment Corporation) way back in 1970s using Dr. E. F. Codd’s paper on “A Relational Model of Data for Large Shared Data Banks” for the prototype design It was originally called SEQUEL (Structured English QUEry Language) that handled queries on the collection and organization of data - or simply known as a database. More features were added to the computer software to improve its performance, like building and managing database security, among others. When IBM researchers learned that there is another company that had the same “Sequel” trademark, they renamed it to “S-Q-L” (presently expanded as Structured Query Language).

Uses

The corporate world is now shifting from merely producing products and providing services to investing in digital technologies that handle vast amounts of data, to be transformed into meaningful pieces of information that will generate more profitable income for the company. This is the primary objective of SQL to access and manipulate data that will further lead to business insights. This flexible computer language has been the most widely used communication tool in handling databases. In other words, e SQL is the language that you will use to get what you need from the database.

Installing The Software

To install SQL on your computer, you need two things

  1. Community Server

  2. Management Studio

The community server can vary from the operating system of the host.

For windows

For Linux

Follow the instructions here click here

For Mac