Database MOC

Databases are everywhere:

• Traditional (SQL) Databases
  • ATM, cashier, Airport
• NoSQL Databases
  • Social Media, Maps

---

Databases

• What is Database
  • 2+ Kinds of databases
• Database Management System (DBMS)
  • Data Models in Databases

---

Database Life Cycle

• DB Life Cycle
  1. Requirements Collection
  2. Conceptual Design (ERD)
  3. Logical Design
     • Logical Design (Mapping)
     • SQL
  4. Physical Design
• If we have already DB Design, We should apply Normalization.

---

• Wizard
• Structured Query Language (SQL)
  • Data Types
  • Constraints
  • Data Definition Language (DDL)
  • Data Query Language (DQL)
  • Transaction
• Interview Database

SQL

• MySQL MOC
• SQL Server MOC