• SISTEM BASIS DATA
    0%
  • Previous
  • Course data
    General
    Announcements
    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
    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 - Week 3 & 4
    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
    Tugas 1 - Week 3 & 4
    Link Detail Tugas
    Submit Tugas 1
    PB 4: RDBMS DAN DATA DEFINITION LANGUAGE 1 - Week 5
    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 4: DATA DEFINITION LANGUAGE 2 - Week 5
    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 5: NORMALISASI - Week 7
    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
    BAHASA RELATIONAL MODEL - Tidak Perlu diajarkan
    PB 6: DATA MANIPULATION LANGUAGE 1 (INSERT, SELECT, UPDATE, DELETE) - Week 9
    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 7: DATA MANIPULATION LANGUAGE 2 (SUB QUERIES & JOIN) - Week 10
    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 8: DATA MANIPULATION LANGUAGE 3 (OPERATOR, GROUP BY, ORDER BY, SQL COUNT(), AVG() DAN SUM(), WILDCARD) - Week 10
    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
    Tugas 2 - Week 10-12
    Link Detail Tugas 2
    Submit Tugas 2
    PB 9: TRIGGER DAN STORED PROCEDURE - Week 12
    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 - Week 13 - 16
    Pengumpulan Laporan Akhir Tugas Besar
    Template Laporan Akhir Tugas Besar - SBD
  • Next
  • English ‎(en)‎
    Bahasa Indonesia ‎(id)‎ English ‎(en)‎
    • Log in
    IFJ1J3-34704
    Home
    Skip to main content

    Course info

    1. Home
    2. Courses
    3. FAKULTAS REKAYASA INDUSTRI (FRI)
    4. S1 Sistem Informasi - Kampus Jakarta
    5. IFJ1J3-34704
    6. Summary

    SISTEM BASIS DATA

    • Teacher: NISA DWI ANGRESTI
    • Teacher: QILBAAINI EFFENDI MUFTIKHALI
    • Teacher: DWINA SATRINIA

    CELOE

    Center of e-Learning and Open Education


    Address

    Gedung Panehan Pasca Sarjana Lantai 1,
    Jl. Telekomunikasi Terusan Buah Batu, 
    Bandung - 40257, Indonesia

      E-Mail: clove@telkomuniversity.ac.id
     Whatsapp Khusus Dosen: +62 821-1666-3563


    Related Links

    Open Library Telkom University  Career, Alumni & Endowment Telkom University

    Follow Us

    • English ‎(en)‎
      • Bahasa Indonesia ‎(id)‎
      • English ‎(en)‎
    You are not logged in. (Log in)