Change the Table Name in SQL
Comprehensive tutorial on the process of using the ALTER TABLE statement and RENAME TO clause to rename an existing table to a new table along with examples.
Cast Various Types into an Int Data Type in SQL
Tutorial on the methods and techniques we can use to convert or cast various types into an int data type in SQL using the cast() function along with examples.
Cast Various Types into Decimal Types in SQL
Practical tutorial on the cast() function in SQL and how we can use it to convert various types into decimal types using the function syntax and example usage.
SQL Absolute Value
Guide on the various methods that we can use to calculate the absolute value in SQL using MySQL as our database engine of choice and the Sakila sample database.
SQL Backup Table
Practical tutorial on the various methods and techniques that we can use to backup the individual tables in SQL to preserve the state of the data in that table.
SQL Where Clause on Multiple Conditions
How to use the WHERE clause to specify multiple conditions in SQL with AND, OR, IN, and NOT operators and how to combine them to create more complex conditions.
Sum of Values for Multiple Columns in SQL
Practical tutorial on how we can use the sum() function in SQL to calculate the sum of values for multiple columns in a single statement along with examples.
Extract a Substring After a Character in SQL
Practical tutorial on how to extract a substring after a specific character using the SQL methods and techniques like substring() and charindex() functions.
SQL Subquery Join with Outer Query
Practical tutorial on the fundamentals of working with subqueries and subquery joins in SQL, how to work with subquery joins, and why you may need to use them.
SQL Join on Multiple Conditions
Guide on how to perform the SQL joins on multiple conditions and how to use the “AND” and “OR” logical operators to join the data based on multiple conditions.
The Third Normal Form
A guide on using the Third Normal Form ensures that the tables in the First Normal Form and the Second Normal Form do not violate the fundamental rules.
SQL Delete Column from Table
This short article discusses how to delete and modify a column from an existing database table schema using Standard SQL commands and MySQL variants.
ORDER BY in SQL
The ORDER BY clause in SQL allows you to sort the result of a query based on a given condition in ascending or descending order.
SQL IN Operator
The IN operator allows you to check for an equal value in a given set of values. This article explains how to use the IN operator in Standard or ANSI SQL.
SQL LIKE Operator
This article explains how to use the LIKE operator in Standard SQL, which allows you to check if a value is in a given set of values.
SQL Min and Max Functions
The min() function is an aggregate function and returns a single numeric value from a given input. The max() function gets the largest number in a given set.
SQL Cast Function
This article explains the basics of working with the cast() function in Standard SQL to convert a given expression to another data type.
Referential Integrity
Referential integrity is a database concept ensuring relationships between tables remain consistent. This article explains the Referential Integrity concept.
SQL Foreign Key
A foreign key is one or more columns in a child table that refers to a primary key of a parent table. The link between both tables is the foreign key.