Durasi Training
Reguler Training: 3(Tiga) Hari
Outline Materi
- Understanding Core Database Concepts
- How Data is Stored in Tables
- Relational Database Concepts
- Data Manipulation Language (DML)
- Data Definition Language (DDL)
- Creating Database Objects
- Choose Data Types
- Tables and How to Create Them
- Create Views
- Create Stored Procedures and Functions
- Manipulating Data
- Select Data
- Insert Data
- Update Data
- Delete Data
- Understanding Data Storage
- Normalization
- Primary, Foreign, and Composite Keys
- Indexes
- Administering a Database
- Database Security Concepts
- Database Backups and Restore