Skip to content

README.md

Latest commit

 

History

History
29 lines (20 loc) · 412 Bytes

README.md

File metadata and controls

29 lines (20 loc) · 412 Bytes

Comparing Excel and SQL

Spreadsheets vs. databases

  • Excel

    • Editable

  • SQL

    • Non-editable

  • Databases are better at working with very large datasets.

What is SQL

  • SQL:

    • Structured Query Language
    • A programming language used to mange a database

  • CRUD operations:

    • CREATE
    • READ
    • UPDATE
    • DELETE

  • Example:

    SELECT * FROM Employees WHERE tshirt-size = 'S';