SISTEM BASIS DATA
0%
Previous
Course data
General
Announcements
ISH2G4 - SISTEM BASIS DATA
PB 1: KONSEP DASAR BASIS DATA
PDF - KONSEP DASAR BASIS DATA
Youtube - Konsep Basis Data
Youtube - Mengenal Basis Data dan Sistem Basis Data
Blog - Konsep Basis Data
Blog - Komponen Sistem Basis Data
Blog - Pengertian Basis Data
Tugas - KONSEP DASAR BASIS DATA
Quiz 1
FORUM - KONSEP DASAR BASIS DATA
PB 2: PEMODELAN DATA - ENTITY RELATIONAL DIAGRAM
PDF - PEMODELAN DATA - ENTITY RELATIONAL DIAGRAM
Blog - Pemodelan Data - ERD
Youtube - Membuat ER Model dan Diagram
visual-paradigm - What is Entity Relationship Diagram
Wikipedia - Diagram Hubungan Entitas
smartdraw - ENTITY RELATIONAL DIAGRAM
tutorialspoint - ENTITY RELATIONAL DIAGRAM BASIC CONSEPTS
Quiz 2
Tugas 1 - PEMODELAN DATA - ENTITY RELATIONAL DIAGRAM
FORUM - Pemodelan data (ERD,Elemen ERD, Tipe entitas)
PB 3: PEMODELAN DATA - RELATIONAL MODEL
PDF - PEMODELAN DATA - RELATIONAL MODEL
Wikipedia - Model Relasional
guru99 - RELATIONAL MODEL DBMS
Blog - Database Relasional – Konsep, Aplikasi Dan Jenisnya
tutorialspoint - RELATIONAL DATA MODEL
tutorialspoint - ERD to RELATIONAL MODEL
Youtube - Transformasai ERD ke Model Data Relasional Query Language
guru99 - DBMS Keys
Tugas - PEMODELAN DATA - RELATIONAL MODEL
Quiz 3
FORUM - MODEL RELATIONAL
PB 4: NORMALISASI
PDF - NORMALISASI
tutorialspoint - Database Normalization
guru99 - Database Normalization
guru99 - DBMS Functional Dependency
guru99 - DBMS Transitive Dependency
guru99 - DBMS Data Independence
Youtube - Apa itu Normalisasi Basis Data?
Quiz 4
Tugas - NORMALISASI
FORUM - NORMALISASI TABLE
PB 5: BAHASA RELATIONAL MODEL
PDF - BAHASA RELATIONAL MODEL
guru99 - RELATIONAL ALGEBRA DBMS
Youtube - Apa itu Model Data Relational Query Language?
guru99 - Relational Algebra - SELECT
guru99 - Relational Algebra - PROJECTION
guru99 - Relational Algebra - UNION
guru99 - Relational Algebra - Join Operations
Tugas - BAHASA RELATIONAL MODEL
Quiz 5
FORUM - BAHASA MODEL RELATIONAL
PB 6: RDBMS DAN DATA DEFINITION LANGUAGE 1
PDF - RDBMS DAN DATA DEFINITION LANGUAGE 1
guru99 - DBMS Keys
guru99 - SQL Commands Query: : DDL, DML, DCL Query Example
tutorialspoint - SQL Overview
w3schools - SQL Create Database
w3schools - SQL Create Table
w3schools - SQL Alter table
w3schools - SQL Constraints
w3schools - SQL Drop Table
Quiz 6
Tugas - DATA DEFINITION LANGUAGE 1
FORUM - RDBMS DAN DATA DEFINITION LANGUAGE 1
PB 7: DATA DEFINITION LANGUAGE 2
PDF - DATA DEFINITION LANGUAGE 2
w3schools - SQL NOT NULL
w3schools - SQL Primary Key
w3schools - SQL Foreign Key
w3schools - SQL DEFAULT
w3schools - SQL AUTOINCREMENT
w3schools - SQL INDEX
Quiz 7
Tugas - DATA DEFINITION LANGUAGE 2
FORUM - DATA DEFINITION LANGUAGE 2
PB 8: DATA MANIPULATION LANGUAGE 1 (INSERT, SELECT, UPDATE, DELETE)
PPT - DATA MANIPUTALITON LANGUAGE 1 (INSERT, SELECT, UPDATE, DELETE)
PPT - DATA MANIPUTALITON LANGUAGE 1 (INSERT, SELECT, UPDATE, DELETE) - 2
w3schools - SQL INSERT INTO Statement
w3schools - SQL SELECT Statement
w3schools - SQL WHERE Clause
Tugas - DATA MANIPUTALITON LANGUAGE 1
Quiz 8
FORUM - DATA MANIPUTALITON LANGUAGE 1
PB 9: DATA MANIPULATION LANGUAGE 2 (SUB QUERIES & JOIN)
PPT - DML Sub-Queries & JOIN
PDF - Pendekatan relasi table menggunakan WHERE dan JOIN (PENTING)
w3schools - SQL SUBQUERIES (ANY and ALL Operators)
w3resource - SQL SUBQUERIES
mysqltutorial - MySQL SUBQUERY
tutorialspoint - SQL - Sub Queries
w3schools - SQL SELECT INTO Statement
Quiz 9
Tugas 1 Subquery
FORUM - Sub-Queries & JOIN
PB 10: DATA MANIPULATION LANGUAGE 3 (OPERATOR, GROUP BY, ORDER BY, SQL COUNT(), AVG() DAN SUM(), WILDCARD)
PPT - DML OPERATOR, GROUP BY, ORDER BY, SQL COUNT(), AVG() DAN SUM(), WILDCARD
w3schools - SQL MIN() and MAX() Functions
w3schools - SQL COUNT(), AVG() and SUM() Functions
w3schools - SQL LIKE Operator
w3schools - SQL Wildcards
w3schools - SQL BETWEEN Operator
w3schools - SQL Joins
guru99 - DBMS Joins: Inner, Left Outer, THETA Types of Join Operations
Tugas 10 - DML 3
Quiz 10
FORUM - DATA MANIPULATION LANGUAGE 3
PB 11: TRIGGER DAN STORED PROCEDURE
PPT - Trigger dan Stored Procedure
w3schools - SQL Stored Procedure
mysqltutorial - MySQL Stored Procedures
Youtube - MySQL Stored Procedure 7 - Intro to Stored Procedures
Youtube - MySQL Stored Procedure 8 - Procedure Syntax
Youtube - SQL Stored Procedures - What They Are, Best Practices, Security, and More...
Tugas 11 - TRIGGER DAN STORED PROCEDURE
Quiz 11
FORUM - TRIGGER DAN STORED PROCEDURE
PB KHUSUS TUGAS BESAR
Pengumpulan Laporan Akhir Tugas Besar
Template Laporan Akhir Tugas Besar - SBD
Link Pengiriman Tugas Besar Sistem Basis Data
FORUM - TUGAS BESAR
Next
Side panel
English (en)
Bahasa Indonesia (id)
English (en)
Enter your search query
Log in
ISI2J4-30678
Home
Skip to main content
Course info
Home
Courses
FAKULTAS REKAYASA INDUSTRI (FRI)
PRODI S1 SISTEM INFORMASI (FRI)
ISI2J4-30678
Summary
SISTEM BASIS DATA
Teacher:
RIZA AGUSTIANSYAH
Teacher:
IRFAN DARMAWAN
Teacher:
ARI FAJAR SANTOSO
Teacher:
ALBI FITRANSYAH
Teacher:
FAQIH HAMAMI
Teacher:
MARGARETA HARDIYANTI
Teacher:
NUR ICHSAN UTAMA
Teacher:
OKTARIANI NURUL PRATIWI
Teacher:
EDI SUTOYO