Master SQL JOINs: INNER, LEFT, RIGHT, FULL

Ever wondered why some developers swear by Jupyter notebooks? In my journey with Java and Node.js, I’ve realized something: exploratory programming changes how you think, not just how you code. Jupyter and IPython create a space where ideas can be tested instantly—no boilerplate, no waiting, just thinking in motion. Instead of writing full scripts upfront, you: • experiment in small chunks • visualize results immediately • iterate without friction That shift alone makes complex problems feel more approachable. Here’s what’s worked for me: 1. Use Jupyter for data exploration and quick visualizations 2. Lean on IPython for fast calculations and iterative testing 3. Combine code + notes to document your thought process as you go It’s less about tools—and more about developing a mindset of curiosity and rapid feedback. These tools didn’t just improve my workflow—they sharpened how I solve problems. Curious—how do you explore data in your projects? #DataScience #Programming

🎯 Tech Learning Journey - Day 03: Web APIs & Requests - Talk to the Internet! Web APIs are how your Python code talks to websites and online services. You send a request, just like asking for information, and the API sends back data that you can use in your application. import requests # Get data from a public API response = requests.get\('https://lnkd.in/gUpgfHqa) data = response.json\(\) print\(f"User: \{data\['login'\]\}"\) print\(f"Repos: \{data\['public\_repos'\]\}"\) Where I use this: Fetching weather updates, getting user data from databases, and integrating third-party services into my apps. #Python #Coding #Programming #WebAPI

I just wrapped up a Student Result Management System built with Python, and I’m excited about the progress. What started as a simple logic exercise quickly turned into a functional tool. Key features I implemented: Data Structures: Used Dictionaries to efficiently map student names to their scores and grades. Control Flow: Applied loops and conditionals to automate grading and result processing. File Handling (The big win!): Integrated .txt file operations so that student data is saved and retrieved even after the program closes. Moving from volatile memory to File Handling felt like a major milestone—it’s the difference between a temporary script and a persistent application. 📂 I’m currently focusing on strengthening my backend fundamentals and building projects that solve small, real-world problems. Next up: Exploring how to structure this more efficiently using Functions or maybe even a CSV format for better data portability! Any tips from the dev community on optimizing file storage in Python? Let me know below! 👇 #Python #CodingJourney #BackendDevelopment #Programming #StudentProject #LearningToCode

Day 6/30 Some concepts look basic… but they are the foundation of real-world systems. 🔹 Problem: Create a simple login system (check username & password) 🔹 What I focused on today: Understanding how validation and conditions work together 🔹 My Thinking Process: Store a predefined username and password Take input from user Compare input with stored values Display success or error message 👉 Small logic, but widely used in real applications 🔹 Inputs I used: Username Password 🔹 Code: Stored_username = "admin" Stored_password = "1234" username = input("Enter username: ") password = input("Enter password: ") if username == Stored_username and password == Stored_password: print("Login Successful!") else: print("Invalid Username or Password") 🔹 Example: Username = admin Password = 1234 Output → Login Successful 🔹 Key Takeaway: Even simple programs can represent real-world systems like authentication, which rely heavily on condition checking #Day6 #Python #30DaysOfCode #LearningInPublic #DataAnalytics #ProblemSolving

Your Python today is whatever PATH hands you. Which python3 tells the truth. 🔎 `which python3` It searches PATH and prints the first match. If you use pyenv, asdf, or virtualenv, you may see a shim, not the real interpreter. Fresh angle: treat this as a tiny audit across machines to guarantee reproducible environments. Before tests on a new CI runner, check which python3 and confirm with `python3 --version`. Small habit, big impact: you stop chasing strange failures caused by interpreter drift. 🐧 Run it right now. Tell me what you find. #linux #terminal #bash #commandline #devops #sysadmin #pythonprogramming #programming #softwareengineering #developer #coding #opensource #productivity #automation #tooling

So, is the underlying code important? I've had this question in my mind lately. When I was self-studying programming languages, I started with C++. Talking with friends who are starting to learn IT, they're all starting with Java or Python as their first programming language. But during my four years of undergraduate studies, I also learned SQL for financial data processing and Power BI for financial business representation. Technology is developing so fast that I feel like I can't keep up sometimes. 🧐

🚀 Day 79 of #100DaysOfCode 💡 LeetCode 338 – Counting Bits Solved today’s problem with a clean and efficient Dynamic Programming + Bit Manipulation approach 💪 🔍 Problem: For a given number "n", return an array where each index "i" contains the number of 1’s in the binary form of "i". ⚡ My Approach: Instead of recalculating bits every time, I reused previous results: 👉 "ans[i] = ans[i >> 1] + (i & 1)" 🧠 Why this works: - "i >> 1" → removes the last bit - "(i & 1)" → checks if last bit is 1 📈 Performance: ✅ Runtime: 3 ms (Beats 95% 🚀) ✅ Memory: 20.14 MB 🔥 Key Learning: Patterns in binary operations can simplify problems drastically. DP + bit tricks = powerful combo ⚡ #Day79 #LeetCode #CodingJourney #Python #DSA #DynamicProgramming #BitManipulation #100DaysOfCode

Applying OOP by building a Bank System 🚀 As part of my Python learning journey, I built a simple Bank Management System using Object-Oriented Programming 🐍 💻 Project: Bank System 🔹 Features: • Create a bank account • Deposit and withdraw money • Check account balance • Basic validation for transactions 🔹 Concepts I used: • Classes and Objects • init method • Instance methods • Class variables • @classmethod and @staticmethod • Input validation This project helped me understand how real-world systems can be modeled using classes and objects. 💡 Biggest learning: Breaking problems into smaller parts and organizing them using OOP makes code much cleaner and scalable. Excited to keep building more real-world projects 🚀 #Python #OOP #MiniProject #BankSystem #CodingJourney #FullStackDeveloper #LearningInPublic

Some problems are not about choosing one path, but about validating all possible paths. Day 24/100 — Data Structures & Algorithms Journey Today’s Problem: Interleaving String This problem challenged me to think in terms of combining two inputs to form a third string while maintaining order. Approach: I used Dynamic Programming to check whether a substring of s3 can be formed using substrings of s1 and s2. At each step, I verified whether the current character in s3 matches with s1 or s2 and updated the DP table accordingly. By storing intermediate results, I was able to efficiently validate all possible combinations. At each step: - Match with s1 - Match with s2 - Store result in DP table Key Takeaways: Dynamic Programming helps manage multiple possibilities efficiently Breaking problems into smaller states simplifies logic Validating combinations is a key problem-solving skill Structured thinking leads to optimized solutions This problem strengthened my understanding of DP and string manipulation. #DSA #LeetCode #DynamicProgramming #ProblemSolving #SoftwareEngineering #CodingJourney #100DaysOfCode #TechLearning #DeveloperJourney #Programming #Python #InterviewPreparation #CodingSkills #ComputerScience #FutureEngineer #TechCareers #SoftwareDeveloper #LearnInPublic #OpenToWork

🐍 Programming Fundamentals — Lab #5 is Live! Making decisions in code is one of the most powerful things you can do as a programmer — and that's exactly what we explored this week! In Lab #5: Conditional Statements in Python, we dived deep into how Python controls the flow of a program based on conditions: ✅ if statement — run code only when a condition is True 🔀 if-else — choose between two paths 🔢 if-elif-else — handle multiple possibilities elegantly 🪆 Nested if — conditions within conditions 🔗 Logical operators (and, or, not) inside conditions ⚡ Ternary operator — one-line if-else expressions We also practiced 30+ exercises — from grade calculators and BMI classifiers to FizzBuzz and leap year checkers. Real problems, real logic! Every program you've ever used makes thousands of decisions per second. Now you know how to write yours. 💡 If you're a beginner learning Python, follow along — we're building solid foundations one lab at a time! 🚀 #Python #ProgrammingFundamentals #LearnToCode #ConditionalStatements #100DaysOfCode #UniversityOfLahore #CodingJourney #TechEducation #PythonBeginners