4_SQL-Server.md

SQL-Server

1. Modelagem

   1. Regras formais
   2. Constraints (PK, FK, Unique)

2. SQL

   1. CREATE, ALTER TABLE
   2. INSERT, UPDATE, DELETE
   3. SELECT (GROUP BY, JOINS, SubQuery, CROSS e OUTER APPLY, Tabelas temporárias)
   4. Procedures
   5. Functions
   6. Views e Triggers

---

Metodologia:

Modelagem

SQL