Aggregate functions
Write a Python program to get the count, average, minimum and maximum marks. Step-by-step explanation, colour-coded code and real output.
SQA Tools Blog
Learn testing and automation, one article at a time
Free tutorials, solved practice problems and interview prep for QA and automation engineers: Python, Playwright, Selenium, SQL, Git and more.
1,677Articles
1,141Solved Python problems
7Topics
100%Free
Python articles
298 articles · page 2 of 25 · Clear filtersRows as dictionaries
Write a Python program to read rows by column name. Step-by-step explanation, colour-coded code and real output.
fetchone, fetchmany, fetchall
Write a Python program that shows the three fetch methods. Step-by-step explanation, colour-coded code and real output.
Delete rows
Write a Python program to delete students with marks below 70. Step-by-step explanation, colour-coded code and real output.
Update rows
Write a Python program to add 5 bonus marks to students below 80. Step-by-step explanation, colour-coded code and real output.
Select with a condition
Write a Python program to select students who scored above 80. Step-by-step explanation, colour-coded code and real output.
Insert many rows
Write a Python program to insert several rows at once. Step-by-step explanation, colour-coded code and real output.
Insert a row with parameters
Write a Python program to insert a row safely with `?` placeholders. Step-by-step explanation, colour-coded code and real output.
Create a table
Write a Python program to create a SQLite table and list the tables in the database. Step-by-step explanation, colour-coded code and real output.
Python RegEx Programs with Solutions
20 Python regex programs with solutions: validate email, phone and password, extract numbers, dates and URLs, and clean text with re.sub.
Multiline and ignore-case flags
Write a Python program to find lines that start with "error" in any case. Step-by-step explanation, colour-coded code and real output.
Match positions with finditer
Write a Python program to print each match of a word with its start and end positions. Step-by-step explanation, colour-coded code and real output.
Preparing for a QA interview?
Take free timed mock tests with answers and explanations.