-
Digital Signal Processing Introduction
In this chapter, you will learn introduction of signal processing, real-world application, signals classification, and the evolution of signal processing technique Microsoft PowerPoint – Materi Digital Signal Processing-1
-
Advanced Subquery Practice 1
Please try to solve this 8 cases of advanced subquery based on OP schema. latihan subquery-3
-
Subquery 2 – Advanced Subquery
In this chapter you will learn how to use multiple column-row subquery. You also must know differences of pairwise and non-pairwise comparison scheme. Moreover, we will get more knowledge related with correlated subquery and try using EXIST operator to solve any case. Microsoft PowerPoint – SUBQUERY-2
-
Subquery Practice-2
Please solve these several cases using subquery and set operator Subquery Practice 2
-
Subquery Practice 1
Please try to solve this case using subquery Latihan Subquery-1
-
Single Column Subquery
This chapter contains very basic subquery statement. I will introduce you how to solve some cases that only can be solved by subquery. You must understand this basic material because the other subquery also can result multiple row-column. Microsoft PowerPoint – Subquery
-
Schema Order Product (OP)
Berikut adalah skema relasi order product: DDL dan DML dapat didownload di sini Script_DDL_DML_Order_Product_NEW. Langkah-langkah import sbb: 1. Buatlah user baru bernama OP, kemudian grant role connect dan resource 2. Download dan ekstrak Script_DDL_DML_Order_Product_NEW.rar kemudian taruh file create_Order_Product.sql dan input_Order_Product.sql ke direktori D:\ (direktori bisa bebas) 3. Login ke user OP menggunakan SQL*Plus 4. Jalankan…
-
Oracle Set Operator Practice
You must solve several case using Set Operator based on OE Schema. download practice here
-
Oracle Set Operator
In this chapter, we try to use UNION, UNION ALL, INTERSECT, and MINUS operator in Oracle 11g XE DBMS. download material here
-
Oracle MERGE Operation and DML Subquery Practice
You must use OE schema to answer all ten questions in this practice. Please read all question carefully and understand the aim of each case. Download here