Blog Category Tutorials
How to Create Custom Data Types in DbSchema
Create custom data types in DbSchema’s Logical Design to standardize columns; on deployment they convert to native DBMS types like VARCHAR.
Tutorials • 17-Sep-2025
SQL UPDATE Statement – Syntax, Examples, and Best Practices | DbSchema
Learn the SQL UPDATE statement syntax with examples: update single or multiple columns, use WHERE conditions, JOIN other tables, and avoid common mistakes.
Tutorials • 23-Aug-2025
SQL GROUP BY Explained with Examples
Learn how to use SQL GROUP BY with clear examples. Understand SUM, COUNT, AVG, and HAVING step by step. Beginner-friendly and easy to follow.
Tutorials • 21-Aug-2025
SQL Joins Explained – INNER, LEFT, RIGHT, and FULL JOIN Diagrams | DbSchema
Learn SQL JOINs with clear INNER, LEFT, RIGHT, FULL, CROSS, and SELF JOIN diagrams, examples, and FAQs. Build and test joins visually in DbSchema.
Tutorials • 08-Aug-2025
SQL Aggregate Functions – COUNT, SUM, AVG, MIN, MAX, and GROUP BY | DbSchema
Learn SQL aggregate functions with COUNT, SUM, AVG, MIN, MAX, GROUP BY, HAVING, and ROLLUP examples. Build reporting queries faster in DbSchema.
Tutorials • 07-Aug-2025
Primary Key in SQL – Definition, Examples, and Best Practices | DbSchema
A primary key uniquely identifies every row in a SQL table. Learn syntax, auto-increment, composite keys, and how primary keys compare to unique keys and foreign keys.
Tutorials • 06-Aug-2025
What Is a Foreign Key in SQL? – Referential Integrity, Rules, and Examples | DbSchema
Learn SQL foreign keys with examples: syntax, ON DELETE CASCADE, ON UPDATE rules, composite keys, and how to add or drop foreign key constraints in any database.
Tutorials • 31-Jul-2025
SQL NULL Functions Explained with Examples
In this tutorial, you are going to learn about the SQL NULL Functions.
Tutorials • 15-Oct-2023
SQL CASE Expression Explained with Examples
In this tutorial, you are going to learn about the SQL Case Expression.
Tutorials • 13-Oct-2023
SQL INSERT INTO SELECT – Copy Data Between Tables | DbSchema
Learn SQL INSERT INTO SELECT with joins, filters, duplicates, and transaction-safe copy patterns. Move data confidently and validate results in DbSchema.
Tutorials • 12-Oct-2023
SQL SELECT INTO STATEMENT Explained with Examples
In this tutorial, you are going to learn about the SQL SELECT INTO Statement.
Tutorials • 11-Oct-2023
SQL ANY AND ALL OPERATORS Explained with Examples
In this tutorial, you are going to learn about the SQL ANY and ALL Operator.
Tutorials • 10-Oct-2023
SQL EXISTS Operator Explained with Examples
In this tutorial, you are going to learn about the SQL Exists Operator.
Tutorials • 09-Oct-2023
SQL HAVING Clause – Examples, GROUP BY Filters, and WHERE Differences | DbSchema
Learn the SQL HAVING clause with COUNT, SUM, AVG, JOIN, and COUNT DISTINCT examples. Try grouped filters in DbSchema and improve report queries faster.
Tutorials • 08-Oct-2023
SQL INTERSECT Operator – Compare Common Rows Across Queries | DbSchema
Learn SQL INTERSECT with examples, INTERSECT vs INNER JOIN, support notes, and FAQs. Find common rows faster and validate results in DbSchema.
Tutorials • 10-Sep-2023
SQL GROUP BY Statement Explained with Examples
In this tutorial, you are going to learn about the SQL GROUP BY STATEMENT.
Tutorials • 10-Sep-2023
SQL UNION Operator – UNION vs UNION ALL with Examples | DbSchema
Learn SQL UNION and UNION ALL with syntax, duplicate rules, ORDER BY tips, comparisons, and FAQs. Build combined result queries faster in DbSchema.
Tutorials • 09-Sep-2023
SQL ALIASES Explained with Examples
In this tutorial, you are going to learn about the SQL ALIASES.
Tutorials • 09-Sep-2023
SQL IN Operator Explained with Examples
In this tutorial, you are going to learn about the SQL IN OPERATOR.
Tutorials • 08-Sep-2023
SQL BETWEEN Operator Explained with Examples
In this tutorial, you are going to learn about the SQL BETWEEN OPERATOR.
Tutorials • 08-Sep-2023
SQL Wildcard Characters – LIKE Patterns, ESCAPE Rules, and Examples | DbSchema
Learn SQL wildcard characters with %, _, ESCAPE, ILIKE, and NOT LIKE examples. Compare databases and test safe pattern searches in DbSchema.
Tutorials • 07-Sep-2023
SQL LIKE Operator – Wildcards, ESCAPE, ILIKE, and Examples | DbSchema
Master the SQL LIKE operator with wildcards, NOT LIKE, ESCAPE, ILIKE, examples, and performance tips. Build pattern searches visually in DbSchema.
Tutorials • 27-Aug-2023
SQL COUNT, AVG, and SUM Functions – Examples, NULLs, and GROUP BY | DbSchema
Learn SQL COUNT, AVG, and SUM functions with examples: NULL handling, COUNT(*) vs COUNT(column), GROUP BY, HAVING, DISTINCT, and conditional aggregation.
Tutorials • 26-Aug-2023
SQL MIN() MAX() Functions Explained with Examples
The SQL MIN() and MAX() functions return the smallest and largest values from a column. This guide includes syntax, use cases, and example queries.
Tutorials • 25-Aug-2023
SQL TOP, LIMIT, FETCH FIRST, and ROWNUM Clauses
In this tutorial, you are going to learn about the SQL TOP,LIMIT,FETCH FIRST and ROWNUM Clauses.
Tutorials • 25-Aug-2023
SQL DELETE Statement – Safe Syntax, Examples, and Best Practices | DbSchema
Learn SQL DELETE syntax with examples: delete rows with WHERE, JOINs, subqueries, and transactions. Covers DELETE vs TRUNCATE and safe cleanup patterns.
Tutorials • 24-Aug-2023
SQL NULL Values – IS NULL, COALESCE, NULLIF, and Common Pitfalls | DbSchema
Learn how SQL NULL values affect filters, joins, aggregates, UNIQUE rules, and NOT IN queries. Use DbSchema to inspect nullable columns and test fixes safely.
Tutorials • 22-Aug-2023
SQL INSERT INTO Statement Explained
In this tutorial, you are going to learn about SQL INSERT INTO Statement.
Tutorials • 23-Jul-2023
SQL ORDER BY – Syntax, ASC/DESC, Multiple Columns, and Pagination | DbSchema
Learn SQL ORDER BY with examples: ASC/DESC sorting, multiple columns, NULL handling, LIMIT/OFFSET pagination, CASE expressions, and performance tips.
Tutorials • 22-Jul-2023
SQL AND, OR, NOT Operators Explained with Examples
In this tutorial, you are going to learn about SQL AND,OR and NOT Operators.
Tutorials • 22-Jul-2023
SQL WHERE Clause Explained with Examples
In this tutorial, you are going to learn about the SQL WHERE Clause.
Tutorials • 21-Jul-2023
SQL SELECT DISTINCT Statement Explained
In this tutorial, you are going to learn about the SQL Select Distinct Statement.
Tutorials • 20-Jul-2023
SQL Tutorial with Examples
In this tutorial, you are going to learn about the SQL and Database.
Tutorials • 19-Jul-2023
SQL Syntax Explained with Examples
Learn SQL syntax and basic commands in this tutorial. Understand SQL fundamentals to improve your database skills and start writing queries.
Tutorials • 19-Jul-2023
SQL SELECT Statement – Syntax, Examples, and Query Order | DbSchema
Learn the SQL SELECT statement with syntax, WHERE, DISTINCT, JOINs, GROUP BY, ORDER BY, subqueries, and FAQs. Build queries visually in DbSchema.
Tutorials • 19-Jul-2023
SQL Tables Explained with Examples
In this article, you are going to learn what is table, how to create, modify, delete.
Tutorials • 11-Jul-2023