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

Selasa, 18 Mei 2010

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......

Tugas Pendahuluan Modul 2 Sesi SQL-SI2 (Jumat 07.00-09.00)

Minggu, 11 April 2010

Find Basic Theory:

• Restricting and Sorting Data
• Comparison Condition
• Logical Operator (NOT, AND, OR)

Question For Modul 2

1. Example of query which has function to Compare Data. (Like, In, Between ---each one by one---)
2. Explain the difeerences and function of umpersand (&) and double umpersand (&&).
3. HR DEPARTMENT want to create a report based on the manager. Create a query and input on the prom by the user for ID and display manager employee_id, lasty_name, salary and department of manager of such employees. Sort by column had been entered. (User input for …Manager_id = 102 )
4. Create a query to display the employee_id, last name, and salary ... sort of salary is the smallest
5. Display last_name who has “H” on the first alphabet.
6. Display last_name who has “A” and “E”

Fix Query:
• Select emp_no, name_last, posisi; salry
From employee_id;
Where gaji => 9000
Or jobs_id like %MAN%

• Slect last_name, job_id
From employes;
Wher jobs_idi
Not in “IT_PROG’,ST_CLEK’;,’SA_REP’;)

Read More......