Tuesday, July 27, 2010

SQL

At a first glance, learning SQL seemed very complex. The idea of creating different tables that are related to each other seemed tedious at first but later made more sense when trying to extract certain information from the tables. This idea became more obvious when experimenting with the queries. It has become clearer why learning about Entity Relationship Diagrams is critical before learning about SQL. The hardest part about SQL is to understand the concepts just mentioned. Thereafter, it is a matter of knowing where to find and/or trying to memorize the commands on how to create, open and insert information. During the assignment, we had the opportunity to create tables in MySQL with the command line, Webmin and phpMyAdmin. Webmin and phpMyAdmin are graphical interfaces and therefore easier to navigate and create tables. Overall, learning SQL is on the same level if difficulty with other topics explored; once one understands the idea and concept of the topic, the rest is still challenging yet less complex.

No comments:

Post a Comment