sandip

654 posts

sandip banner
sandip

sandip

@sandip_dev_07

Full-Stack Developer ✦ SaaS Builder ✦ AI & Automation

India Katılım Mart 2019
366 Takip Edilen81 Takipçiler
sandip
sandip@sandip_dev_07·
📚 Day 10 – Skipped (network issues 🥲) Day 11 – DBMS (SQL DRL) Today I dived into SQL DDL, DML & Joins. @lovebabbar3 @CodeHelp4U ✌️ #DBMS #SQL
sandip tweet media
English
0
0
0
15
Kasif
Kasif@md_kasif_uddin·
As a developer, which one do you prefer more? (Be honest) 👀
Kasif tweet mediaKasif tweet media
English
159
3
148
6.5K
sandip
sandip@sandip_dev_07·
📚 Day 9 – DBMS (SQL DRL) Completed SQL Data Retrieval Language (DRL) basics - focusing on how to query and filter data effectively. Key concepts: • SELECT -> retrieve data from tables • WHERE, BETWEEN, IN -> filter rows • AND / OR / NOT -> combine conditions • LIKE -> pattern searching • ORDER BY -> sort results Aggregation & Grouping: • GROUP BY -> group data • Functions -> COUNT, SUM, AVG, MIN, MAX • HAVING -> filter grouped data (after GROUP BY) • DISTINCT -> unique values • IS NULL -> handle missing data • Learned that SELECT can work without FROM using DUAL tables @lovebabbar3 @CodeHelp4U ✌️ #DBMS #SQL #BackendDevelopment #DataStructures #LearningInPublic
sandip tweet media
English
0
0
4
24
sandip
sandip@sandip_dev_07·
DSA start karta hoon, but pata nahi kaise har baar ghoom phir ke Arrays pe hi aa jaata hoon 🥲 (infinite loop) So I decided to track my daily progress and printed out @striver_79 's DSA sheet. Ab Graphs tak pahunchna hai aur poora complete karna hai ✌️🙂. (I’ve already covered Arrays, Binary Search, Linked List, Strings, Stack & Queue, and Trees — but revision ki kami hai. Kuch din baad sab naya lagne lagta hai 🥲) @takeUforward_ Let’s start the streak now 🚀 #dsa #takeuforward #grind
sandip tweet media
English
1
0
2
37
sandip
sandip@sandip_dev_07·
📚 Day 8 revising DBMS & DSA DBMS: SQL Basics: SQL is used to perform CRUD operations on databases: • Create → Insert new records into a table • Read → Retrieve data from tables • Update → Modify existing records • Delete → Remove specific records Common SQL Data Types: char, varchar, int, float, boolean, datetime, blob, etc. Types of SQL Commands: • DDL (Data Definition Language) Used to define or modify database structure -CREATE, ALTER, DROP, TRUNCATE • DQL (Data Query Language) Used to retrieve data -SELECT • DML (Data Manipulation Language) Used to manipulate table data -INSERT, UPDATE, DELETE • DCL (Data Control Language) Used for access control and permissions -GRANT, REVOKE • TCL (Transaction Control Language) Used to manage transactions -COMMIT, ROLLBACK, SAVEPOINT DSA (Binary Search): • Find minimum in a sorted rotated array (without duplicates) • Find minimum in a sorted rotated array (with duplicates) • Find peak element in an array @lovebabbar3 @CodeHelp4U ✌️🚀 #DBMS #DSA #BinarySearch #DataStructures #ComputerScience #LearningInPublic
sandip tweet media
English
0
0
2
20
sandip
sandip@sandip_dev_07·
📚 Day 7 revising DBMS & DSA DBMS: Transforming ER Model → Relational Model Key mappings: • Strong entity → table with PK • Weak entity → table with {FK + partial key} as composite PK • Single attributes → columns • Composite attributes → split into multiple columns • Multivalued attributes → separate table PK = {FK + attribute} • Generalization → parent table + subtype tables • Aggregation → relationship converted into table @lovebabbar3 @CodeHelp4U ✌️ #DBMS #DSA #BinarySearch #DataStructures #ComputerScience #SoftwareEngineering #LearningInPublic 🚀
sandip tweet media
English
0
0
2
22
Ritik
Ritik@RitikShilp80441·
@sandip_dev_07 @mannupaaji yeah, i can center a div but can i *center* a div? feels like it's about 50/50 tbh. css is my tech debt.
English
1
0
1
8
sandip
sandip@sandip_dev_07·
Recently watched a video by @mannupaaji about design tests. I realized something — I can write the code, build components, and make things work. But when I look at my UI, it doesn’t always feel as clean or modern as many websites today. After seeing some amazing SaaS landing pages, my own UI feels… “shit” 😅 I’m working on a SaaS: slugy.co/app Would really appreciate any feedback, paji ✌️
sandip tweet media
English
1
0
2
39
Codehelp
Codehelp@CodeHelp4U·
When intern say they accidentally deleted the production database
Codehelp tweet media
English
6
0
40
978
sandip
sandip@sandip_dev_07·
📚 Day 6 revising DBMS & DSA DBMS: Relational Model • Relational schema → table structure (name + attributes) • Degree → number of columns • Cardinality → number of rows Keys in relational model: • Super key • Candidate key • Primary key • Alternate key • Foreign key • Composite / Compound key • Surrogate key Integrity constraints: • Domain constraint • Entity constraint -------------------------------------- DSA (Doubly Linked List): • Insertion in DLL • Delete node from DLL • Reverse DLL Revisiting CS fundamentals 🚀 @lovebabbar3 @CodeHelp4U ✌️
sandip tweet mediasandip tweet media
English
0
0
3
51
sandip
sandip@sandip_dev_07·
📚 Day 5 of revising DBMS & DSA fundamentals DBMS: Designing an ER Diagram (Basic Social Media / Facebook-like Platform) Steps followed: 1️⃣ Understand the requirements (most important step) 2️⃣ Identify entity sets 3️⃣ Identify attributes and their types 4️⃣ Identify relationships and constraints Entities & Attributes User Profile • username • full name • email • contact info • date of birth • age User Post • post_id • text_content • media (images/videos) • timestamp User Comment • comment_id • text_comment • timestamp User Like • like_id • timestamp Key Design Considerations • Weak vs Strong relationships • Mapping cardinality (1–1, 1–M, M–M) • Participation constraints ----------------------------- DSA – Linked List • Flattening a Linked List • Clone Linked List with Random Pointer @lovebabbar3 @CodeHelp4U ✌️ #DBMS #DSA #ComputerScience #SystemDesign #DataStructures #SoftwareEngineering #LearningInPublic
sandip tweet mediasandip tweet mediasandip tweet media
English
0
0
3
36
sandip
sandip@sandip_dev_07·
📚 Day 4 of revising DBMS & DSA fundamentals. DBMS Concepts covered today: Thinking and formulating an ER Diagram step-by-step (Basic Banking System Model) 1️⃣ Understand the requirements first Gather as much information as possible about the system. This is one of the most important steps before designing a database. 2️⃣ Identify Entity Sets Determine the main entities involved in the system. 3️⃣ Identify Attributes & Attribute Types Define the properties of each entity and classify them (simple, composite, etc.). 4️⃣ Identify Relationships & Constraints Understand how entities are connected. Key considerations • Weak vs Strong relationships • Mapping cardinality (1–1, 1–M, M–M) • Participation constraints -------------------------------------------- DSA – Linked List Revision • Rotate Linked List • Reverse Nodes in K Groups Revisiting the fundamentals step by step 🚀 @lovebabbar3 @CodeHelp4U ✌️ #DBMS #DSA #ComputerScience #SoftwareEngineering #BackendDevelopment #SystemDesign #DataStructures #LearningInPublic
sandip tweet mediasandip tweet mediasandip tweet media
English
0
0
2
19
sandip
sandip@sandip_dev_07·
100x productivity 🔥 w/ @claudeai
sandip tweet media
English
0
0
2
18
sandip
sandip@sandip_dev_07·
📚 Day 3 of revising DBMS & DSA fundamentals: DBMS Concepts covered today: Extended ER Features • Specialization Splitting an entity into multiple sub-entities based on specific features or roles. (Top-down approach) • Generalization Combining multiple entities into a higher-level entity based on common attributes. (Bottom-up approach) Helps make database design more refined and avoids redundant attributes. • Aggregation A technique where relationships are treated as higher-level entities to represent more complex relationships and reduce redundancy. ------------------------------------------------ DSA – Linked List Revision • Find the intersection point of two linked lists • Detect a loop in a linked list • Check if a linked list is a palindrome • Find the starting point of a loop in a linked list Revisiting fundamentals step by step 🚀 @lovebabbar3 @CodeHelp4U ✌️
sandip tweet mediasandip tweet mediasandip tweet media
English
0
0
2
27