Tuesday, May 10, 2016

SQL

This week, it's been exciting to have been studying SQL (Structured Query Language) commands for creating databases and relational table structures, performing various types of data manipulations and administration and querying the database to retrieve useful information!  These include commands and options such as INSERT, SELECT (FROM, WHERE, GROUP BY, HAVING, ORDER BY), UPDATE, DELETE, COMMIT and ROLLBACK, along with comparison or logical operators and aggregate functions.  Interestingly, SQL is a relatively simple language to learn, comprising a vocabulary of fewer that 100 words.  We've also studied more on relational databases and some basic relational algebra and its operators: UNION, INTERSECT, DIFFERENCE, PRODUCT, SELECT, PROJECT, and JOIN.  I've realized, contrary to the musings of last week's blog, that the SQL 'dialects' (such as Oracle, MySQL) are rather similar, so that in studying and learning one, I can more easily work with any of them.   Furthermore, according to Coronel et al., Oracle was number one in the RDBMS sector in 2010....  Anyway, the industry is always changing, and it'll be interesting to see what happens to DBMS as unstructured data, Big Data, and with it NoSQL, become more prevalent.  Still, it seems there will long, if not always, be a need for structured database models for traditional information, of which the relational one is tops.

No comments:

Post a Comment