Font size
A-
A
A+
Site color
R
A
A
A
Side panel
You are currently using guest access (
Log in
)
Skip to main content
12S4081 - Pengenalan Basis Data dan Sistem Informasi
Home
Courses
MATEMATIKA DAN ILMU PENGETAHUAN ALAM (MIPA)
MATEMATIKA
Ilmu Komputer
12S4081 PBDSI (2023/2024, Ganjil)
05 Structured Query Language (SQL)
Structured Query Language (Slide)
Structured Query Language (Slide)
Click
https://github.com/dasar-pemrograman/pbdsi/tree/master/19-structured-query-language
link to open resource.
Previous activity
◄ Share your reflection on "Normalization" section!
Jump to...
Jump to...
Announcements
Learning Plan
Course Poster
Learning Video Playlist (YouTube)
Forum Diskusi
Data and Database: An Introduction (Slide)
Database Design: An Overview (Slide)
Data Requirements (Slide)
MiniQuiz 01
Share your reflection on "Database: The Core Concepts" section!
Entity-Relationship Diagram (Slide)
Entities and Their Existence (Slide)
MiniQuiz 02
Share your reflection on "Entity-Relationship (ER) Modeling" section!
Entity Attributes and Primary Keys (Slide)
Relationship Participation (Slide)
Attribute: Role and Types (Slide)
Relationship Attributes (Slide)
MiniQuiz 03
Share your reflection on "Entity-Relationship (ER) Modeling" section!
Relational Data Model (Slide)
Data Types (Slide)
Relation Representation (Slide)
Translating ERD Into Relational Model (Slide)
MiniQuiz 04
Share your reflection on "Relational Data Model" section!
Functional Dependency (Slide)
Normalization: 1st Normal Form (Slide)
Normalization: 2nd Normal Form (Slide)
Normalization: 3rd Normal Form (Slide)
MiniQuiz 05
Share your reflection on "Normalization" section!
SQL Statement: CREATE (Slide)
SQL Statement: ALTER (Slide)
SQL Statement: DROP (Slide)
SQL Statement: INSERT (slide)
SQL Statement: UPDATE and DELETE (slide)
MiniQuiz 06
Share your reflection on "Structured Query Language" section!
SQL Statement: SELECT (Slide)
SQL Clause: JOIN (Slide)
MiniQuiz 07
Share your reflection on "Structured Query Language" section!
Information Systems (slide)
MiniQuiz 08
Share your reflection on "Information Systems" section!
Information Security (slide)
MiniQuiz 09
Share your reflection on "Information Security" section!
Final Exam
Next activity
SQL Statement: CREATE (Slide) ►
Home
Calendar
Course sections
General
A Gentle Introduction
01 Database: The Core Concepts
02 Entity-Relationship (ER) Modeling
03 Relational Data Model
04 Normalization
05 Structured Query Language (SQL)
06 Information Systems: The Core Concepts
07 Information Security At A Glance
08 Evaluation
09 What's Next?