SISTEM BASIS DATA
0%
Previous
Course data
General
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
ISH2G4
Home
Skip to main content
Course info
Home
Courses
FAKULTAS REKAYASA INDUSTRI (FRI)
PRODI S1 SISTEM INFORMASI (FRI)
ISH2G4
Summary
SISTEM BASIS DATA
Teacher:
EDI SUTOYO