Add a Column to the Table in SQL
Tutorial on how to add a new column to an existing table starting with its basics, syntax, practical demonstration, adding a column with constraints, and more.
Compare Two Tables in SQL
Tutorial on all the various methods and techniques that we can employ to compare two database tables in SQL using except, union, and inner join operators.
Combine Two Columns in SQL
Tutorial on the methods and techniques of combining two or more columns into a single entity in an SQL database to create new columns within the database.
SQL Having Clause
Tutorial on how to use the HAVING clause in conjunction with the SQL COUNT() aggregate function to filter out the results that match a specific condition.
SQL Subtract
Practical guide on how to use the SQL Subtract feature and how it can help us when working with relational databases using the NOT IN operator using examples.
SQL Select All Except
Practical tutorial on all the methods to select all rows and columns from a given database table except the specific ones by utilizing various SQL techniques.
SQL Outer Join
Practical guide on understanding OUTER JOINS, what an OUTER JOIN is in SQL, the types of OUTER JOINS, and the examples of how to use these types of OUTER JOINS.
Case Insensitive SQL LIKE Operator
Practical guide on how to use the LIKE operator in Standard SQL you to check if a value is in a given set of values and perform a case insensitive comparison.
SQL Lead Function
Comprehensive tutorial on how to work with the lead() function to access the next item/row from the current row at a specific offset along with examples.
SQL Having Count Clause
Comprehensive tutorial on how to use the SQL HAVING clause in conjunction with the COUNT() function to filter out the results that match a specific condition.
Get the Month from a Given Date in SQL
Practical guide on all the methods and techniques that you can use to extract the month and other date parts from a given date value in various SQL databases.
Delete a Row in SQL
Guide on the methods and techniques that we can use to delete a row or multiple rows from a given database table using the DELETE statement and an SQL subquery.
SQL COUNT WHERE
Practical tutorial on the various usages and examples on how to work with the SQL count() function to count the number of rows in a given table or result set.
Add Days to Date in SQL
Guide on the methods and techniques that you can use to add days to a given date using various SQL databases such as MySQL, PostgreSQL, SQL Server, and Oracle.
SQL StartsWith() Operator
Guide on how we can use the MySQL LIKE operator to perform the character matching including the use of “%” wildcard to search for patterns along with examples.
Select the Top 10 Rows in SQL
Practical tutorial on how we can use and work with the LIMIT clause in SQL databases to specify the number of rows that we wish to retrieve from the database.
SQL “Is Not Null” Operator
Tutorial on how we can use the IS NOT NULL operator to filter out the results that contain NULL values in a result set or database table along with examples.
SQL String Formatting
Practical guide on the various methods that we can use to perform the string formatting across SQL databases using the string concatenation, padding, and more.
Add Months in SQL
Tutorial on the various methods and techniques that we can use for adding months to a given date in SQL databases when dealing with date related calculations.