Category: Root
May 04
Oracle Advanced SQL Clauses
Group By group by attr1, attr2 group by ROLLUP(attr1, attr2) group by CUBE(attr1, attr2) Rank, Dense_RANK, ROW_number: RANK() OVER (ORDER BY PRICE) as "PR", ROW_NUMBER() OVER (ORDER BY PRICE) as "PR" DENSE_RANK() OVER (ORDER BY C DESC NULLS LAST) as "R" DENSE_RANK() OVER (PARTITION by C ORDER BY P) as "PR" RANK() OVER (ORDER BY …
Apr 28
Lombak, Getter Setter Example
Ref: https://projectlombok.org/features/GetterSetter import lombok.AccessLevel; import lombok.Getter; import lombok.Setter; public class GetterSetterExample { /** * Age of the person. Water is wet. * * @param age New value for this person’s age. Sky is blue. * @return The current value of this person’s age. Circles are round. */ @Getter @Setter private int age = 10; /** …
Apr 27
Be a Database Professional
Be a Database Professional https://youtu.be/Ipljzg2AjKg https://youtu.be/Ipljzg2AjKg
Apr 27
Database Design in Pictures
Database Design in Pictures https://www.youtube.com/watch?v=LpCFCkCxVSk&pp=ygUac2FsZWFybmluZ3NjaG9vbCBzaXRlc3RyZWU%3D Watch on Youtube
Apr 27
Learn Some Data Flow Diagram (DFD)
Learn Some Data Flow Diagram (DFD) https://www.youtube.com/watch?v=FROyc00v9Sw&pp=ygUac2FsZWFybmluZ3NjaG9vbCBzaXRlc3RyZWU%3D
