RATED A+
✔✔Subqueries Example - ✔✔SELECT * FROM Students WHERE id IN (SELECT
student_id FROM Honors);
✔✔Join Example - ✔✔SELECT s.name, c.course FROM Students s INNER JOIN
Courses c ON s.id = c.student_id;
✔✔ Design Patterns - ✔✔Reusable solutions to common software design problems that
improve modularity, testability, and maintainability.
✔✔Creational Patterns - ✔✔How objects are created.
✔✔Structural Patterns - ✔✔How classes/objects are composed.
✔✔Behavioral Patterns - ✔✔How objects communicate.
✔✔Factory Pattern - ✔✔Delegates object creation to a factory class.
✔✔Builder Pattern - ✔✔Separates object construction from representation.
✔✔Singleton Pattern - ✔✔Only one instance of a class exists (e.g.,
Runtime.getRuntime()).
✔✔Prototype Pattern - ✔✔Clone existing objects.
✔✔Abstract Factory Pattern - ✔✔Factory of related objects without specifying concrete
classes.
✔✔Object Pool Pattern - ✔✔Reuses expensive objects.
✔✔Observer Pattern - ✔✔Objects get notified when another object changes.
✔✔Iterator Pattern - ✔✔Sequential access to a collection.
✔✔Chain of Responsibility Pattern - ✔✔Pass requests along a handler chain.
✔✔Strategy Pattern - ✔✔Choose algorithm at runtime.
✔✔State Pattern - ✔✔Behavior changes based on internal state.
✔✔Mediator Pattern - ✔✔Central controller for object communication.