SQL is the backbone of all databases. It is flexible, robust, and can be used to extract and manipulate data from databases. In this two part article, Kiran is going to describe the basics of SQL, as well as the more advanced features and functions, such as group by's, joins, etc. If you're new to SQL then this article will get you up to scratch in no time.
SQL is the backbone of all databases. It is flexible, robust, and can be used to extract and manipulate data from databases. SQL uses sentence style queries to work with the data, and rows are returned which the program executing the queries can then read.
In this two part article we're going to learn how SQL works and how we can use it to manipulate data in our databases. I will talk about the SQL language in general, and will not discuss any proprietary SQL relating to any particular type of database system. By the end of this article, you should be able to take what you’ve learnt in and use it to work with basic queries and simple tables.