Create 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.
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
SQL articles
61 articles · page 5 of 6 · Clear filtersInstall 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.
SQL Syntax and Comments
Learn SQL syntax rules: statements, keywords, semicolons, case sensitivity, quotes, identifiers and comments, with MySQL examples you can run.
150+ SQL & MySQL Scenario-Based Interview Questions with Answers
Prepare for SQL and MySQL interviews with scenario-based questions, query examples, joins, window functions, database testing, performance tuning, and interactive practice. Note: I've generated the ready-to-use HTML file,…
SQL REVOKE Statement
Remove privileges in MySQL with REVOKE: revoke specific privileges, all privileges, roles and the grant option, and check the result with SHOW GRANTS.
SQL GRANT Statement
Give MySQL privileges with GRANT: privilege levels (global, database, table, column), SELECT/INSERT/UPDATE grants, SHOW GRANTS, WITH GRANT OPTION, and views.
SQL DROP TABLE and DROP DATABASE
Remove tables and databases with SQL DROP: DROP TABLE, IF EXISTS, dropping tables with foreign keys, DROP DATABASE, and DROP vs TRUNCATE vs DELETE in MySQL.
SQL ALTER TABLE
Change a table's structure with SQL ALTER TABLE: add, modify, rename and drop columns, rename tables, add keys and indexes, and change big tables safely.
SQL DELETE and TRUNCATE
Remove rows with SQL DELETE: by condition, with a subquery or JOIN, foreign key errors, and DELETE vs TRUNCATE vs DROP explained with real MySQL output.
SQL UPDATE Statement
Change data with the SQL UPDATE statement: one column, several columns, calculated values, CASE, UPDATE with JOIN and safe-update habits, with MySQL output.
SQL SELECT Statement
Learn the SQL SELECT statement step by step: columns, SELECT *, calculated columns and query execution order, with sample tables and real MySQL output.
SQL INSERT INTO Statement
Add data with SQL INSERT INTO: one row, many rows, selected columns, default values, INSERT INTO SELECT and the errors you will meet, with MySQL 8.4 output.
Preparing for a QA interview?
Take free timed mock tests with answers and explanations.