SQL Window Functions
SQL Tutorial › Window Functions › Window Functions SQL Window Functions AdvancedLesson 45 of 6914 min read9 queries
Online Learning Platform
Free QA & test automation learning
Learn by doing: 1,200+ practice programs, step-by-step automation tutorials, MCQ quizzes and interview questions — all free, from absolute basics to framework level.
# Python practice: reverse a string text = "SQA Tools" reversed_text = text[::-1] print(reversed_text)
Learn Playwright step by step in one structured course: from installation and your first test to locators, API testing, framework design, CI/CD with GitHub Actions and Jenkins, and AI test agents. Every lesson includes runnable TypeScript code and an assignment.
Plus real-world projects, practice assignments and interview preparation.
Take timed 20-question MCQ tests on every Playwright with TypeScript topic. See your score, the correct answers and explanations as soon as you submit, and track your interview readiness across a 20-exam target.
Prefer Python? Learn Playwright with Python and pytest step by step: installation, Python essentials, pytest, locators, assertions, fixtures and more. Every code example is run before it is published, and each module ends with a 200-question mock interview.
Coming next: test data, network and API testing, framework design, CI/CD, async and AI.
Learn SQL step by step, from your first SELECT to joins, window functions, CTEs, transactions and query tuning. Every query shows the sample table, the real MySQL 8.4 result and a step-by-step explanation, and most run right in your browser.
Learning paths
Structured tracks that take you from first line of code to real-world test automation.
Practice Python from basics to Pandas with 14 topic sets of solved programs and exercises.
Locators, waits, actions, frames and frameworks for reliable browser automation.
Free step-by-step course: 15 modules and 91 lessons, from your first test to frameworks, API testing, CI/CD and AI agents.
Free SQL tutorial with MySQL: 69 lessons, real query output, Try-it in the browser and 5 hands-on projects.
Check your understanding with chapter-wise Python and Playwright multiple-choice quizzes.
Real QA, SDET and automation lead interview questions with clear sample answers.
Master version control step by step: from your first commit to branching, merging and rebasing, pull requests and code review, advanced Git, repository security and CI/CD with GitHub Actions. Every lesson has commands you can run and a practice assignment.
Plus a Git cheat sheet, practice assignments and two real-world projects.
Python practice programs
Every set has solved programs with code and output — pick a topic and start coding.
Hands-on practice
Safe demo websites built for testers — write Selenium or Playwright scripts against real forms, tables and flows.
Inputs, dropdowns, checkboxes, alerts, tables and frames on one page.
A ticket-booking flow to automate end-to-end user journeys.
Practise login, validation and session scenarios.
Realistic challenges for locators, dialogs, uploads and more.
Fresh content
SQL Tutorial › Window Functions › Window Functions SQL Window Functions AdvancedLesson 45 of 6914 min read9 queries
SQL Tutorial › Security › Users & Roles MySQL Users and Roles IntermediateLesson 66 of 6910 min read4
SQL Tutorial › Joins & Set Operators › UNION & UNION ALL SQL UNION and UNION ALL IntermediateLesson
SQL Tutorial › Window Functions › Top N per Group SQL Top N per Group AdvancedLesson 49 of
SQL Tutorial › Subqueries & CTEs › Subqueries SQL Subqueries IntermediateLesson 40 of 6912 min read8 queries run
SQL Tutorial › Window Functions › Running Totals & Moving Averages SQL Running Totals and Moving Averages AdvancedLesson
Why SQA Tools
FAQ
Yes. All tutorials, practice programs, quizzes and practice websites on SQA Tools are free to use, with no sign-up required.
Students, freshers, manual testers moving into automation, and engineers preparing for QA or SDET interviews.
No. Start with the Python basic programs, then move on to Selenium or Playwright once you are comfortable with the fundamentals.
Python with Selenium is a good way to build strong automation fundamentals. Playwright with TypeScript is a great next step for modern web testing — SQA Tools covers both.
Use the SQA Tools practice websites: the Automation Practice Page, Dummy Booking Website, Login Page and Playwright Practice challenges.
Pick a learning path, practise on real pages and track your progress with quizzes — all free.