Kategori: Programming
WhatApp
Paket program aplikasi ini mempelajari secara full praktek materi kursus yang membahas aplikasi program yang beroperasi pada sistem komputer secara personal ( stand alone ). Aplikasi terdiri C++, Java programming, SQL server sesuai materi yang diinginkan dan diakhir sesi ditugaskan membuat project aplikasi Desktop.
| Nomor | Materi |
|---|---|
| 1 | Introduction to Basic Database Concepts |
| 2 | E-R Modeling and Diagram |
| 3 | Introduction to SQL Server |
| 4 | Introduction to SQL |
| 5 | DDL and DML Statements |
| 6 | Working with Queries (DQL) |
| 7 | Aggregate Functions |
| 8 | Joins and Set Operations |
| 9 | Implementation of Data integrity |
| 10 | Working with Constraints |
| 11 | Implementing Views |
| 12 | Data Control language (DCL) |
| 13 | Working with Indexes |
| 14 | Writing Transact-SQL (T-SQL) |
| 15 | Working with Stored Procedures and Functions |
| 16 | Implementing Triggers |
| 17 | Backup and Restore |