Introduction to SQL

SQL is an abbreviation for Structured Query Language.

SQL is a language designed specifically for communicating with databases.

SQL is designed to provide the programmer with a simple and efficient way to read and write data from a database.

SQL has several advantages:

  • SQL is not a proprietary language used by specific database vendors. Almost every DBMS supports SQL.
  • SQL is easy to learn. The statements are all made up of descriptive English words and there aren’t many of them.
  • Despite its apparent simplicity, SQL is actually a very powerful language, allowing to perform very complex and sophisticated database operations.

The movielens database we created previously in MySQL follows the following Entity-Relationship diagram:

results matching ""

    No results matching ""