Samrid Dangol

🔗

[Samrid Dangol @samrid2025]

I am publicly committing to #60DaysOfLearning2026 challenge and #LearningWithLeapfrog from June!
@lftechnology

[Samrid Dangol @samrid2025]

#LSPPDay53
Today, I learned how to set up basic components using Tailwind CSS and organize my code into separate files for better maintainability, and efficiency.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay52
Today, I learned the differences between PDO, MySQLi, and MySQL, why to choose PDO over MySQLi, different data-fetching techniques, and PDO option settings.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay51
Today, I revised SQL injection attacks and learned different ways to prevent them in PHP while interacting with a SQL database.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay50
Today, I learned more about PDO and file organization in PHP for database operations.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay49
Today, I learned about PDO and how to use it to connect PHP to a MySQL database.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay48
Today, I learned how to refactor functions in PHP to make them cleaner, more readable, and easier to maintain.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay47
Today, I learned about the different types of arrays in PHP, including indexed and associative arrays.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay46
Today, I learned the basics of handling user input in PHP using forms, URL parameters, and request methods such as GET and POST, along with their differences.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay45
Today, I revised some PHP basics and learned about string and number functions in PHP.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay44
Today, I learned the basics of recursive CTEs in SQL.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay43
Today, I continued learning about SQL window functions such as NTILE(), CUME_DIST(), and PERCENT_RANK(), and how they work.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay42
Today, I learned more about SQL window functions such as FIRST_VALUE(), LAST_VALUE(), and NTH_VALUE(), and how different frame clauses affect their results.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay41
Today, I learned about SQL window functions and how RANK(), DENSE_RANK(), and ROW_NUMBER() work.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay40
Today, I learned about string functions in SQL.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay39
Today, I learned more about CTEs in SQL, the different types of CTEs, and revised joins.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay38
Today, I learned about CTEs in SQL, how they work, why to use them, and how they differ from subqueries.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay36
Today, I learned about database recovery techniques in DBMS, including log-based recovery, checkpointing, and backup and recovery.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay35
Today, I learned about functional dependency in DBMS, its different types, and Armstrong's axioms.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay33
Today, I learned about the database development lifecycle in DBMS, including the different types of database design and the phases of the database design lifecycle.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog

[Samrid Dangol @samrid2025]

#LSPPDay32
Today, I learned about denormalization, why it is used, its importance, and the risks and challenges associated with it.
@lftechnology
#60DaysOfLearning2026 #LearningWithLeapfrog