1 / 14

Bahasa Basis Data

1. Bahasa Basis Data. Komang Kurniawan W.,M.Cs. Perkenalan. 1. Nama?. Nama? Bidang keahlian?. 1. 2. 1. Nama? Bidang keahlian? e-Mail/website/no.HP?. 2. 3. Intro. Mata Kuliah : Bahasa Basis Data Kode / SKS : MKK-064 / 2 Waktu (Durasi) : 09.00 – 10.30 (1 jam 30 menit)

bronwyn-hill
Download Presentation

Bahasa Basis Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 1 Bahasa Basis Data Komang Kurniawan W.,M.Cs.

  2. Perkenalan

  3. 1 Nama?

  4. Nama? Bidang keahlian? 1 2

  5. 1 Nama? Bidang keahlian? e-Mail/website/no.HP? 2 3

  6. Intro • Mata Kuliah : Bahasa Basis Data • Kode / SKS : MKK-064 / 2 • Waktu (Durasi) : 09.00 – 10.30 (1 jam 30 menit) • Metode Pembelajaran : • Sharing • Presentasi Kelompok • Latihan

  7. Bobot Penilaian • Keaktifan (Max 15 %, Min 10% )  15 % • Tugas (Max 15%, Min 0 %)  15 % • Quiz 15 % • UTS ( Max 40, Min 20 %)  25 % • UAS (Max 45%, Min 30 %)  30 %

  8. Grade Penilaian

  9. Aturan Perkuliahan • Batas Keterlambatan : 20 menit • Tugas  www.komangkurniawan.com • Syarat ikut UAS kehadiran minimal 75%

  10. Pokok Bahasan • Pengantar Basis Data • Sorting Data • Fungsi dalam SQL • Fungsi lanjut pada SQL • Fungsi Aggregate • Perintah dalam Data Definition Language (DDL) • Manipulasi Data • T-SQL

  11. Reference • Janner Simarmata. 2007. Perancangan Basis Data. Andi Offset. • Raghu Ramakrishnan, Johannes Gehrke. 2003. Sistem Manajemen Database Edisi 3. Mc Graw Hill Education. • Itzik Ben-Gan. 2012. Microsoft SQL Server 2012 T-SQL Fundamentals. O’Reilly Media. • dll.

  12. Pengantar Bahasa Basis Data • Apa itu “Basis Data”? • Apa itu “Bahasa Basis Data”? • Pengelompokan Bahasa Basis Data : • Data Definition Language (DDL) • Data Manipulation Language (DML)

  13. DDL (Data Definition Language) • Struktur basis data yang menggambarkan desain basis data secara keseluruhan. • Implementasi : • Create table • Indeks • Mengubah tabel • Hasil kompilasi DDL  sekumpulan tabel yang disimpan dalam file khusus yang disebut kamus data.

  14. DML (Data Manipulation Language) • Bentuk bahasa basis data untuk melakukan manipulasi dan pengambilan data pada suatu basis data. • Manipulasi berupa : • Penyisipan • Penghapusa • Pengubahan data • Penelusuran

More Related