SQL in 10 Minutes

Notes of Sams Teach Yourself SQL in 10 Minutes

Understanding SQL

DBMS (Database Management System):

  • Apache Open Office Base
  • IBM DB2
  • Microsoft Access
  • Microsoft SQL Server (including Microsoft SQL Server Express)
  • MariaDB
  • MySQL
  • Oracle (including Oracle Express)
  • PostgreSQL
  • SQLite

SQL (Structured Query Language):
An language designed specifically for communicating with databases.

Database:
A container (usually a file or set of files) to store organized data.

Table:
A structured list of data of a specific type.

Schema:
Infomation about database and table layout and properties.

Column:
A single field in a table. All tables are made up of one or more columns.

Datatype:
A type of allowed data. Every table column has an associated datatype that restricts (or allows) specific data in that column.

Row:
A record in a table.

Primary key:
A column (or set of columns) whose values uniquely indentify every row in a table.

Retrieving Data

1
2
3
4
5
6
7
8
SELECT key1
FROM table1;

SELECT key1, key2
FROM table1;

SELECT *
FROM table1;