• SISTEM BASIS DATA
    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
    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
    PB KHUSUS TUGAS BESAR - Week 15 - 16
    Panduan Tubes
    Submit Tubes
  • Next
  • English ‎(en)‎
    Bahasa Indonesia ‎(id)‎ English ‎(en)‎
    • Log in
    ISJ1J3-32156
    Home
    Skip to main content

    Course info

    1. Home
    2. Courses
    3. FAKULTAS REKAYASA INDUSTRI (FRI)
    4. PRODI S1 SISTEM INFORMASI (FRI)
    5. ISJ1J3-32156
    6. Summary

    SISTEM BASIS DATA

    • Teacher: AHMAD ALMAARIF
    • Teacher: IRFAN DARMAWAN
    • Teacher: SOFY FITRIANI
    • Teacher: FAQIH HAMAMI
    • Teacher: TAUFIK NUR ADI
    • Teacher: OKTARIANI NURUL PRATIWI
    • Teacher: FAUZAN RAMADHAN
    • Teacher: MUHAMMAD RIZQI SHOLAHUDDIN
    • Teacher: YUDHI YANUAR
    • Teacher: IQBAL YULIZAR MUKTI

    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)