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
Community Server
Management Studio
The community server can vary from the operating system of the host.
For windows
You need to install the community server download here
And the management studio download here
For Linux
Follow the instructions here click here
For Mac
- You need to install Docker click here