Text

Basis Data

---

Daftar Isi ......................................................................................... ii \\\\r\\\\nBab I Pendahuluan ................................................................. 1 \\\\r\\\\n1. Deskripsi ..................................................................... 1 \\\\r\\\\n2. Kemampuan Akhir ..................................................... 2 \\\\r\\\\n \\\\r\\\\nBab II Konsep Basis Data \\\\r\\\\n1. Definisi Basis Data ...................................................... 3 \\\\r\\\\n2. Perbedaan File Tradisional dan Basis Data ................ 4 \\\\r\\\\n3. Komponen Basis Data ................................................ 5 \\\\r\\\\n4. Sistem Manajemen Basis Data ................................... 6 \\\\r\\\\n5. Tujuan dan Manfaat Basis Data ................................. 8 \\\\r\\\\n \\\\r\\\\nBab III Elemen Lingkungan Basis Data \\\\r\\\\n1. Arsitektur Basis Data .................................................. 11 \\\\r\\\\n2. Pengguna dalam Basis Data ....................................... 12 \\\\r\\\\n3. File Tabel dan Record ................................................. 14 \\\\r\\\\n \\\\r\\\\nBab IV Model Data Relational \\\\r\\\\n1. Konsep Pemodelan Data ............................................ 16 \\\\r\\\\n2. Model Data Relasional .............................................. 19 \\\\r\\\\n3. Istilah Model Relasional ............................................. 20 \\\\r\\\\n4. Jenis Kunci Relasional ................................................ 21 \\\\r\\\\n5. Keuntungan Model Data Relasional .......................... 23 \\\\r\\\\n \\\\r\\\\nBab V Perancangan Basis Data \\\\r\\\\n1. Definisi ERD ................................................................ 24 \\\\r\\\\n2. Memahami Konsep Dasar ERD .................................. 24 \\\\r\\\\n3. Menjelaskan Komponen ERD ..................................... 25 \\\\r\\\\n4. Membuat Rancangan ERD ......................................... 28 \\\\r\\\\n \\\\r\\\\nBab VI Konsep Normalisasi \\\\r\\\\n1. Konsep Normalisasi .................................................... 37 \\\\r\\\\nvi \\\\r\\\\n \\\\r\\\\n2. Aturan Normalisasi .................................................... 38 \\\\r\\\\n3. Proses Normalisasi .................................................... 39 \\\\r\\\\n4. Merancang Bentuk Normal Pertama (1NF) ............... 40 \\\\r\\\\n5. Merancang Bentuk Normal Tahap kedua (2NF) ........ 42 \\\\r\\\\n6. Merancang Bentuk Normal Tahap ketiga (3NF) ........ 43 \\\\r\\\\n \\\\r\\\\nBab VII Perintah SQL: Data Definition Language (DDL) \\\\r\\\\n1. Menjelaskan Definisi SQL ........................................... 46 \\\\r\\\\n2. Menjelaskan Type data SQL ....................................... 47 \\\\r\\\\n3. Menciptakan Basis Data ............................................. 50 \\\\r\\\\n4. Membuat Desain Tabel dengan Query ...................... 51 \\\\r\\\\n \\\\r\\\\nBab VIII Perintah SQL: Data Manipulation Language (DML) \\\\r\\\\n1. Pengertian DML ......................................................... 61 \\\\r\\\\n2. Perintah Insert dalam Perancangan Basis Data ......... 61 \\\\r\\\\n3. Perintah Select dalam Perancangan Basis Data ......... 62 \\\\r\\\\n4. Perintah Update dalam Perancangan Basis Data ...... 67 \\\\r\\\\n5. Perintah Delete dalam Perancangan Basis Data ........ 68 \\\\r\\\\n \\\\r\\\\nBab IX Advance SQL \\\\r\\\\n1. Fungsi Agregat dalam Perancangan Basis Data ......... 70 \\\\r\\\\n2. Sub Query................................................................... 73 \\\\r\\\\n3. View ........................................................................... 79 \\\\r\\\\n4. Trigger ........................................................................ 82 \\\\r\\\\n \\\\r\\\\nBab X Backup dan Recovery Basis Data \\\\r\\\\n1. Membackup Basis Data .............................................. 85 \\\\r\\\\n2. Merestore Basis Data ................................................. 91 \\\\r\\\\n \\\\r\\\\nDaftar Referensi ....................................................................... 93

---

Availability

Detail Information

Series Title

-

Call Number

005.74 Fit b

Publisher

Jawa Timur : Umsida Press., 2019

Collation

vi, 93 hlm. : 23 cm.

Language

Indonesia

ISBN/ISSN

978-602-5914-89-8

Classification

005.74

Content Type

-

Media Type

-

Carrier Type

-

Edition

-

Subject(s)

Sistem Manajemen Basis Data
Perancangan Basis Data
Bahasa Query Terstruktur

Specific Detail Info

-

Statement of Responsibility

-

Other version/related

File Attachment

Comments

---

You must be logged in to post a comment