Learn SQL and Database by Examples

SQLiz.com provides database-related articles, tutorials to help you learn SQL and Databases. You can find MySQL, PostgreSQL, Oracle, SQL Server, SQLite, Mongo, Redis tutorials here.

All tutorials on the site come with practical examples. Hope to help you learn SQL and databases faster.

MySQL Tutorial PostgreSQL Tutorial MySQL Reference PostgreSQL Reference SQLite Function Reference MariaDB Reference MongoDB Reference Oracle Reference SQL Server Reference Sakila Tutorial

MySQL INSERT INTO SELECT: Copy Query Results

Use MySQL INSERT INTO SELECT to copy query results into an existing table, with examples for column matching, filtering, and duplicate keys.

MySQL INSERT IGNORE: Skip Duplicates and Read Warnings

Learn how MySQL INSERT IGNORE handles duplicate keys and invalid values, how to inspect warnings, and when to use an upsert instead.

MySQL INSERT Multiple Rows: Syntax and Examples

Insert multiple rows with one MySQL INSERT statement. Learn VALUES syntax, column matching, and packet-size limits for larger batches.

MySQL HAVING Clause: Filter Groups with Examples

Learn how MySQL HAVING filters grouped results, how it differs from WHERE, and how to filter groups with COUNT() and SUM().

MySQL Recursive CTE with Examples

Learn MySQL recursive CTE syntax with number sequences and hierarchy traversal, including stop conditions and recursion limits.

MySQL CTE: Common Table Expressions with WITH

Learn MySQL CTE syntax with WITH, reuse named query results, chain CTEs, and understand their scope and common rules.

A Complete Guide to the MySQL CHAR() Function

A comprehensive guide to the MySQL CHAR() function, including syntax, examples, and use cases.

A Complete Guide to the MySQL CHAR_LENGTH() Function

A comprehensive guide to the MySQL CHAR_LENGTH() function, including syntax, examples, and use cases.

A Complete Guide to the MySQL CEILING() Function

A comprehensive guide to the MySQL CEILING() function, including syntax, examples, and use cases.

A Complete Guide to the MySQL CEIL() Function

A comprehensive guide to the MySQL CEIL() function, including syntax, examples, and use cases.

How the count() function works in SQLite?

The SQLite count() function is used to count rows in a table or the number of non-NULL values in a specific column.

How the cosh() function works in SQLite?

The SQLite cosh() function is a powerful tool for performing hyperbolic cosine calculations, useful in various mathematical and engineering applications.

How the cos() function works in SQLite?

SQLite’s cos() function enables trigonometric calculations directly within SQL queries.

How the concat() function works in SQLite?

SQLite’s concat() function is a powerful tool for string manipulation and formatting.

How the concat_ws() function works in SQLite?

SQLite’s concat_ws() function simplifies string concatenation by handling NULL values and separators seamlessly.

How the coalesce() function works in SQLite?

SQLite’s coalesce() function is a powerful tool for handling NULL values in queries.

How the char() function works in SQLite?

SQLite’s char() function is a powerful tool for constructing strings from ASCII values.

How the changes() function works in SQLite?

SQLite’s changes() function is a powerful tool for tracking the impact of data modifications.

How the ceiling() function works in SQLite?

SQLite’s ceiling() function is your reliable partner for conservative number rounding.

How the ceil() function works in SQLite?

The SQLite ceil() function returns the smallest integer value that is greater than or equal to the given numeric expression.

How the avg() function works in SQLite?

SQLite’s avg() function is your go-to solution when you need to find the central tendency of numerical data.

How the atanh() function works in SQLite?

SQLite’s atanh() function is a powerful tool for data transformation, particularly for values between -1 and 1.

How the atan2() function works in SQLite?

The SQLite atan2() function calculates the arctangent of the quotient of its arguments, returning the angle in radians whose tangent is the specified value.

How the atan() function works in SQLite?

The SQLite atan() function calculates the arctangent of a number, returning the angle in radians whose tangent is the specified value.

How the asinh() function works in SQLite?

The SQLite asinh() function calculates the inverse hyperbolic sine of a number, returning the value whose hyperbolic sine is the specified number.

How the asin() function works in SQLite?

The SQLite asin() function calculates the arc sine of a number, returning the angle in radians whose sine is the specified value.

How the acosh() function works in SQLite?

The SQLite acosh() function calculates the inverse hyperbolic cosine of a number, returning the angle in radians whose hyperbolic cosine is the specified value.

How the acos() function works in SQLite?

The SQLite acos() function is used to calculate the arc cosine of a number, returning the angle in radians whose cosine is the specified value.

How the abs() function works in SQLite?

The SQLite abs() function is used to return the absolute value of a number, stripping away its sign.

A Complete Guide to the MySQL CAST() Function

MySQL’s CAST() function is a versatile tool for converting data types, enabling flexible data manipulation and compatibility in queries.