MD. Nahid Hassan👨‍💻

Software Developer 👨‍💻
🇵🇸 It's my heart ❤️

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

Earth 100 Years After Humanity Suddenly Disappears
What would happen if humanity vanished overnight? No cars. No cities buzzing with life. No lights. No voices. Just nature slowly reclaiming everything we built.
#AI #AIVideo #FutureEarth #EarthWithoutHumans #NatureReclaims

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

📷 Discover This Amazing AI Feature | The Future of AI Is Here!
AI is changing the way we work, create, and solve problems! 📷
#AI #ArtificialIntelligence #AITools #Technology #Innovation #FutureOfAI #Tech #AIUpdates

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

🌆 DHAKA 2050 A Glimpse Into the Future 🇧🇩

🏙️ Smart City
🚘 Future Transportation
🤖 AI & Robotics
🌱 Green Architecture
🌃 Futuristic Skyline
🇧🇩 The Future of Bangladesh
❤️ Like | 💬 Comment | 🔄 Share
#Dhaka2050 #FutureDhaka #Dhaka #Bangladesh #FutureCity #AIVideo #AIArt

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

Back-end code is concerned with how data is exchanged, processed, and stored. Code that handles network requests from your browser or communicates with the database is primarily managed by back-end code.

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

Winners and losers have the same goals.

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

Rules of SET operators

1. ORDER BY can be used only once.
2. Same number of columns
3. Matching data types
4. Same order of columns
5. First query controls aliases.
6. Mapping correct columns

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

#1 Rule SQL Clauses
SET operator can be used almost in all clauses WHERE | JOIN | GROUP BY | HAVING

ORDER BY is allowed only once at the end of the query

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

A great scenario for using an uncontrolled component

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

Uncontrolled: The DOM itself is the source of truth. React does not manage the value; instead, the browser manages it natively, and React "reads" the value only when needed (usually via a ref).

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

The core difference between controlled and uncontrolled components comes down to who controls the form data:

Controlled: The React state is the "single source of truth." The input’s value is driven by React, and updates happen via onChange handlers.

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

Live URL: https://t.co/v7XTI1Vnid
GitHubRepo: https://t.co/ZNpHpo2dv4

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

I recently completed a real-time chat application as part of a frontend engineering assessment. The project demonstrates production-grade implementation of a modern messaging interface with real-time communication, group management, and a polished landing page.

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

React Design Pattern?
Container - Presenter Pattern
1. Container Components: Components that care about what data is shown to the user Example: Data fetching
2. Presentational Components: Components that care about how data is shown to the user Example: Rendering the piece of JSX

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

Inner join in SQL

Return only matching rows from both tables
Syntex: SELECT * FROM A INNER JOIN B ON https://t.co/9Fs3kuVte5 = https://t.co/8XawJ6jc41;

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

Why we use JOIN in SQL:
1. Recombine data
2. Data Inrichment
3. Check existence

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

Basic SQL join

1. No join
2. Inner join
3. Left join
4. Right join
5. Full join

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

Tables join in SQL

Type's of Set Operations:
(union, union all, except, intersect)
Type's of Joins:
(Inner join, Full join, Left join, Right join)

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

Where Operation in SQL:

1. Comparison Operator
- ( =, <>, =!, >, >=, <, <=)
2. Logical Operator
- (AND, OR, NOT)
3. Range Operator
- (BETWEEN)
4. Membership Operator
- (IN, NOT IN)
5. Search Operator
- (LIKE)

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

Understanding System Design

[MD. Nahid Hassan👨‍💻 @nahidhasandev]

SQL execution orders