Review Tugas Kelompok PSQL Hari Pertama, Kelas A,B,C
Thursday, March 9, 2017
Wednesday, March 8, 2017
Tugas 2 Pertemuan 2 (T2H2) Praktek Pemrograman SQL Kelas A,B,C
Tugas 2 Pertemuan 2 (T2H2) Praktek Pemrograman SQL Kelas A,B,C
Monday, March 6, 2017
Tugas Pemrograman SQL Kelas A,B,C
Tugas Pemrograman SQL Kelas A,B,C
7 Maret 2017
Desain Tabel, pada database yang sudah dibuat minggu kemarin
Tabel Supplier
Field
|
Type
|
Size
|
Keterangan
|
Kdsup
|
Varchar
|
10
|
Primary Key
|
Nmsup
|
Varchar
|
50
|
|
Tgllhr
|
Date
|
8
|
|
Alamatkantor
|
Varchar
|
50
|
|
Telpkantor
|
Varchar
|
15
|
|
Jekel
|
Varchar
|
15
|
|
Email
|
Varchar
|
20
|
Isi Data
Kdsup
|
Nmsup
|
Tgllhr
|
Alamatkantor
|
Telpkantor
|
Jekel
|
Email
|
Sup001
|
Firman Ilahudin
|
12/04/1980
|
Jl. Gondang Manis
|
0291-5546738
|
Pria
|
|
Sup002
|
Joko Waluyo
|
07/03/1979
|
Jl. Bumi Wonosari
|
024-889772
|
Pria
|
|
Sup003
|
Ilham Wahid
|
19/8/1982
|
Jl. Dersalam
|
0291-889324
|
Pria
|
Tampilkan data
a. Tampilkan Data Supplier yang kantornya daerah Dersalam
b. Tampilkan Data Email Supplier yang rumahnya daerah gondangmanis
c. Tampilkan Data Supplier yang rumahnya daerah Semarang
Tambahkan kasus menampilkan data sendiri, sehingga genap 10 soal
#Tugas dikerjakan, dan di upload di blog masing2, paling lambat jumat jam 11.00
#Kirim alamat blog ke email arif_plstuff@yahoo.com dengan subject
PSQLA_Nim_H2, PSQLB_Nim_H2, PSQLC_Nim_H2
Thursday, March 2, 2017
Tugas praktek Pemrograman SQL Kelas A H1
Daftar Blog
1. https://201553042majid.wordpress.com/2017/03/01/mysql/
2. 201553012-BayuAfrian.blogspot.com
3. https://dimasiswarblog.wordpress.com/2017/03/02/belajar-sederhana-sql-server-2014/
4. https://jihannsr.wordpress.com/2017/03/02/sqlquery-2014-untuk-pemula-dengan-mudah/
5. http://201553024fidianasekarr.blogspot.co.id/2017/03/langkah-dasar-belajar-sql.html
6. http://tradzana16.blogspot.co.id/
7. https://201553037yuliirmawati.wordpress.com/2017/03/02/praktek-pemrograman-praktek-1/
8. https://fiyyablog.wordpress.com/2017/03/02/pengenalan-sql-a/
9. https://rinakh.wordpress.com/?p=21
10.https://linanovianablog.wordpress.com/?p=39
11.http://201553028anisaulya.blogspot.co.id/
12.http://anddriyani.blogspot.co.id/2017/03/perintah-dasar-sql.html
13.https://linanovianablog.wordpress.com/?p=39
14.http://201553022dessyfianti.blogspot.co.id/2017/03/belajar-sql_2.html
15.http://rinakh1.blogspot.co.id/2017/03/praktek-pemprogaman-sql-pertemuan.html
1. https://201553042majid.wordpress.com/2017/03/01/mysql/
2. 201553012-BayuAfrian.blogspot.com
3. https://dimasiswarblog.wordpress.com/2017/03/02/belajar-sederhana-sql-server-2014/
4. https://jihannsr.wordpress.com/2017/03/02/sqlquery-2014-untuk-pemula-dengan-mudah/
5. http://201553024fidianasekarr.blogspot.co.id/2017/03/langkah-dasar-belajar-sql.html
6. http://tradzana16.blogspot.co.id/
7. https://201553037yuliirmawati.wordpress.com/2017/03/02/praktek-pemrograman-praktek-1/
8. https://fiyyablog.wordpress.com/2017/03/02/pengenalan-sql-a/
9. https://rinakh.wordpress.com/?p=21
10.https://linanovianablog.wordpress.com/?p=39
11.http://201553028anisaulya.blogspot.co.id/
12.http://anddriyani.blogspot.co.id/2017/03/perintah-dasar-sql.html
13.https://linanovianablog.wordpress.com/?p=39
14.http://201553022dessyfianti.blogspot.co.id/2017/03/belajar-sql_2.html
15.http://rinakh1.blogspot.co.id/2017/03/praktek-pemprogaman-sql-pertemuan.html
Wednesday, March 1, 2017
Tugas Praktek Pemrograman SQL Kelas C H1
Daftar Blog
1. http://201053060-zaenalmuhlisin.blogspot.co.id
2. http://linaanjel.blogspot.co.id/2017/03/perintah-dasar-sql.html
3. http://newditablog.blogspot.co.id/2017/03/perintah-dasar-sql.html
4. https://imanardh.wordpress.com/2017/03/01/ringkasan-perkuliahan-praktek-pemrograman-sql-pertemuan-pertama/
5. https://tonialfiyan.wordpress.com/2017/03/01/praktek-pemprograman-sql-server/
6. http://201553048-adikribow.blogspot.co.id/2017/03/nama-adi-nugroho-nim-201553048-kelas.html
7. http://muhammadafham04.blogspot.co.id/2017/03/dasar-dasar-pemograman-sql-praktek1.html
8. https://201553023fitachoiyanti.wordpress.com/2017/03/01/coding-pada-sql-dasar-praktikum-mata-kuliah-pemrograman-sql-hari-ini/
9. https://201553030risaerlinawati.wordpress.com/2017/03/01/praktek-pemrograman-sql/
10.http://201553074-myusuf.blogspot.co.id/2017/03/pemrograman-sql-newbie-sql-server-2014.html
11.https://201553038bevimaulidakha.wordpress.com/
12.http://201553073-galehrakasiwi.blogspot.co.id/
13.https://farihdaroini201553001.wordpress.com/2017/03/01/membuat-database-sql-server/
14.http://nurulmashfufah.blogspot.co.id/2017/03/materi-create-database-201553041c-use.html
15.https://erlinanofianti201553006.wordpress.com/2017/03/01/pemrograman-sql-1-c/
16.http://201553074-myusuf. blogspot.co.id/2017/03/ pemrograman-sql-newbie-sql- server-2014.html
1. http://201053060-zaenalmuhlisin.blogspot.co.id
2. http://linaanjel.blogspot.co.id/2017/03/perintah-dasar-sql.html
3. http://newditablog.blogspot.co.id/2017/03/perintah-dasar-sql.html
4. https://imanardh.wordpress.com/2017/03/01/ringkasan-perkuliahan-praktek-pemrograman-sql-pertemuan-pertama/
5. https://tonialfiyan.wordpress.com/2017/03/01/praktek-pemprograman-sql-server/
6. http://201553048-adikribow.blogspot.co.id/2017/03/nama-adi-nugroho-nim-201553048-kelas.html
7. http://muhammadafham04.blogspot.co.id/2017/03/dasar-dasar-pemograman-sql-praktek1.html
8. https://201553023fitachoiyanti.wordpress.com/2017/03/01/coding-pada-sql-dasar-praktikum-mata-kuliah-pemrograman-sql-hari-ini/
9. https://201553030risaerlinawati.wordpress.com/2017/03/01/praktek-pemrograman-sql/
10.http://201553074-myusuf.blogspot.co.id/2017/03/pemrograman-sql-newbie-sql-server-2014.html
11.https://201553038bevimaulidakha.wordpress.com/
12.http://201553073-galehrakasiwi.blogspot.co.id/
13.https://farihdaroini201553001.wordpress.com/2017/03/01/membuat-database-sql-server/
14.http://nurulmashfufah.blogspot.co.id/2017/03/materi-create-database-201553041c-use.html
15.https://erlinanofianti201553006.wordpress.com/2017/03/01/pemrograman-sql-1-c/
16.http://201553074-myusuf. blogspot.co.id/2017/03/ pemrograman-sql-newbie-sql- server-2014.html
26.https://201553025luqmanrosid.wordpress.com/2017/03/01/membuat-database-dengan-sql-server-management-studio/
27.
Subscribe to:
Posts (Atom)