Fullstack Tester

Day 22/100 #100DaysOfQA Today I learned SQL subqueries. #SQL #manualtesting #qaengineer

@ComputerrBooks Wow

LEGO wheel bundle setup for racing games [📹 doctor. engine. channel]

@PythonDvz 1. JavaScript 2. Java 3. Python

What Language Did You Use for Your First "Hello World"?

@PythonPr 100% true. I accept it.

Life of Engineers

@PythonPr It will print both A and B.

Python Quiz: Comment your answer 👇

How To Create Inventory Tracker In Excel.

Day 21/100 #100DaysOfQA Today I learned SQL operators. 1⃣Comparison operators 2⃣Logical operators 3⃣LIKE operator 4⃣BETWEEN, IN, NOT operators 5⃣Set operators #SQL #manualtesting #qaengineer

Proper documentation makes your REST API usable. Without proper docs, other devs won't know how to work with your API. Here, Dominic shows you how to generate an OpenAPI specification and use Scalar to serve them from your Node.js app. freecodecamp.org/news/rest-api-…

🐍 Build Enumerations of Constants With Python's Enum — realpython.com/python-enum/ #python

@PythonPr Answer: 9999 Reason: The data type of variable a is string; when multiplied by 4, it will print the string four times.

Python Quiz: What is the Output?

Recently, I got a 30+ LPA Job Offer from Persistent Systems Position: Data Engineer Application Method: Referral 𝗥𝗼𝘂𝗻𝗱 𝟭 - 𝗧𝗲𝗰𝗵𝗻𝗶𝗰𝗮𝗹 1. Write an SQL query to find employees who earn more than their direct manager. 2. From a transactions table, write a query to identify users who placed more than 20 critical orders every week for at least 1 month. 3. Given a nested JSON file, how would you parse and flatten it in PySpark? 4. How would you design a cost-efficient pipeline in Azure using adf, databricks, and adls? 5. Explain dimensional modeling and how you would design a sales fact table with product and customer dimensions. 𝗥𝗼𝘂𝗻𝗱 𝟮 - 𝗧𝗲𝗰𝗵𝗻𝗶𝗰𝗮𝗹 1. What is the difference between narrow and wide transformations in Spark? Can you give examples? 2. How would you handle schema evolution in a data lake (e.g., a new column gets added in incoming JSON files)? 3. Explain Slowly Changing Dimensions (SCD Type 2). How would you implement it in Spark? 4. How do you optimize Spark jobs to run faster when dealing with terabytes of data? 5. If you are asked to ingest PDF and image files into your pipeline and make them queryable, how would you design it? 6. Explain the bronze-silver-gold architecture in a data lakehouse. Why is this layering important? 7. Suppose your pipeline needs to run across AWS and Azure together (multi-cloud). How would you design secure and cost-effective data access? 𝗥𝗼𝘂𝗻𝗱 𝟯 - 𝗠𝗮𝗻𝗮𝗴𝗲𝗿𝗶𝗮𝗹 / 𝗕𝗲𝗵𝗮𝘃𝗶𝗼𝗿𝗮𝗹 1. Tell me about a time you handled a production issue under pressure. How did you manage it? 2. How do you explain technical solutions to non-technical clients? 3. Imagine a client has unrealistic expectations on delivery timelines how would you handle it? 4. Describe a situation where you worked with multiple teams having conflicting priorities. How did you manage deadlines?

The people getting the most value from AI aren’t asking random questions. They’re giving AI real work. 🔖 Save this thread for later. ❤️ Like & 🔄 Repost if it helped. 💬 Comment “CLAUDE” and I’ll share more practical AI prompts. 🚀 Follow @gudanglifehack for daily AI, Excel, SQL, and Data Analytics content. #ClaudeAI #ArtificialIntelligence #Productivity #Excel #DataAnalytics #AITools #TechTips #BusinessIntelligence #ChatGPT #Automation

Stop using Claude like a chatbot… use it like a work assistant. Most people only use AI for basic writing. But Claude can actually help you analyze data, write better, and build presentations faster. Here’s how to use Claude inside: 📊 Excel → analyze data, build formulas, find insights 📝 Word → rewrite, summarize, and structure content 📑 PowerPoint → create slide decks, outlines, and visuals This is how people are saving hours every week. Save this post you’ll come back to it later. Comment “OFFICE” and I’ll share example prompts you can use.

@PythonDvz Option d. Error is the correct answer. You can not use '+' operator to concatenate two sets, instead of '+' operator you use union() method or '|'. So, correct code should be either print(len(set_1 | set_2)) or print(len(set_1.union(set_2))) both return 5.

What will be the output?? Comment down your answers in comment section.👨🏻‍💻👨🏻‍💻

@PythonDvz C Programming

Can You Recognize This Programming Language?

Day 20/100 #100DaysOfQA Today I learned SQL Clauses. 1⃣WHERE 2⃣GROUP BY 3⃣HAVING 4⃣ORDER BY #sql #ManualTesting

The Big 3 Excel Lookups in Excel

Automation Tools You Should Learn ——— Automation is becoming a must-have skill for modern IT professionals. Whether you're working in Networking, Cloud, System Administration, Cybersecurity, or DevOps, learning automation tools can significantly improve your productivity and career opportunities. 🥇 Python ✔ Network automation ✔ API integration ✔ Security scripting ✔ Cloud automation Why Learn It? The most widely used programming language in IT automation. --- 🥈 Ansible ✔ Agentless automation ✔ Server management ✔ Network configuration ✔ Cloud provisioning Why Learn It? Simple, powerful, and widely adopted in enterprise environments. --- 🥉 Terraform ✔ Infrastructure as Code (IaC) ✔ AWS, Azure, GCP automation ✔ Automated infrastructure deployment Why Learn It? The industry standard for cloud infrastructure automation. --- 🏅 Git & GitHub ✔ Version control ✔ Collaboration ✔ Change tracking ✔ CI/CD integration Why Learn It? Every automation project should be managed through version control. --- 🏅 REST APIs ✔ Device automation ✔ Cloud integration ✔ Application integration ✔ Modern infrastructure management Why Learn It? APIs are the foundation of modern automation. --- ☁️ Kubernetes (K8s) ✔ Container orchestration ✔ Auto-scaling ✔ Cloud-native applications Why Learn It? Essential for modern cloud environments. --- 🔧 Jenkins ✔ CI/CD automation ✔ Build automation ✔ Software deployment Why Learn It? A widely used DevOps automation platform. --- 🌐 Network Automation Tools ✔ Cisco DNA Center ✔ Netmiko ✔ NAPALM ✔ PyATS Why Learn Them? Designed specifically for automating network infrastructure. --- 🤖 AI Automation Tools ✔ ChatGPT ✔ Microsoft Copilot ✔ GitHub Copilot ✔ AIOps Platforms Why Learn Them? AI is rapidly becoming part of everyday IT operations. --- 🎯 Best Learning Path 1️⃣ Python 2️⃣ Git & GitHub 3️⃣ REST APIs 4️⃣ Ansible 5️⃣ Terraform 6️⃣ Kubernetes 7️⃣ AI Tools Simple Idea Then: 👨💻 Configure one device at a time Now: 🤖 Automate hundreds of devices, servers, and cloud resources in minutes The future belongs to IT professionals who can combine: ✔ Infrastructure ✔ Networking ✔ Security ✔ Cloud ✔ Automation ✔ AI #Automation #Python #Ansible #Terraform #GitHub #Kubernetes #CloudComputing #NetworkAutomation #DevOps #ITCareers #Technology