SQL Discussion Response 1

profileBreeze96

 

Please see below the discussion in response to the original question asked and respond as a peer using 150 or more words.

Original Question:  Explain SQL and its functions. What do you enjoy the most about learning SQL? What you find the most difficult? 


Peer Response:

Structured Query Language (SQL) is an interface programming language used to communicate with databases and is the standard for relational databases.  It can be used to create, modify, and query databases for information.  There are many functions within SQL available for use to include Data Definition Language commands which are used to define the structure of a database.  Some of these commands are create, alter, and drop.  There is also Data Manipulation Language which is used to modify the data within the database and some of these commands are insert, update, and delete (GeeksforGeeks, 2020).

What I enjoyed most about learning SQL was the hands-on using SQL Live to write and test actual SQL code.  The scripting functionality of the site was very intuitive and user friendly as well.  I appreciate how you could save your sessions as script and reload them at a later time.  I also liked the troubleshooting that could be done by reviewing the session to see which command blocks failed.  The most difficult part for me was trying to make the correlation between relational algebra and SQL.  The symbolic notation and theoretical basis for which SQL is built upon.  Another difficult are is the one to many and many to many notations as sometimes it would get confusing as to which notation went on which side of the line or arrow.

    • 3 years ago
    • 5
    Answer(2)

    Purchase the answer to view it

    blurred-text
    • attachment
      SQLResponse.docx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      BESTANSWERSQLResponse.docx