Tugas pendahuluan SQL Modul 5 (Selasa - Tanggal 25 Mei)

Selasa, 18 Mei 2010

Find basic teory for: "Displaying Data From Multiple Tables"----> minimal 3 sheet's

Question:
1. Create Expample of queries:
Join Type (Standart SQL 92) ---> Oracle 8i
- equijoin
- outer join
- Self Join

Join Type (Standart SQL 99) ---> Oracle 9i
- cross join
- natural join
- klausa using
- full outer join
- rigth outer join
- left outer join
- Join (used - Klausa ---> "ON")
- Three way join (used - Klausa ---> "ON")
- Join (Used - Klausa ---> "USING")

2. Berikan query untuk menampilkan daftar pegawai yang bekerja pada suatu kota yang inputan kotanya berdasar inputan user.

Read More......

Soal Tugas Pendahuluan Modul 4 Praktikum SQL (Jumat, jam 07.00 pagi)

Cari Dasar Teori: Reporting Agregated Data Using The Group Funtions

1. AVG
2. Count
3. Max
4. Min
5. Sttdev
6. SUM
7. variance

SOAL:
1. Created example for each function and use SQL PLUS / SCL C-Prompt.(avg, Max, Min, Sttdev, Sum, Variance)
2. Display maximum and minimum salary from each jobs.
3. Explain about STDDEV and VARIANCE functions and give the example.
4. What is the different between HAVING clause and WHERE clause?
5. example query use function (Group By ... ... Having)

Read More......

Soal Tugas Pendahuluan SQL Modul 4 (Hari Selasa - 18 Mei 2010)

Sabtu, 15 Mei 2010

Cari Dasar teori: REPORTING AGGREGATED DATA USING THE GROUP FUNCTIONS

Yang termasuk dalam group functions:
1. AVG
2. COUNT
3. MAX
4. MIN
5. STDDEV
6. SUM
7. VARIANCE
8. COVAR_SAMP dan COVAR_POP
9. CORR
10. REGRESI LINIER


SOAL: Berikan contoh masing2...

NOTE: Pelajari materi nya karena ACC tupen akan demo SQL langsung di SQL PLUS di depan asisten...

Read More......

Soal Tugas Pendahuluan Praktikum SQL Modul 3 (Jumat, jam 07.00 pagi)

Minggu, 09 Mei 2010

Cari Dasar Teori Tentang:

Using SIngle Row Function To Customize Output

berserta penjelasan:

-Fungsi yang terdapat didalamnya 

-Character

-Number

-Date

-Koneversi

Soal:

- Buat Contoh dalam SQL C-Prompt masing-masing Fungsi tersebut

Read More......