SISTEM BASIS DATA SI-47-06 [IFD]
0%
Previous
Course data
General
Announcements
Announcements
ISH2G4 - SISTEM BASIS DATA
PB 1: KONSEP DASAR BASIS DATA - Week 1
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 - Week 2
PDF - PEMODELAN DATA - ENTITY RELATIONAL DIAGRAM
Video Kuliah ERD
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)
Tugas 1 Basdat - Week 2-3
PB 3: PEMODELAN DATA - RELATIONAL MODEL - Week 3
PDF - PEMODELAN DATA - RELATIONAL MODEL
Video Kuliah 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 - Week 4
PDF - NORMALISASI
Video Kuliah 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: RDBMS DAN DATA DEFINITION LANGUAGE 1 - Week 5
PDF - RDBMS DAN DATA DEFINITION LANGUAGE 1
Video Kuliah DDL Part 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 5
Tugas - DATA DEFINITION LANGUAGE 1
FORUM - RDBMS DAN DATA DEFINITION LANGUAGE 1
PB 5: DATA DEFINITION LANGUAGE 2 - Week 6
PDF - DATA DEFINITION LANGUAGE 2
video Kuliah DDL Part 2
w3schools - SQL NOT NULL
w3schools - SQL Primary Key
w3schools - SQL Foreign Key
w3schools - SQL DEFAULT
w3schools - SQL AUTOINCREMENT
w3schools - SQL INDEX
Quiz 6
Tugas - DATA DEFINITION LANGUAGE 2
FORUM - DATA DEFINITION LANGUAGE 2
BAHASA RELATIONAL MODEL - Tidak Perlu diajarkan
PB 6: DATA MANIPULATION LANGUAGE 1 (INSERT, SELECT, UPDATE, DELETE) - Week 7
PPT - DATA MANIPUTALITON LANGUAGE 1 (INSERT, SELECT, UPDATE, DELETE)
Video Kuliah DML Part 1
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 6: DATA MANIPULATION LANGUAGE 2 (OPERATOR, GROUP BY, ORDER BY, SQL COUNT(), AVG() DAN SUM(), WILDCARD) - Week 8
PPT - DML OPERATOR, GROUP BY, ORDER BY, SQL COUNT(), AVG() DAN SUM(), WILDCARD
Video Kuliah DML Part 2
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
UTS
Panduan UTS
Submit UTS
PB 7: DATA MANIPULATION LANGUAGE 3 (SUB QUERIES & JOIN) - Week 10
PPT - DML Sub-Queries & JOIN
PDF - Pendekatan relasi table menggunakan WHERE dan JOIN (PENTING)
Video Kuliah DML : Join & SubQuery
w3schools - SQL SUBQUERIES (ANY and ALL Operators)
w3resource - SQL SUBQUERIES
mysqltutorial - MySQL SUBQUERY
tutorialspoint - SQL - Sub Queries
w3schools - SQL SELECT INTO Statement
Quiz 10
Tugas 1 Subquery
FORUM - Sub-Queries & JOIN
PB 9: TRIGGER DAN STORED PROCEDURE - Week 12
PPT - Trigger dan Stored Procedure
Video - Trigger & 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
Tugas 2 Basdat - Week 12-13
PB 10. Data Control Language (DCL)
PPT - DCL
Video - HandsOn DCL
PB 12. NoSQL
PPT - Konsep NoSQL
Video - NoSQL
Pengumpulan Laporan Akhir Tugas Besar
Template Laporan Akhir Tugas Besar - SBD
PB KHUSUS TUGAS BESAR - Week 15 - 16
Panduan Tubes
Submit Tubes
Panduan UTS
Submit Laporan UTS
NoSQL Database - Week 14 update
Video Kuliah NoSQL
Kuis NoSQL
KUIS DML
REMED DBS
Submit Laporan
Next
Side panel
Blog
Recent Blog
Create Blog
How To Blog
English (en)
Bahasa Indonesia (id)
English (en)
Log in
ISJ1J3-SI-47-06
Home
Skip to main content
Course info
Home
Courses
FAKULTAS REKAYASA INDUSTRI (FRI)
PRODI S1 SISTEM INFORMASI (FRI)
2324/2
ISJ1J3-SI-47-06
Summary
SISTEM BASIS DATA SI-47-06 [IFD]
Teacher:
IRFAN DARMAWAN