SQL

(1/2 of SQL vs NoSQL)

Ryan Hayes

TriDev

3/13/2018

Structured Query Language (SQL):

a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS)

(Wikipedia)

   So really it's    RDBMS VS NoSQL

Popular SQL Databases

• Microsoft SQL Server
• MySQL
• PostgreSQL

SQL Database Benefits

Benefits

• Popular ones run everywhere (Windows, Linux, Unix)
• Maturity
• Scalability (Up or out via sharding)
• Availability (Replication)
• Tooling and visibility
  • SQL Server Management Studio
  • VS Code
• Confidence
• ACID Transactions

ACID Transactions are

• Atomic
• Consistent
• Isolated
• Durable

Atomic

All or nothing transactions.

Consistency

One valid state to another.

Isolation

Sequential transactions

Durability

Committed transactions remain in the event of power loss, crashes, errors.