Group By
Category: Root
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
Apr 27
Database Design in Pictures
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 …
Jun 25
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 …
Jun 25
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 …
Jun 25
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 …




