User
Write something
Pinned
(New Members Start Here) Welcome to QA Automation Bootcamp!
๐Ÿ‘‹ Hey there! ๐–๐ž๐ฅ๐œ๐จ๐ฆ๐ž ๐ญ๐จ ๐ญ๐ก๐ž ๐œ๐จ๐ฆ๐ฆ๐ฎ๐ง๐ข๐ญ๐ฒ! ๐‹๐ž๐ญ'๐ฌ ๐ญ๐ซ๐š๐ง๐ฌ๐Ÿ๐จ๐ซ๐ฆ ๐ฒ๐จ๐ฎ๐ซ ๐œ๐š๐ซ๐ž๐ž๐ซ ๐ญ๐จ๐ ๐ž๐ญ๐ก๐ž๐ซ. If you've ever tried to learn QA Automation and it didn't go well... ๐ข๐ญ'๐ฌ ๐๐Ž๐“ ๐ฒ๐จ๐ฎ๐ซ ๐Ÿ๐š๐ฎ๐ฅ๐ญ. There were ๐๐Ž ๐ฉ๐ซ๐จ๐ฉ๐ž๐ซ ๐ซ๐ž๐ฌ๐จ๐ฎ๐ซ๐œ๐ž๐ฌ ๐๐ž๐ฌ๐ข๐ ๐ง๐ž๐ ๐Ÿ๐จ๐ซ learning it the RIGHT WAY. ๐€๐›๐จ๐ฎ๐ญ ๐Œ๐ž I'm ๐Œ๐š๐ญ๐ฏ๐ข๐ฒ, a Vegas-based ๐๐ซ๐ข๐ง๐œ๐ข๐ฉ๐š๐ฅ ๐’๐ƒ๐„๐“ ๐ฐ๐ข๐ญ๐ก ๐Ÿ๐ŸŽ+ ๐ฒ๐ž๐š๐ซ๐ฌ ๐จ๐Ÿ ๐ž๐ฑ๐ฉ๐ž๐ซ๐ข๐ž๐ง๐œ๐ž from small startups to large enterprises. I've interviewed ๐ก๐ฎ๐ง๐๐ซ๐ž๐๐ฌ ๐จ๐Ÿ ๐ฆ๐š๐ง๐ฎ๐š๐ฅ ๐ญ๐ž๐ฌ๐ญ๐ž๐ซ๐ฌ trying to make the switch to automation. Seeing how people struggle, I decided to create this community, so ๐ฒ๐จ๐ฎ ๐œ๐š๐ง ๐ฌ๐ค๐ข๐ฉ ๐š๐ฅ๐ฅ ๐ญ๐ก๐ž ๐›๐š๐ ๐ฌ๐ญ๐ฎ๐Ÿ๐Ÿ ๐š๐ง๐ ๐ ๐จ ๐ฌ๐ญ๐ซ๐š๐ข๐ ๐ก๐ญ ๐ญ๐จ ๐ฐ๐ก๐š๐ญ ๐š๐œ๐ญ๐ฎ๐š๐ฅ๐ฅ๐ฒ ๐ฐ๐จ๐ซ๐ค๐ฌ. ใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒป ๐Ÿ’ฌ ๐“๐ก๐ž ๐†๐จ๐š๐ฅ ๐จ๐Ÿ ๐“๐ก๐ข๐ฌ ๐‚๐จ๐ฆ๐ฆ๐ฎ๐ง๐ข๐ญ๐ฒ: Ensure that ๐š๐ง๐ฒ aspiring QA Automation Engineer or SDET can: โœ… Learn QA Automation in an ๐ž๐š๐ฌ๐ฒ ๐š๐ง๐ ๐Ÿ๐š๐ฌ๐ญ ๐ฐ๐š๐ฒ โœ… Know how to ๐ฌ๐ญ๐š๐ง๐ ๐จ๐ฎ๐ญ during the job search โœ… Be ๐ฉ๐ซ๐ž๐ฉ๐š๐ซ๐ž๐ ๐Ÿ๐จ๐ซ ๐š๐ง๐ฒ ๐ข๐ง๐ญ๐ž๐ซ๐ฏ๐ข๐ž๐ฐ ๐Ÿšจ ๐๐ฎ๐ญ ๐๐ž๐Ÿ๐จ๐ซ๐ž ๐“๐ก๐š๐ญ... ๐‹๐ž๐ญ'๐ฌ ๐’๐ญ๐š๐ซ๐ญ ๐–๐ข๐ญ๐ก ๐–๐ก๐š๐ญ ๐˜๐จ๐ฎ ๐’๐ก๐จ๐ฎ๐ฅ๐ ๐’๐“๐Ž๐ ๐ƒ๐จ๐ข๐ง๐  ๐‘๐ข๐ ๐ก๐ญ ๐๐จ๐ฐ: 1. ๐’๐ญ๐š๐ซ๐ญ๐ข๐ง๐  ๐ฒ๐จ๐ฎ๐ซ ๐š๐ฎ๐ญ๐จ๐ฆ๐š๐ญ๐ข๐จ๐ง ๐ฃ๐จ๐ฎ๐ซ๐ง๐ž๐ฒ ๐ฐ๐ข๐ญ๐ก ๐’๐ž๐ฅ๐ž๐ง๐ข๐ฎ๐ฆ... Please don't do that. Stop. Its outdated. 2. ๐‹๐ž๐š๐ซ๐ง๐ข๐ง๐  ๐‰๐š๐ฏ๐š/๐‚# ๐Ÿ๐จ๐ซ ๐š๐ฎ๐ญ๐จ๐ฆ๐š๐ญ๐ข๐จ๐ง... When there's a language that's ๐Ÿ๐ŸŽ๐ฑ ๐ž๐š๐ฌ๐ข๐ž๐ซ and more in demand. 3. ๐€๐ข๐ฆ๐ข๐ง๐  ๐š๐ญ "๐‰๐ฎ๐ง๐ข๐จ๐ซ" ๐š๐ฎ๐ญ๐จ๐ฆ๐š๐ญ๐ข๐จ๐ง ๐ซ๐จ๐ฅ๐ž๐ฌ... Don't waste your potential. You can do much better. 4. ๐“๐ซ๐ฒ๐ข๐ง๐  ๐ญ๐จ ๐ฅ๐ž๐š๐ซ๐ง "๐ž๐ฏ๐ž๐ซ๐ฒ๐ญ๐ก๐ข๐ง๐ "... Most courses teach 80% fluff you'll never use on the job. ๐ŸŽ“ ๐–๐š๐ง๐ญ ๐ญ๐จ ๐Š๐ง๐จ๐ฐ ๐–๐ก๐š๐ญ ๐ญ๐จ ๐ƒ๐จ ๐ˆ๐ง๐ฌ๐ญ๐ž๐š๐? ๐€๐ฌ ๐š ๐…๐‘๐„๐„ ๐ฆ๐ž๐ฆ๐›๐ž๐ซ, ๐ฒ๐จ๐ฎ ๐ ๐ž๐ญ ๐ข๐ง๐ฌ๐ญ๐š๐ง๐ญ ๐š๐œ๐œ๐ž๐ฌ๐ฌ ๐ญ๐จ: ๐Ÿ๏ธโƒฃ ๐Œ๐š๐ง๐ฎ๐š๐ฅ ๐๐€ ๐ญ๐จ ๐’๐ƒ๐„๐“ ๐“๐ก๐ž ๐‘๐จ๐š๐๐ฆ๐š๐ฉ ๐–๐จ๐ซ๐ค๐ฌ๐ก๐จ๐ฉ (๐Œ๐ข๐ง๐ข-๐œ๐จ๐ฎ๐ซ๐ฌ๐ž๐ฌ). ๐Ÿ ๐ก๐จ๐ฎ๐ซ ๐ญ๐ก๐š๐ญ ๐ฌ๐š๐ฏ๐ž๐ฌ ๐ฒ๐จ๐ฎ ๐ฆ๐จ๐ง๐ญ๐ก๐ฌ. - Free 3-part video roadmap workshop for manual QAs and beginners who want a clear, step-by-step path to mid-level SDET roles and higher-paying QA automation jobs. ๐Ÿ๏ธโƒฃ ๐Œ๐š๐ฌ๐ญ๐ž๐ซ๐ข๐ง๐  ๐€๐ˆ ๐Ÿ๐จ๐ซ ๐๐€ ๐๐ซ๐จ๐Ÿ๐ž๐ฌ๐ฌ๐ข๐จ๐ง๐š๐ฅ๐ฌ - Learn how to use AI tools to accelerate your QA carrer ๐Ÿ‘๏ธโƒฃ ๐‚๐จ๐ฆ๐ฆ๐ฎ๐ง๐ข๐ญ๐ฒ ๐€๐œ๐œ๐ž๐ฌ๐ฌ - Connect with other testers making the same journey - Get answers to your questions ใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒปใƒป ๐Ÿ‘‰ ๐˜๐จ๐ฎ๐ซ ๐๐ž๐ฑ๐ญ ๐’๐ญ๐ž๐ฉ๐ฌ: ๐’๐ญ๐ž๐ฉ ๐Ÿ: Go to the "๐‚๐ฅ๐š๐ฌ๐ฌ๐ซ๐จ๐จ๐ฆ" and watch the ๐Œ๐š๐ง๐ฎ๐š๐ฅ ๐๐€ ๐ญ๐จ ๐’๐ƒ๐„๐“ ๐–๐จ๐ซ๐ค๐ฌ๐ก๐จ๐ฉ ๐’๐ญ๐ž๐ฉ ๐Ÿ: Take the ๐Œ๐š๐ฌ๐ญ๐ž๐ซ๐ข๐ง๐  ๐€๐ˆ ๐Ÿ๐จ๐ซ ๐๐€ ๐๐ซ๐จ๐Ÿ๐ž๐ฌ๐ฌ๐ข๐จ๐ง๐š๐ฅ๐ฌ ๐‚๐จ๐ฎ๐ซ๐ฌ๐ž to become AI ready
(New Members Start Here) Welcome to QA Automation Bootcamp!
Pinned
๐Ÿ“Œ QA Automation Accelerator Memberships: Everything You Need To Know
๐“๐ก๐ž ๐๐€ ๐€๐ฎ๐ญ๐จ๐ฆ๐š๐ญ๐ข๐จ๐ง ๐†๐š๐ฉ ๐๐จ๐›๐จ๐๐ฒ ๐“๐š๐ฅ๐ค๐ฌ ๐€๐›๐จ๐ฎ๐ญ โคท You've finished another online course โคท You understand a Testing Framework โคท You've built a few test scripts, maybe even completed a portfolio project But when you look at job postings asking for "2+ years of QA Automation experience," you freeze. ๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ ๐ค๐ง๐จ๐ฐ๐ฅ๐ž๐๐ ๐ž ๐ข๐ฌ๐งโ€™๐ญ ๐ญ๐ก๐ž ๐ฌ๐š๐ฆ๐ž ๐š๐ฌ ๐ฃ๐จ๐›-๐ซ๐ž๐š๐๐ฒ ๐ฌ๐ค๐ข๐ฅ๐ฅ๐ฌ. ๐€๐ง๐ ๐ž๐ฆ๐ฉ๐ฅ๐จ๐ฒ๐ž๐ซ๐ฌ ๐ค๐ง๐จ๐ฐ ๐ข๐ญ ๐ญ๐จ๐จ. โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ ๐Ÿšฉ ๐–๐ก๐š๐ญโ€™๐ฌ ๐€๐œ๐ญ๐ฎ๐š๐ฅ๐ฅ๐ฒ ๐Œ๐ข๐ฌ๐ฌ๐ข๐ง๐ : The gap between โ€œ๐ˆ ๐ฅ๐ž๐š๐ซ๐ง๐ž๐ ๐š๐ฎ๐ญ๐จ๐ฆ๐š๐ญ๐ข๐จ๐งโ€ and โ€œ๐ˆ ๐œ๐š๐ง ๐๐จ ๐ญ๐ก๐ข๐ฌ ๐ฃ๐จ๐›โ€ comes down to 3 things: โถ Structured, real-world training that goes beyond basics. โ‰ซ Most courses teach tools. They don't teach you how to think like an SDET and QA Automation Engineer, build frameworks from scratch, or integrate CI/CD pipelines the way companies actually use them. โท Proof of competency that employers trust. โ‰ซ Saying "I know Playwright" on your resume means nothing without verified credentials. Employers need tangible evidence you can do the work. โธ Deliberate practice on the exact skills interviews test. โ‰ซ You can't Google your way through a technical interview. You need to have answered these questions dozens of times before you walk into that room. ๐Ÿ“Œ ๐“๐ก๐š๐ญโ€™๐ฌ ๐ฐ๐ก๐ฒ ๐ฐ๐ž ๐›๐ฎ๐ข๐ฅ๐ญ ๐๐€ ๐€๐ฎ๐ญ๐จ๐“๐ž๐ฌ๐ญ ๐€๐œ๐œ๐ž๐ฅ๐ž๐ซ๐š๐ญ๐จ๐ซ ๐“๐ซ๐š๐ข๐ง๐ข๐ง๐ : ๐€ ๐œ๐จ๐ฆ๐ฉ๐ฅ๐ž๐ญ๐ž ๐ฌ๐ฒ๐ฌ๐ญ๐ž๐ฆ ๐ญ๐ก๐š๐ญ ๐œ๐จ๐ฆ๐›๐ข๐ง๐ž๐ฌ ๐ฌ๐ญ๐ซ๐ฎ๐œ๐ญ๐ฎ๐ซ๐ž๐ ๐ญ๐ซ๐š๐ข๐ง๐ข๐ง๐ , ๐ฏ๐ž๐ซ๐ข๐Ÿ๐ข๐ž๐ ๐œ๐ž๐ซ๐ญ๐ข๐Ÿ๐ข๐œ๐š๐ญ๐ข๐จ๐ง, ๐š๐ง๐ ๐€๐ˆ-๐ฉ๐จ๐ฐ๐ž๐ซ๐ž๐ ๐ˆ๐ง๐ญ๐ž๐ซ๐ฏ๐ข๐ž๐ฐ ๐ฉ๐ซ๐š๐œ๐ญ๐ข๐œ๐ž ๐ญ๐จ ๐ญ๐š๐ค๐ž ๐ฒ๐จ๐ฎ ๐Ÿ๐ซ๐จ๐ฆ ๐ณ๐ž๐ซ๐จ ๐ญ๐จ ๐ฃ๐จ๐›-๐ซ๐ž๐š๐๐ฒ ๐ฆ๐ข๐-๐ฅ๐ž๐ฏ๐ž๐ฅ ๐’๐ƒ๐„๐“ ๐จ๐ซ ๐๐€ ๐€๐ฎ๐ญ๐จ๐ฆ๐š๐ญ๐ข๐จ๐ง ๐„๐ง๐ ๐ข๐ง๐ž๐ž๐ซ ๐ข๐ง ๐Ÿ‘-๐Ÿ’ ๐ฆ๐จ๐ง๐ญ๐ก๐ฌ ๐‡๐ž๐ซ๐žโ€™๐ฌ ๐‡๐จ๐ฐ ๐ˆ๐ญ ๐–๐จ๐ซ๐ค๐ฌ โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ ๐ŸŽ“ ๐“๐ก๐ž ๐“๐ซ๐š๐ข๐ง๐ข๐ง๐ : ๐๐€ ๐€๐ฎ๐ญ๐จ๐“๐ž๐ฌ๐ญ ๐€๐œ๐œ๐ž๐ฅ๐ž๐ซ๐š๐ญ๐จ๐ซ Three volumes that take you from fundamentals to job-ready: - Volume 1: QA Automation & DevOps Fundamentals + Git + GitHub CI/CD - Volume 2: Python + Playwright + Framework Building + CI/CD Integration - Volume 3: Job Search, Resume & LinkedIn Strategies, Interview Prep (Behavioral + Technical + Coding) This isn't a crash course. It's a career transformation program designed around what companies actually hire for. โœ… ๐“๐ก๐ž ๐๐ซ๐จ๐จ๐Ÿ: ๐•๐ž๐ซ๐ข๐Ÿ๐ข๐ž๐ ๐‚๐ž๐ซ๐ญ๐ข๐Ÿ๐ข๐œ๐š๐ญ๐ž ๐จ๐Ÿ ๐‚๐จ๐ฆ๐ฉ๐ฅ๐ž๐ญ๐ข๐จ๐ง
๐Ÿ“Œ QA Automation Accelerator Memberships: Everything You Need To Know
Why QA Engineers Should Learn DevOps
If you're an SDET or QA Automation Engineer still manually running tests or waiting for DevOps teams to set up your testing environments, you're opportunities on the table. DevOps skills have shifted from "nice to have" to essential for modern QA. So... ๐—ช๐—ต๐—ฎ๐˜ ๐—ถ๐˜€ ๐——๐—ฒ๐˜ƒ๐—ข๐—ฝ๐˜€? DevOps is a methodology that combines software development and IT operations to build and deliver software faster and more reliably. DevOps Engineers manage the infrastructure, tools, and automation that make continuous delivery possible. Their responsibilities include: โ€ข Managing servers and cloud infrastructure โ€ข Building CI/CD pipelines for automated deployments โ€ข Implementing monitoring and logging solutions โ€ข Ensuring system stability and reliability โ€ข Enabling seamless collaboration between development and operations teams ๐—ง๐—ต๐—ฒ ๐—ข๐˜ƒ๐—ฒ๐—ฟ๐—น๐—ฎ๐—ฝ: ๐—ช๐—ต๐˜† ๐—ค๐—” ๐—ฎ๐—ป๐—ฑ ๐——๐—ฒ๐˜ƒ๐—ข๐—ฝ๐˜€ ๐—š๐—ผ ๐—›๐—ฎ๐—ป๐—ฑ ๐—ถ๐—ป ๐—›๐—ฎ๐—ป๐—ฑ Test Automation and DevOps are part of the same infrastructure. Both roles require knowledge of: โœ… CI/CD Pipelines (Jenkins, GitLab CI, GitHub Actions) โœ… Containerization (Docker, Kubernetes) โœ… Cloud Platforms (AWS, Azure, GCP) โœ… Linux/Command Line Operations โœ… Version Control (Git) โœ… Databases (SQL, NoSQL) The difference is DevOps Engineers focus on production deployments. Test Automation Engineers focus on quality gates. But the technical foundation is nearly identical. ๐—ง๐—ต๐—ฒ ๐—–๐—ฎ๐—ฟ๐—ฒ๐—ฒ๐—ฟ ๐—•๐—ฒ๐—ป๐—ฒ๐—ณ๐—ถ๐˜๐˜€ Learning DevOps isn't just about technical growth. It's about career advancement and compensation. ๐Ÿ’ฐ Higher Salaries: โ–ถ DevOps skills are among the highest paid in tech. SDETs and QA Automation Engineers with DevOps expertise often get paid significantly higher salaries than those without. ๐Ÿš€ More Job Opportunities: โ–ถ Job descriptions increasingly require "SDET with DevOps experience" or "QA Engineer with CI/CD knowledge." Companies want engineers who can own the entire testing pipeline. ๐Ÿ† Greater Independence: โ–ถ Stop waiting for DevOps teams to configure environments or fix pipeline issues. Manage your own infrastructure and move faster.
5
0
Why QA Engineers Should Learn DevOps
Deployment Types for QA: Recreate Deployment
There are several strategies for delivering code to a server, commonly referred to as deployments. In this guide, Iโ€™ll focus on one of the oldest and most straightforward approaches: Recreate Deployment. You will learn how it works and, more importantly, what it means for QA engineers and Test Automation. โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ ๐–๐ก๐š๐ญ ๐ˆ๐ฌ ๐‘๐ž๐œ๐ซ๐ž๐š๐ญ๐ž ๐ƒ๐ž๐ฉ๐ฅ๐จ๐ฒ๐ฆ๐ž๐ง๐ญ? โžค The old version (lets call it V1) is taken completely offline โžค The new version (V2) is deployed and started โžค Application is completely unavailable during this switch, its called downtime โžค This type of deployment is commonly used in dev/test environments or apps that can handle brief outages โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ ๐‡๐จ๐ฐ ๐ˆ๐ญ ๐€๐Ÿ๐Ÿ๐ž๐œ๐ญ๐ฌ ๐“๐ž๐ฌ๐ญ ๐€๐ฎ๐ญ๐จ๐ฆ๐š๐ญ๐ข๐จ๐ง โœฆ Problem #1: Tests Fail During Deployment Automated tests will fail if they run during deployment because the application is down. You'll see connection errors, timeouts 502 HTTP code, or "service unavailable" messages. Solution: Schedule your test runs AFTER deployments complete. Coordinate with DevOps on deployment windows. โœฆ Problem #2: Timing Issues in CI/CD Pipelines If a CI/CD pipeline triggers tests immediately after deployment, they might start before the new version is fully ready. Solution: Add a health check or wait period in your pipeline. โžค Wait 30-60 seconds after deployment โžค Ping a health endpoint until it responds โžค Only then start your test suite ๐.๐’. ๐Ÿšฉ ๐ˆ๐Ÿ ๐ฒ๐จ๐ฎ ๐ก๐š๐ฏ๐ž๐งโ€™๐ญ ๐ฐ๐š๐ญ๐œ๐ก๐ž๐ ๐ข๐ญ ๐ฒ๐ž๐ญ, ๐ฒ๐จ๐ฎ๐ซ ๐ง๐ž๐ฑ๐ญ ๐ฌ๐ญ๐ž๐ฉ ๐ข๐ฌ ๐ญ๐ก๐ž ๐…๐‘๐„๐„ ๐Ÿ‘-๐ฉ๐š๐ซ๐ญ โ€œ๐Œ๐š๐ง๐ฎ๐š๐ฅ ๐๐€ โ†’ ๐’๐ƒ๐„๐“โ€ ๐ฐ๐จ๐ซ๐ค๐ฌ๐ก๐จ๐ฉ,ย ๐š ๐ฌ๐ก๐จ๐ซ๐ญ ๐ฆ๐ข๐ง๐ข-๐œ๐จ๐ฎ๐ซ๐ฌ๐ž ๐ญ๐ก๐š๐ญ ๐ ๐ข๐ฏ๐ž๐ฌ ๐ฒ๐จ๐ฎ ๐ญ๐ก๐ž ๐Ÿ๐ฎ๐ฅ๐ฅ ๐ซ๐จ๐š๐๐ฆ๐š๐ฉ ๐ญ๐จ ๐›๐ž๐œ๐จ๐ฆ๐ข๐ง๐  ๐š ๐ฆ๐ข๐-๐ฅ๐ž๐ฏ๐ž๐ฅ ๐’๐ƒ๐„๐“ ๐š๐ง๐ ๐ฉ๐š๐ฌ๐ฌ๐ข๐ง๐  ๐ข๐ง๐ญ๐ž๐ซ๐ฏ๐ข๐ž๐ฐ๐ฌ. Click Here to Start: https://www.skool.com/qa-automation-career-hub/classroom/078530b1
9
0
Deployment Types for QA: Recreate Deployment
2 SQL Queries Every QA Should Know (Part 2)
In Part 1, I discussed database types and why QAs need to learn how to do the READ operations. Now let's dive into the actual SQL commands you'll use daily. [`User` Table] โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ ID โ”‚ Name โ”‚ Email โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ 1 โ”‚ john โ”‚ john@test.com 2 โ”‚ mary | mary@test.com 3 โ”‚ bob โ”‚ bob@test.com โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ โ–ถ ๐๐ฎ๐ž๐ซ๐ฒ #๐Ÿ: ๐๐š๐ฌ๐ข๐œ `๐’๐„๐‹๐„๐‚๐“` - ๐‘๐ž๐š๐ ๐€๐ฅ๐ฅ ๐ƒ๐š๐ญ๐š ยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยท SELECT * FROM Users; ยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยท What it does: Returns ALL columns and ALL rows from the Users table. QA Example: After registering multiple users, you want to see all newly created accounts in the database. โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ โ–ถ ๐๐ฎ๐ž๐ซ๐ฒ #๐Ÿ: `๐’๐„๐‹๐„๐‚๐“ ๐–๐ข๐ญ๐ก ๐–๐‡๐„๐‘๐„` - ๐…๐ข๐ฅ๐ญ๐ž๐ซ๐ž๐ ๐‘๐ž๐š๐ ยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยท SELECT * FROM Users WHERE Email = 'bob@test.com'; ยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยท What it does: Returns all data in the row for the user with that specific email address: โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ ๐Ÿ‘ โ”‚ ๐›๐จ๐› โ”‚ ๐›๐จ๐›@๐ญ๐ž๐ฌ๐ญ.๐œ๐จ๐ฆ โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ QA Example: Test user registration and verify that exact account was created with correct details. โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ ๐“๐ข๐ฉ๐ฌ: โŸก Start with `๐’๐„๐‹๐„๐‚๐“ *` to see all data, then add `๐–๐‡๐„๐‘๐„` to narrow it down โŸก Always test your queries on a test database first, never production ๐.๐’. ๐Ÿšฉ ๐ˆ๐Ÿ ๐ฒ๐จ๐ฎ ๐ก๐š๐ฏ๐ž๐งโ€™๐ญ ๐ฐ๐š๐ญ๐œ๐ก๐ž๐ ๐ข๐ญ ๐ฒ๐ž๐ญ, ๐ฒ๐จ๐ฎ๐ซ ๐ง๐ž๐ฑ๐ญ ๐ฌ๐ญ๐ž๐ฉ ๐ข๐ฌ ๐ญ๐ก๐ž ๐…๐‘๐„๐„ ๐Ÿ‘-๐ฉ๐š๐ซ๐ญ โ€œ๐Œ๐š๐ง๐ฎ๐š๐ฅ ๐๐€ โ†’ ๐’๐ƒ๐„๐“โ€ ๐ฐ๐จ๐ซ๐ค๐ฌ๐ก๐จ๐ฉ,ย ๐š ๐ฌ๐ก๐จ๐ซ๐ญ ๐ฆ๐ข๐ง๐ข-๐œ๐จ๐ฎ๐ซ๐ฌ๐ž ๐ญ๐ก๐š๐ญ ๐ ๐ข๐ฏ๐ž๐ฌ ๐ฒ๐จ๐ฎ ๐ญ๐ก๐ž ๐Ÿ๐ฎ๐ฅ๐ฅ ๐ซ๐จ๐š๐๐ฆ๐š๐ฉ ๐ญ๐จ ๐›๐ž๐œ๐จ๐ฆ๐ข๐ง๐  ๐š ๐ฆ๐ข๐-๐ฅ๐ž๐ฏ๐ž๐ฅ ๐’๐ƒ๐„๐“ ๐š๐ง๐ ๐ฉ๐š๐ฌ๐ฌ๐ข๐ง๐  ๐ข๐ง๐ญ๐ž๐ซ๐ฏ๐ข๐ž๐ฐ๐ฌ.
8
0
2 SQL Queries Every QA Should Know (Part 2)
1-30 of 61
QA Automation Accelerator
skool.com/qa-automation-career-hub
Become a job-ready QA Automation Engineer/SDET in 3โ€“4 months. AI-powered prep, real SaaS project, Certificate of Completion, and live support. ๐Ÿš€
Leaderboard (30-day)
Powered by