Category: ব্লগ । Blog
ব্লগ । Blog
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
Apr 27
SQL Server: Dynamic SQL, Stored Procedure, Cursor, SQL Injection, and similar
SQL Server: Dynamic SQL, Stored Procedure, Cursor, SQL Injection, and similar https://youtu.be/uje72uNAT6I?list=PLUA7SYgJYDFoharKbJxz2Hxw6xQITXvBn
Aug 01
PHP Topics to Learn
Identifiers https://docstore.mik.ua/orelly/webprog/php/ch02_01.htm#:~:text=An%20identifier%20is%20simply%20a,ASCII%200x7F%20and%20ASCII%200xFF. PHP Data Types https://www.odinschool.com/learning-hub/php/datatypes Type Hinting https://www.honeybadger.io/blog/php-type-hinting/#:~:text=Type%2Dhinting%20means%20explicitly%20stating,to%20write%20more%20robust%20code. PDO and MySQL https://www.w3schools.com/php/php_mysql_connect.asp PHP OOP https://www.w3schools.com/php/php_oop_what_is.asp abstract classes https://www.w3schools.com/php/php_oop_classes_abstract.asp Abstract vs Interface https://www.w3schools.com/php/php_oop_interfaces.asp#:~:text=PHP%20%2D%20Interfaces%20vs.%20Abstract%20Classes&text=Interfaces%20cannot%20have%20properties%2C%20while,abstract%20keyword%20is%20not%20necessary , methods, interfaces, and inheritance Pillars of OOP The Four pillars of OOPs, abstraction, encapsulation, inheritance, and polymorphism, are integral to understanding and using OOP https://datatrained.com/post/four-pillars-of-oops/#:~:text=The%20Four%20pillars%20of%20OOPs%2C%20abstraction%2C%20encapsulation%2C%20inheritance%2C,to%20understanding%20and%20using%20OOP. Four Pillars with Examples: https://www.geeksforgeeks.org/four-main-object-oriented-programming-concepts-of-java/ Magic …
