SQL ~ ‘Sequel’
-
SQL stands for Structured Query Language
-
SQL lets you access and manipulate databases
-
SQL can execute queries against a database
-
SQL can retrieve data from a database
-
SQL can insert records in a database
-
SQL can update records in a database
-
SQL can delete records from a database
-
SQL can create new databases
-
SQL can create new tables in a database
-
SQL can create stored procedures in a database
-
SQL can create views in a database
-
SQL can set permissions on tables, procedures, and views
There are different versions of the SQL language, but they all support at least the major commands:
- SELECT
- UPDATE
- DELETE
- INSERT
- WHERE
RDBMS - Relational Database Management System this is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.
Every table is broken up into smaller entities called fields. A field is a column in a table that is designed to maintain specific information about every record in the table.
A record, also called a row, is each individual entry that exists in a table. For example, there are 91 records in the above Customers table. A record is a horizontal entity in a table.
it seems to be extremely similar to CSV
SQL Intro and https://www.w3schools.com/sql/sql_quickref.asp