Wednesday, March 18, 2015

Why YOU should write SQL Queries?

For today am going to give YOU guys some two or more reasons why you should write sql queries. But before that I am going to give you a brief definition of what sql query is and a short story about sql query.

SQL is a standard language for accessing databases.
SQL stands for Structured Query Language.
SQL lets you access and manipulate databases.

Now that you have a brief definition of what SQL query is, let me now tell you a short story about a friend of mine, a problem that he had concerning sql illiteracy.

Am not going to give you the name of my friend for the reason of privacy and security reasons too. so my friend was a guy that used to program websites but didn't actually know how to fetch dynamic data form a database. So one day, His boss or let me say his client came to him and wanted him to display data, those data were articles. His client wanted him to display his articles on the website and program his own like button and intergrae a facebook share button on it. In that way the client could see the number of people that liked and share his articles.

Now let me now proceed to give you those resons. These reasons are content reference from w3schools.com

SQL can execute queries against a database. SQL can retrieve data from a database. SQL can insert records in a database. SQL can update records in a database. SQL can delete records from a database. SQL can create new databases. SQL can create new tables in a database. SQL can create stored procedures in a database. SQL can create views in a database. SQL can set permissions on tables, procedures, and views.

Now that YOU have read through this article, I hope you are ready to write sql queries and YOU may even want to be involve more. You could still take the short story of my friend and implement that progrm that will help you increase your programming skills and work.

Thanks for your kind attention :)


Tchokote Herve is back-end web developer and desktop application programmer that spends his time programming for non-profit businesses( or projects) and who is passionate about computer programming and He can't stay a day without coding. Apart from that, He recently was involved in the conception and developement of SelfConsult, a health consultancy network that simplifies lives for doctors and patients to do their consultations. You could visit SelfConsult to know more and contact him.

No comments:

Post a Comment