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 COUNT, AVG, and SUM with GROUP BY: Syntax and Examples | DbSchema
Learn SQL COUNT, AVG, and SUM with syntax and examples, including NULL handling, COUNT(*) vs COUNT(column), GROUP BY, HAVING, DISTINCT, and conditional aggregation.
Tutorials • 26-Aug-2025
SQL MIN() and MAX() Functions Explained with Examples | DbSchema
Learn SQL MIN() and MAX() with practical examples, GROUP BY usage, subqueries, HAVING filters, and common mistakes.
Tutorials • 25-Aug-2025
SQL UPDATE Statement: Syntax, Examples, and Safe Patterns (2026) | DbSchema
Learn SQL UPDATE syntax with practical examples, WHERE safety checks, JOIN-based updates, and transaction-safe patterns for MySQL, PostgreSQL, and SQL Server.
Tutorials • 23-Aug-2025
SQL GROUP BY Explained with Examples | DbSchema
Learn SQL GROUP BY with clear examples for COUNT, SUM, AVG, HAVING, and JOIN-based reporting queries.
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
What Is a Primary Key in SQL? Definition and Examples (2026) | DbSchema
Learn what a primary key in SQL is, with syntax and examples for MySQL, PostgreSQL, and SQL Server, plus composite keys and primary key vs unique vs foreign key.
Tutorials • 06-Aug-2025
What Is a Foreign Key in SQL? Syntax, Rules, and Examples (2026) | DbSchema
Learn SQL foreign key syntax with examples, ON DELETE and ON UPDATE actions, composite keys, and how to add or drop constraints in MySQL, PostgreSQL, and SQL Server.
Tutorials • 31-Jul-2025
SQL NULL Functions Explained with Examples | DbSchema
Learn SQL NULL-handling functions like IFNULL, ISNULL, COALESCE, and NVL, with examples, pitfalls, and practice exercises.
Tutorials • 15-Oct-2023
SQL CASE Expression Explained with Practical Examples | DbSchema
Learn SQL CASE expressions with examples for SELECT, ORDER BY, GROUP BY, updates, conditional aggregates, and common mistakes.
Tutorials • 13-Oct-2023
SQL INSERT INTO SELECT: Syntax, Examples, and Safe Data Copy | DbSchema
Learn SQL INSERT INTO SELECT with JOINs, filters, duplicate prevention, and transaction-safe data copy patterns for MySQL, PostgreSQL, and SQL Server.
Tutorials • 12-Oct-2023
SQL SELECT INTO Statement Explained with Examples | DbSchema
Learn SQL SELECT INTO syntax, examples, table-copy patterns, common mistakes, and safe practices for creating new tables from query results.
Tutorials • 11-Oct-2023
SQL ANY and ALL Operators Explained with Examples | DbSchema
Understand SQL ANY and ALL with clear examples, subquery patterns, operator differences, common mistakes, and practice questions.
Tutorials • 10-Oct-2023
SQL EXISTS Operator Explained with Practical Examples | DbSchema
Learn how SQL EXISTS and NOT EXISTS work with subqueries, real examples, common mistakes, and practical query patterns.
Tutorials • 09-Oct-2023
SQL HAVING Clause: GROUP BY Filters, Examples, and HAVING vs WHERE | DbSchema
Learn SQL HAVING with GROUP BY using COUNT, SUM, AVG, JOIN, and COUNT DISTINCT examples. Understand HAVING vs WHERE and write safer reporting queries.
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 | DbSchema
Learn SQL GROUP BY with single and multi-column examples, HAVING, JOINs, aggregations, and common mistakes.
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 | DbSchema
Learn SQL aliases for columns and tables, with practical examples for joins, subqueries, aggregate functions, and self-joins.
Tutorials • 09-Sep-2023
SQL IN Operator Explained with Practical Examples | DbSchema
Learn how SQL IN and NOT IN work with practical examples, subqueries, common mistakes, and safe filtering patterns.
Tutorials • 08-Sep-2023
SQL BETWEEN Operator Explained with Range Examples | DbSchema
Learn SQL BETWEEN and NOT BETWEEN with numeric, date, text, and time examples, plus common mistakes and best practices.
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 TOP, LIMIT, FETCH FIRST, and ROWNUM Explained | DbSchema
Learn SQL TOP, LIMIT, FETCH FIRST, and ROWNUM with practical examples and database-specific syntax differences.
Tutorials • 25-Aug-2023
SQL DELETE Statement Explained with Examples (2026) | DbSchema
Learn SQL DELETE syntax with WHERE, JOIN, and subquery examples plus transaction-safe cleanup patterns. Includes DELETE vs TRUNCATE vs DROP and production safety tips.
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 with Examples | DbSchema
Learn SQL INSERT INTO syntax with single-row, multi-row, default values, and INSERT...SELECT examples, plus common mistakes.
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 | DbSchema
Learn SQL AND, OR, and NOT operators with examples, combined conditions, common mistakes, and practical filtering patterns.
Tutorials • 22-Jul-2023
SQL WHERE Clause Explained with Operators and Examples | DbSchema
Learn how to use the SQL WHERE clause with comparison, range, pattern, and list operators, plus common mistakes and FAQs.
Tutorials • 21-Jul-2023
SQL SELECT DISTINCT Statement Explained with Examples | DbSchema
Learn SQL SELECT DISTINCT with single and multi-column examples, NULL behavior, DISTINCT vs GROUP BY, and common mistakes.
Tutorials • 20-Jul-2023
SQL Tutorial for Beginners with Real Examples | DbSchema
Learn SQL basics and database fundamentals with real-world examples, core concepts, and practical next steps.
Tutorials • 19-Jul-2023
SQL Syntax Explained with Core Commands and Examples | DbSchema
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: CREATE, ALTER, DROP, and Examples | DbSchema
Learn SQL tables with practical examples: what a table is, how to CREATE, ALTER, and DROP tables, and how primary keys and constraints work.
Tutorials • 11-Jul-2023