SISTEM BASIS DATA SI-47-INT [ONP]
0%
Previous
Course data
General
ISH2G4 - DATABASE SYSTEM
PB 1 : Basic Database Concepts - 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: DATA MODELING - 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)
TASK 1 - Week 2-3
Assignments Detail
Submission 1
PB 3: DATA MODELING - RELATIONAL MODEL - Week 3
PDF - DATA MODELLING- 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: NORMALIZATION - Week 4
PDF - NORMALIZATION
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
Instructions for the mid-semester test
Submission
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
Link Detail Tugas 2
Submit Tugas 2
PB 10. Data Control Language (DCL)
PPT - DCL
Video - HandsOn DCL
PB 12. NoSQL
PPT - Konsep NoSQL
Video - NoSQL
PB PROJECT - Week 15 - 16
Guide (english)
Guide (bahasa)
Project Submission
Next
Side panel
Blog
Recent Blog
Create Blog
How To Blog
English (en)
Bahasa Indonesia (id)
English (en)
Log in
ISJ1J3-SI-47-INT
Home
Skip to main content
Course info
Home
Courses
FAKULTAS REKAYASA INDUSTRI (FRI)
PRODI S1 SISTEM INFORMASI (FRI)
2324/2
ISJ1J3-SI-47-INT
Summary
SISTEM BASIS DATA SI-47-INT [ONP]
Teacher:
OKTARIANI NURUL PRATIWI