Last active
January 27, 2018 12:24
-
-
Save taufiqur-rahman/f41af77c2cc81d226c158c800b7d221c to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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