Category: Root

Oracle Advanced SQL Clauses

Group By

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; /** …

Continue reading

Be a Database Professional

Be a Database Professional https://youtu.be/Ipljzg2AjKg https://youtu.be/Ipljzg2AjKg

Database Design in Pictures

Database Design in Pictures https://www.youtube.com/watch?v=LpCFCkCxVSk&pp=ygUac2FsZWFybmluZ3NjaG9vbCBzaXRlc3RyZWU%3D Watch on Youtube

Learn Some Data Flow Diagram (DFD)

Learn Some Data Flow Diagram (DFD) https://www.youtube.com/watch?v=FROyc00v9Sw&pp=ygUac2FsZWFybmluZ3NjaG9vbCBzaXRlc3RyZWU%3D

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

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 …

Continue reading

MS SQL Server Dynamic SQl, T-SQL

MS SQL Server Dynamic SQl, T-SQL Mostly: Dynamic SQL Stored Procedure Trigger Cursor Function Sayed Ahmed What are the Most Important Most Used Design ERD Convert ERD to database Normalization Indexing SQL Stored Procedure Dynamic SQL These will come, not too frequent Function, User Defined Data Types, Temporary Table Trigger, Cursor SSRS, SSIS, SSAS ML …

Continue reading

Some Topics to Know and Understand to prepare for a DBMS related Job Interview

Some Topics to Know and Understand to prepare for a DBMS related Job Interview ACID ACID: https://www.geeksforgeeks.org/acid-properties-in-dbms Database Normalization 1NF: No repeating groups possible for a cell, PK identified, dependencies mapped 2NF: No Partial Dependence. Non key attributes must have to depend on the full key 3NF: No transitive dependency. non key attributes must have …

Continue reading

Putin Slams Russian mercenary revolt as ‘treason’: Weekend Reads

Best of Bloomberg Opinion This Week Water Risks Are Coming to Bite Investors: Lara Williams The World Ignores Africa at Its Peril: Brooke Sample Italy’s Not the Economic Basket Case You Thought: Lionel Laurent US and India Need to Deal With Their Trust Issues: Mihir Sharma China Wants to Buy Off Europe. The Price Is …

Continue reading