Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save taufiqur-rahman/f41af77c2cc81d226c158c800b7d221c to your computer and use it in GitHub Desktop.
Save taufiqur-rahman/f41af77c2cc81d226c158c800b7d221c to your computer and use it in GitHub Desktop.
Bismillahirrahmanirrahim
// /////////////////////////////////////////////////////////////////////////////////
// __ __ _ __ __ __ //
// / / / / /_ __ __ __ / /___ __ ___ / /__ ___/ /___ ___ ___ ___ __ ___ //
// / /_/ / _ | // / _ `/ __/ // //__// / _ `/ __ / _ | _ `/ -_)(_-</ /'_ ) //
// |____ /____/____/_//_/___/,___/ /_/_//_/|___/\___/_//_/|__/____/_/\_,_/ //
// //
// /////////////////////////////////////////////////////////////////////////////////
Belajar Bersama Komunitas Kanal #ubuntu-indonesia
INFO
server : irc.freenode.net
port : 6667
kanal : #ubuntu-indonesia
http://webchat.freenode.net/?channels=ubuntu-indonesia
// ///////////////////////////////////////////////////////////////////////////////////////////
Belajar Bersama SQLite
Peraturan
==========
1. Nggak perlu banyak peraturan, yang penting seperti kegiatan belajar bersama sebelumnya dan semua peserta diharapkan untuk aktif berdiskusi.
Rererensi
=========
1. http://www.sqlitetutorial.net/
2. https://www.tutorialspoint.com/sqlite/
3. http://www.guru99.com/sqlite-tutorial.html
Anggota Belajar
===============
Waktu
=====
Setiap Jum'at, Pukul 20.00 Wib s/d Selesai
Pertemuan perdana : 23 Februari 2018
Tujuan
======
Mengenal Query Join dan Relationship ada SQLite3
Browsur
=======
Versi carli >> https://www.dropbox.com/s/dbh55fbdx91gs7y/browsur.png?dl=0
(awalnya versi alpa, trus direvisi jadi beta, trus ini revisi terakhir)
https://git.io/vNa41
Silabus
=======
<hari pertama>
1. Pengenalan SQLite
2. Instalasi
3. Membuat Database
4. Membuat Table
5. Perintah Select Sederhana
<hari kedua>
1. Sintaks dasar SQL
2. Tipe-tipe kolom pada table
3. Primary Key
4. Alter table
5. Drop table
6. Views
7. Indeks
<hari ketiga>
1. Pengenalan DML
2. Perintah insert
3. Perintah update
4. Perintah delete
<hari keempat>
1. Pipeline pada perintah select
2. klausa from
3. cross join
4. inner join
5. outer join
6. klausa where
<hari kelima>
1. klausa grup by
2. klausa having
3. klausa distinc
4. klausa order by
5. klausa limit
<hari keenam>
1. foreign key
2. one to one relationship
3. one to many relationship
4. many to many relationship
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment