{"id":392,"date":"2025-11-12T07:59:35","date_gmt":"2025-11-12T07:59:35","guid":{"rendered":"https:\/\/satu.ac.id\/bandung\/sistem-informasi\/?p=392"},"modified":"2025-12-01T08:54:33","modified_gmt":"2025-12-01T08:54:33","slug":"build-with-me-bikin-database-dari-nol-pakai-oracle-step-by-step-untuk-pemula","status":"publish","type":"post","link":"https:\/\/satu.ac.id\/bandung\/sistem-informasi\/2025\/11\/12\/build-with-me-bikin-database-dari-nol-pakai-oracle-step-by-step-untuk-pemula\/","title":{"rendered":"Build With Me: Bikin Database dari Nol Pakai Oracle (Step-by-Step untuk Pemula!)"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-393\" src=\"https:\/\/satu.ac.id\/bandung\/sistem-informasi\/wp-content\/uploads\/sites\/5\/2025\/12\/Template-Build-with-Me.png\" alt=\"\" width=\"980\" height=\"445\" \/><\/p>\n<p>Selamat datang di seri <strong>Build With Me<\/strong>, tempat kamu bakal diajak praktik langsung bikin sesuatu yang real dan berguna! \ud83d\udd27\ud83d\udcbb<\/p>\n<p>Di episode kali ini, kita bakal bikin <strong>database pertama kamu<\/strong> dari nol menggunakan Oracle. Tenang, ini beginner-friendly dan cocok buat kamu yang baru mulai memahami Sistem Basis Data.<\/p>\n<div>\n<hr \/>\n<\/div>\n<h2>\ud83d\ude80 Apa yang Akan Kita Bangun?<\/h2>\n<p>Kita akan membuat database sederhana untuk sistem <strong>pendaftaran kursus online<\/strong>, berisi:<\/p>\n<ul data-spread=\"false\">\n<li>Tabel <em>students<\/em><\/li>\n<li>Tabel <em>courses<\/em><\/li>\n<li>Tabel <em>enrollments<\/em><\/li>\n<\/ul>\n<p>Ini contoh yang sering ditemui di dunia nyata dan mudah dipahami.<\/p>\n<div>\n<hr \/>\n<\/div>\n<h2>\ud83e\udde9 <strong>DDL vs DML: Apa Bedanya?<\/strong><\/h2>\n<p>Sebelum mulai ngoding, kamu wajib tahu dua jenis perintah penting dalam SQL:<\/p>\n<h3>\ud83d\udd39 <strong>DDL \u2013 Data Definition Language<\/strong><\/h3>\n<p>DDL dipakai untuk <strong>membuat, mengubah, atau menghapus struktur database<\/strong>. Contoh perintah:<\/p>\n<ul data-spread=\"false\">\n<li><code>CREATE<\/code> \u2192 membuat database atau tabel<\/li>\n<li><code>ALTER<\/code> \u2192 mengubah struktur tabel<\/li>\n<li><code>DROP<\/code> \u2192 menghapus tabel atau objek database<\/li>\n<\/ul>\n<p>\u27a1\ufe0f Intinya: <strong>DDL mengatur bentuk kerangka database.<\/strong><\/p>\n<h3>\ud83d\udd39 <strong>DML \u2013 Data Manipulation Language<\/strong><\/h3>\n<p>DML dipakai untuk <strong>mengolah data di dalam tabel<\/strong>. Contoh perintah:<\/p>\n<ul data-spread=\"false\">\n<li><code>INSERT<\/code> \u2192 menambahkan data<\/li>\n<li><code>UPDATE<\/code> \u2192 memperbarui data<\/li>\n<li><code>DELETE<\/code> \u2192 menghapus data<\/li>\n<li><code>SELECT<\/code> \u2192 mengambil atau menampilkan data<\/li>\n<\/ul>\n<p>\u27a1\ufe0f Intinya: <strong>DML berhubungan dengan isi tabelnya.<\/strong><\/p>\n<p>Setelah ini kamu pasti lebih mudah paham step-step berikutnya.<\/p>\n<div>\n<hr \/>\n<\/div>\n<h2>\ud83d\udee0 Langkah 1: Download Tools<\/h2>\n<ol start=\"1\" data-spread=\"false\">\n<li>Download <a href=\"https:\/\/www.oracle.com\/database\/sqldeveloper\/technologies\/sql-data-modeler\/\" target=\"&quot;_noblank&quot;\">Oracle SQL Developer Data Modeler<\/a><\/li>\n<li>Kamu sekarang siap untuk ngoding SQL! \ud83d\udd25<\/li>\n<\/ol>\n<div>\n<hr \/>\n<\/div>\n<h2>\ud83e\uddf1 Langkah 2: Buat Struktur Tabel<\/h2>\n<h3><strong>Tabel Students<\/strong><\/h3>\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037ccw \u037ccx\" data-is-code-block-view=\"true\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\">\n<div class=\"cm-content\" role=\"textbox\" data-language=\"sql\">\n<pre class=\"cm-line\"><span class=\"\u037c9\">CREATE<\/span> <span class=\"\u037c9\">TABLE<\/span> students (\r\n   student_id NUMBER <span class=\"\u037c9\">PRIMARY<\/span> <span class=\"\u037c9\">KEY<\/span>,\r\n   full_name VARCHAR2(<span class=\"\u037cb\">100<\/span>),\r\n   email VARCHAR2(<span class=\"\u037cb\">100<\/span>)\r\n);<\/pre>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\">\n<div class=\"cm-cursor cm-cursor-primary\"><\/div>\n<\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<h3><strong>Tabel Courses<\/strong><\/h3>\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037ccy \u037ccz\" data-is-code-block-view=\"true\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\">\n<div class=\"cm-content\" role=\"textbox\" data-language=\"sql\">\n<pre class=\"cm-line\"><span class=\"\u037c9\">CREATE<\/span> <span class=\"\u037c9\">TABLE<\/span> courses (\r\n   course_id NUMBER <span class=\"\u037c9\">PRIMARY<\/span> <span class=\"\u037c9\">KEY<\/span>,\r\n   course_name VARCHAR2(<span class=\"\u037cb\">100<\/span>),\r\n   category VARCHAR2(<span class=\"\u037cb\">50<\/span>)\r\n);<\/pre>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\">\n<div class=\"cm-cursor cm-cursor-primary\"><\/div>\n<\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<h3><strong>Tabel Enrollments<\/strong><\/h3>\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037cd0 \u037cd1\" data-is-code-block-view=\"true\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\">\n<div class=\"cm-content\" role=\"textbox\" data-language=\"sql\">\n<pre class=\"cm-line\"><span class=\"\u037c9\">CREATE<\/span> <span class=\"\u037c9\">TABLE<\/span> enrollments (\r\n   enrollment_id NUMBER <span class=\"\u037c9\">PRIMARY<\/span> <span class=\"\u037c9\">KEY<\/span>,\r\n   student_id NUMBER,\r\n   course_id NUMBER,\r\n   enrollment_date <span class=\"\u037c8\">DATE<\/span>,\r\n<span class=\"\u037c9\">   FOREIGN<\/span> <span class=\"\u037c9\">KEY<\/span> (student_id) <span class=\"\u037c9\">REFERENCES<\/span> students(student_id),\r\n<span class=\"\u037c9\">   FOREIGN<\/span> <span class=\"\u037c9\">KEY<\/span> (course_id) <span class=\"\u037c9\">REFERENCES<\/span> courses(course_id)\r\n);<\/pre>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\">\n<div class=\"cm-cursor cm-cursor-primary\"><\/div>\n<\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<div>\n<hr \/>\n<\/div>\n<h2>\u270d\ufe0f Langkah 3: Isi Data Contoh<\/h2>\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037cd2 \u037cd3\" data-is-code-block-view=\"true\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\">\n<div class=\"cm-content\" role=\"textbox\" data-language=\"sql\">\n<pre class=\"cm-line\"><span class=\"\u037c9\">INSERT<\/span> <span class=\"\u037c9\">INTO<\/span> students <span class=\"\u037c9\">VALUES<\/span> (<span class=\"\u037cb\">1<\/span>, <span class=\"\u037ca\">'Rina Putri'<\/span>, <span class=\"\u037ca\">'rina@mail.com'<\/span>);\r\n<span class=\"\u037c9\">INSERT<\/span> <span class=\"\u037c9\">INTO<\/span> students <span class=\"\u037c9\">VALUES<\/span> (<span class=\"\u037cb\">2<\/span>, <span class=\"\u037ca\">'Budi Setiawan'<\/span>, <span class=\"\u037ca\">'budi@mail.com'<\/span>);\r\n<span class=\"\u037c9\">INSERT<\/span> <span class=\"\u037c9\">INTO<\/span> courses <span class=\"\u037c9\">VALUES<\/span> (<span class=\"\u037cb\">1<\/span>, <span class=\"\u037ca\">'Data Analytics 101'<\/span>, <span class=\"\u037ca\">'Technology'<\/span>);\r\n<span class=\"\u037c9\">INSERT<\/span> <span class=\"\u037c9\">INTO<\/span> courses <span class=\"\u037c9\">VALUES<\/span> (<span class=\"\u037cb\">2<\/span>, <span class=\"\u037ca\">'UI\/UX Basics'<\/span>, <span class=\"\u037ca\">'Design'<\/span>);<\/pre>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\">\n<div class=\"cm-cursor cm-cursor-primary\"><\/div>\n<\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<div>\n<hr \/>\n<\/div>\n<h2>\ud83d\udd0d Langkah 4: Coba Query Pertamamu!<\/h2>\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037cd4 \u037cd5\" data-is-code-block-view=\"true\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\">\n<div class=\"cm-content\" role=\"textbox\" data-language=\"sql\">\n<pre class=\"cm-line\"><span class=\"\u037c9\">SELECT<\/span> s.full_name, c.course_name\r\n<span class=\"\u037c9\">FROM<\/span> enrollments e\r\n<span class=\"\u037c9\">JOIN<\/span> students s <span class=\"\u037c9\">ON<\/span> e.student_id = s.student_id\r\n<span class=\"\u037c9\">JOIN<\/span> courses c <span class=\"\u037c9\">ON<\/span> e.course_id = c.course_id;<\/pre>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\">\n<div class=\"cm-cursor cm-cursor-primary\"><\/div>\n<\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<p>Kalau muncul hasilnya, selamat! Kamu baru saja membuat database lengkap dengan relasinya sendiri \ud83c\udf89.<\/p>\n<div>\n<hr \/>\n<\/div>\n<h2>\ud83c\udf31 Belajar Database Itu Jadi Lebih Mudah Kalau\u2026<\/h2>\n<p>\u2026kamu mulai dari praktik kecil seperti ini! Semakin sering kamu mencoba, semakin cepat kamu paham logika dan alurnya.<\/p>\n<p>Dan yang menarik, apa yang kamu bangun di sini adalah pondasi yang dipakai di dunia kerja untuk membuat aplikasi, sistem informasi kampus, hingga platform digital yang dipakai jutaan pengguna.<\/p>\n<p>Tetap eksplor, tetap semangat, dan siapa tahu langkah kecil ini jadi awal perjalananmu menciptakan teknologi yang bermanfaat bagi banyak orang! \ud83d\ude80<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Selamat datang di seri Build With Me, tempat kamu bakal diajak praktik langsung bikin sesuatu yang real dan berguna! \ud83d\udd27\ud83d\udcbb Di episode kali ini, kita bakal bikin database pertama kamu dari nol menggunakan Oracle. Tenang, ini beginner-friendly dan cocok buat kamu yang baru mulai memahami Sistem Basis Data. \ud83d\ude80 Apa yang Akan Kita Bangun? Kita [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":393,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-392","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-artikel"],"_links":{"self":[{"href":"https:\/\/satu.ac.id\/bandung\/sistem-informasi\/wp-json\/wp\/v2\/posts\/392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/satu.ac.id\/bandung\/sistem-informasi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/satu.ac.id\/bandung\/sistem-informasi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/satu.ac.id\/bandung\/sistem-informasi\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/satu.ac.id\/bandung\/sistem-informasi\/wp-json\/wp\/v2\/comments?post=392"}],"version-history":[{"count":1,"href":"https:\/\/satu.ac.id\/bandung\/sistem-informasi\/wp-json\/wp\/v2\/posts\/392\/revisions"}],"predecessor-version":[{"id":394,"href":"https:\/\/satu.ac.id\/bandung\/sistem-informasi\/wp-json\/wp\/v2\/posts\/392\/revisions\/394"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/satu.ac.id\/bandung\/sistem-informasi\/wp-json\/wp\/v2\/media\/393"}],"wp:attachment":[{"href":"https:\/\/satu.ac.id\/bandung\/sistem-informasi\/wp-json\/wp\/v2\/media?parent=392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/satu.ac.id\/bandung\/sistem-informasi\/wp-json\/wp\/v2\/categories?post=392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/satu.ac.id\/bandung\/sistem-informasi\/wp-json\/wp\/v2\/tags?post=392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}