1. SQL Tutorial (1) Introduction to SQL

Introduction to SQL

SQL: standard language for accessing and manipulating databases

What is SQL?

• SQL: Structured Query Language
• lets you access & manipulate databases

What can SQL do?

• execute queries against a database
• retrieve data from a database
• insert/update/delete records in a database
• create new databases
• create new tables in a database
• create stored procedures in a database
• create views in a database
• set permissions on tables, procedures, views

RDBMS

: Relational Database Management System

• basis for SQL
• data in RDBMS is stored in database objects called tables
  • table: collection of related data entries
    • consists of columns and rows

SELECT * FROM Customers; 

• table structure
  • fields: column names
  • records: row names

---

This post is based on W3School's articles about SQL.