Skip to main content

Posts

dBasePertemuan ke 7 (Kisi-kisi UTS)

 Kisi-kisi Ujian Tengah Semester: Silakan dipelajari kembali materi-materi yang lalu berikut Quiz-quiz nya: https://docs.google.com/forms/d/e/1FAIpQLSd8l8DpnA1Ss_l2VwRmaB7YohRzT5SACY0dUFU-WU4g5Y-VIA/viewform https://docs.google.com/forms/d/e/1FAIpQLSdsau9QvNGubDhO0cn2CLPbnZvZJblEKW9Ru9dEXGldRfGNQA/viewform https://docs.google.com/forms/d/e/1FAIpQLSdqohEh0pLez9HT9SowDSg48I11qpg95lruUKZGTOWfKC6iuw/viewform https://docs.google.com/forms/d/e/1FAIpQLSc9vxypcYcVID_7p9ThUKuYSkPFksnHK5UJEZp2a9PuFYdlgw/viewform https://ibi-k57.blogspot.com/2021/10/dbase-lanjutan-pertemuan-6-between.html

DBase Lanjutan Pertemuan 6 BETWEEN, ALIASES, JOINS, Inner JOIN, Left Join, Right Join, Cross Join

  between :  https://www.w3schools.com/mysql/mysql_between.asp Aliases :  https://www.w3schools.com/mysql/mysql_alias.asp Joins :  https://www.w3schools.com/mysql/mysql_join.asp Inner Join :  https://www.w3schools.com/mysql/mysql_join_inner.asp Left Join :  https://www.w3schools.com/mysql/mysql_join_left.asp Right Join:  https://www.w3schools.com/mysql/mysql_join_right.asp Cross Join :  https://www.w3schools.com/mysql/mysql_join_cross.asp

DBase Lanjutan II 5 ( SQL : LIMIT, MIN & MAX, COUNT, AVG, SUM, LIKE, Wilcards, IN)

  LIMIT:      https://www.w3schools.com/mysql/mysql_limit.asp MIN & MAX:      https://www.w3schools.com/mysql/mysql_min_max.asp COUNT, AVG, SUM:      https://www.w3schools.com/mysql/mysql_count_avg_sum.asp LIKE:      https://www.w3schools.com/mysql/mysql_like.asp Wilcards:      h ttps://www.w3schools.com/mysql/mysql_wildcards.asp IN:      https://www.w3schools.com/mysql/mysql_in.asp Kerjakan Quiz Berikut: https://docs.google.com/forms/d/e/1FAIpQLSc9vxypcYcVID_7p9ThUKuYSkPFksnHK5UJEZp2a9PuFYdlgw/viewform

DBase Lanjutan 4 (WHERE, AND, OR and NOT, ORDER by, NULL, UPDATE, DELETE)

  WHERE :   https://www.w3schools.com/mysql/mysql_where.asp AND, OR , NOT :  https://www.w3schools.com/mysql/mysql_and_or.asp ORDER by :  https://www.w3schools.com/mysql/mysql_orderby.asp NULL :  https://www.w3schools.com/mysql/mysql_null_values.asp UPDATE ;  https://www.w3schools.com/mysql/mysql_update.asp DELETE :  https://www.w3schools.com/mysql/mysql_delete.asp Kerjakan QUIZ Berikut: https://docs.google.com/forms/d/e/1FAIpQLSdqohEh0pLez9HT9SowDSg48I11qpg95lruUKZGTOWfKC6iuw/viewform

Dbase Lanjutan 3 ( SQL, SELECT, WHERE, INSERT INTO)

  SQL :  https://www.w3schools.com/mysql/mysql_sql.asp SELECT :  https://www.w3schools.com/mysql/mysql_select.asp WHERE :  https://www.w3schools.com/mysql/mysql_where.asp INSERT INTO :  https://www.w3schools.com/mysql/mysql_insert.asp Kerjakan QUIZ Berikut ini: QUIZ:  https://docs.google.com/forms/d/e/1FAIpQLSdsau9QvNGubDhO0cn2CLPbnZvZJblEKW9Ru9dEXGldRfGNQA/viewform

Rangkaian Digital 2021

   i. Rencana Pembelajaran Semester (RPS)        Download RPS Mata Kuliah .  (perlu password) ii. Daftar Mahasiswa          Absensi Kelas Jum'at (2021)       Absensi Kelas Sabtu (2021)   iii. Jadwal Kuliah        Lihat Kalender Akademik & Jadwal Kuliah I. Buku pegangan kuliah      Tautan ke Buku Pegangan   II. Slide Kuliah     a. Pertemuan Pertama            DOWNLOAD MATERI ke-1      b. Pertemuan Kedua           DOWNLOAD MATERI ke-2       c. Pertemuan Ketiga            DOWNLOAD MATERI ke-3       d. Pertemuan Keempat             DOWNLOAD MATERI ke -4               Kisi-kisi UTS             UTS (Jum'at)         ...