Text

Implementasi Adminstrator Jaringan dan Database

---

Buku ini adalah panduan praktis dan pengenalan Microsoft SQL Server, serta panduan referensi untuk bahasa Transac-SQL yang digunakan oleh produk ini. Ada 18 bab yang membahas mengenai modul utama dan sumber daya dari program ini, serta panduan referensi untuk fungsi dan perintah dari bahasa Transact-SQL SQL Server adalah sebuah produk besar yang memiliki banyak sumber daya dan keistimewaan. Walaupun antarmuka grafisnya menjadikannya mudah dioperasikan, produk ini adalah produk yang sangat kompleks dan sangat rinci (sama seperti database perusahaan lain), dan hanya dengan banyak latihan dan waktu pembaca akan mendapatkan pengetahuan yang mendalam mengenai SQL Server, Karena karakteristik\\r\\nDAFTAR ISI\\r\\n\\r\\nHALAMAN SAMPUL ...................................................................................................................... i\\r\\nHALAMAN JUDUL .......................................................................................................................... ii\\r\\nKATA PENGANTAR ....................................................................................................................... iv\\r\\nDAFTAR ISI ...................................................................................................................................... vi\\r\\n\\r\\nBAB 1 Gambaran Singkat SQL Server............................................................................................ 1\\r\\n1. Arsitektur Client/Server .......................................................................................................... 1\\r\\n2. Arsitektur SQL Server ............................................................................................................ 2\\r\\n3. Komponen SQL Server .......................................................................................................... 3\\r\\na. Database .......................................................................................................................... 3\\r\\nb. Tabel ............................................................................................................................... 5\\r\\nc. Database Diagram ........................................................................................................... 5\\r\\nd. Indeks .............................................................................................................................. 6\\r\\ne. View ................................................................................................................................ 6\\r\\nf. Stored Procedure ............................................................................................................. 7\\r\\ng. Trigger ............................................................................................................................ 7\\r\\nh. Full-Text Indexes ............................................................................................................ 8\\r\\n4. Wizard .................................................................................................................................... 8\\r\\n5. Kesimpulan ............................................................................................................................. 9\\r\\n\\r\\nBAB 2 Membuat Database ............................................................................................................... 10\\r\\n1. Membuat Database secara Manual.......................................................................................... 10\\r\\n2. Membuat Database dengan Wizard ........................................................................................ 12\\r\\n3. Menentukan Rencana Pemeliharaan Untuk Database ............................................................ 16\\r\\na. Database Maintenance Plan Wizard ............................................................................... 16\\r\\nb. Membuat Rencana Pemeliharaan Lain ........................................................................... 22\\r\\n4. Membuat Database Menggunakan Transact-SOL .................................................................. 22\\r\\n5. Mengubah Karakteristik Database ......................................................................................... 23\\r\\n6. Menghapus Database .............................................................................................................. 23\\r\\n7. Melihat Komponen Database ................................................................................................. 23\\r\\n8. Kesimpulan ............................................................................................................................. 24\\r\\n\\r\\nBAB 3 Tabel ....................................................................................................................................... 25\\r\\n1. Karakteristik dari Tabel .......................................................................................................... 25\\r\\na. Filegroup .......................................................................................................................... 25\\r\\n\\r\\nvi\\r\\nb. Tipe Data ......................................................................................................................... 26\\r\\nc. Sinonim ............................................................................................................................ 27\\r\\nd. Batasan ............................................................................................................................. 27\\r\\n2. Tabel Contoh .......................................................................................................................... 28\\r\\n3. Membuat Tabet Dengan Enterprise Manager ........................................................................ 29\\r\\n4. Karakteristik Kolom ............................................................................................................... 29\\r\\na. Kolom Pengenal ............................................................................................................... 31\\r\\nb. Nilai Null ......................................................................................................................... 31\\r\\nc. Kunci Primer .................................................................................................................... 31\\r\\nd. Kunci Asing ..................................................................................................................... 32\\r\\ne. Batasan UNIQUE ............................................................................................................ 32\\r\\nf. Batasan CHECK .............................................................................................................. 32\\r\\n5. Menggunakan Tabel ............................................................................................................... 32\\r\\na. Menghapus Tabel ............................................................................................................. 32\\r\\nb. Mengganti Nama Tabel ................................................................................................... 33\\r\\nc. Melihat Data Tabel .......................................................................................................... 33\\r\\n6. Menyunting Data di Dalam Tabel dengan Enterprise Manager ............................................. 35\\r\\na. Menambah Kotom Baru Ke Datam Tabel ....................................................................... 35\\r\\nb. Menghapus Kolom Dari Tabel ........................................................................................ 35\\r\\nc. Melihat Properti Dari Tabel ............................................................................................. 36\\r\\n7. Membuat Tabel Authors ......................................................................................................... 37\\r\\na. Membuat Kunci Primer ................................................................................................... 38\\r\\n8. Kesimpulan ............................................................................................................................. 39\\r\\n\\r\\nBAB 4 Diagram Database ................................................................................................................. 40\\r\\n1. Membuat Diagram .................................................................................................................. 41\\r\\n2. Menggunakan Diagram .......................................................................................................... 43\\r\\na. Membuka Diagram .......................................................................................................... 43\\r\\nb. Mencetak Diagram ........................................................................................................... 44\\r\\nc. Keluar Dari Diagram ....................................................................................................... 46\\r\\n3. Menggunakan Tabel Pada Diagram Database ........................................................................ 46\\r\\na. Melihat Properti Tabel ..................................................................................................... 46\\r\\nb. Mengubah Tampilan dari Tabel ....................................................................................... 49\\r\\nc. Menambahkan Tabel Ke Dalam Diagram ....................................................................... 50\\r\\nd. Menghapus Tabel Dari Diagram ...................................................................................... 52\\r\\ne. Menambah Tabel-Tabel Yang Berhubungan ................................................................... 53\\r\\nf. Menyertakan Catatan ....................................................................................................... 55\\r\\n\\r\\nvii\\r\\ng. Membuat Tabel Baru ....................................................................................................... 56\\r\\nh. Membuat Hubungan Antartabel ....................................................................................... 57\\r\\n4. Kesimpulan ............................................................................................................................. 59

---

Ketersediaan

Informasi Detail

Judul Seri

-

No. Panggil

004.6 TON i

Penerbit

Semarang : YAYASAN PRIMA AGUS TEKNIK., 2022

Deskripsi Fisik

322 hlm

Bahasa

Indonesia

ISBN/ISSN

9786238130017

Klasifikasi

004.6

Tipe Isi

-

Tipe Media

-

Tipe Pembawa

-

Edisi

-

Subjek

Jaringan Komputer

Info Detail Spesifik

-

Pernyataan Tanggungjawab

Indra Ava Dianta, S.Kom., M.T

Versi lain/terkait

Lampiran Berkas

Komentar

---

Anda harus masuk sebelum memberikan komentar