Kode: MT-1205
Durasi : 3 hari
Deskripsi:
Training ini mengajarkan tentang konsep dasar database relasional dan penerapannya. Dalam training ini para siswa berlatih melaksanakan tugas-tugas inti di Microsoft SQL Server.
Prasyarat:
Diharapkan calon peserta sudah biasa menggunakan Aplikasi Office dan sistem operasi Windows.
Materi:
- Understanding Core Database Concepts
- Understand how data is stored in tables
- Understand relational database concepts
- Understand data manipulation language (DML)
- Understand data definition language (DDL)
- Creating Database Objects
- Choose data types
- Understand 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
- Understand normalization
- Understand primary, foreign, and composite keys
- Understand indexes
- Administering a Database
- Understand database security concepts
- Understand database backups and restore