Install MySQL 8.4 and Run Your First Query
Install MySQL 8.4 LTS on Windows, macOS, Linux or Docker, connect with the mysql client or Workbench, and load the sample database used in this SQL tutorial.
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
Latest articles
1,677 articles · page 16 of 140Create Database and Create Table in SQL
Learn CREATE DATABASE, USE, CREATE TABLE, DESCRIBE, IF NOT EXISTS and CREATE TABLE AS SELECT in MySQL, step by step with real output.
Python SQLite Programs with Solutions
20 Python sqlite3 programs with solutions: create tables, insert, select, update, delete, joins, group by, transactions and CSV export, each explained.
Query into pandas
Write a Python program to load a query result into a pandas DataFrame. Step-by-step explanation, colour-coded code and real output.
Why parameters prevent SQL injection
Write a Python program that shows how an f-string query is unsafe and a parameter is safe. Step-by-step explanation, colour-coded code and real output.
Export a table to CSV
Write a Python program to export a table to a CSV file. Step-by-step explanation, colour-coded code and real output.
Top N rows
Write a Python program to get the top 3 scores. Step-by-step explanation, colour-coded code and real output.
Search with LIKE
Write a Python program to find products whose name contains a word. Step-by-step explanation, colour-coded code and real output.
Column names of a query
Write a Python program to print the column names of a query result. Step-by-step explanation, colour-coded code and real output.
Use a database file
Write a Python program that saves data to a .db file and reads it back with a new connection. Step-by-step explanation, colour-coded code and real output.
Transaction with rollback
Write a Python program that transfers money between accounts and rolls back on error. Step-by-step explanation, colour-coded code and real output.
Customers without orders
Write a Python program to find customers who have not placed any order. Step-by-step explanation, colour-coded code and real output.
Preparing for a QA interview?
Take free timed mock tests with answers and explanations.