Category Archives: SQL

What is DBMS? Types, Applications, Advantages & Disadvantages

Database Management System DBMS

Find out what is DBMS (Database Management System) and its different types along with the various advantages and disadvantages of this system. Important terms and definition Database By definition, a database is an organized collection of various related data, which is generally stored or accessed electronically from a server or any computer system. Usually, these […]

SQL Cheat Sheet (Download in PDF or Image Format)

SQL Cheat Sheet

This article features a fantastic SQL Cheat Sheet with the most commonly used SQL Commands. View it or download in the PDF or Image (JPG or PNG) format. Our SQL Cheat Sheet enables you to revise almost the entire set of SQL Commands quickly. It is highly recommended to go through this cheat sheet if […]

SQL Trigger – Tutorial with Examples

SQL Trigger Tutorial

This is a detailed Tutorial of SQL Trigger. Learn with the help of examples to create triggers that are auto-invoked according to specific database events. SQL Trigger SQL Trigger is basically a Procedure that is stored in the database and is used when a specific event occurs. Let’s say you want to perform an action […]

SQL LENGTH Function Tutorial

SQL LENGTH FUNCTION

This is a detailed tutorial of the LENGTH Function in SQL. Learn to find the number of characters of the column values using the LENGTH function. SQL LENGTH Function The LENGTH Function in SQL is used to find out the number of characters of a given string. This way, you can easily find out the […]

SQL Query To Find Duplicate Records

SQL Query To Find Duplicate Records

This is a detailed tutorial of querying duplicate records in a database table. Learn the SQL Query to find out completely or partially duplicate rows. Duplicate Table Records There might be cases when you require to find out the duplicate records of a database table. The duplicate records refer to the table rows who are […]

SQL Command Types – DDL, DQL, DML, DCL & TCL

SQL Command Types

SQL Commands are categorized into DDL, DQL, DML, DCL & TCL. Learn the commands included in each of these categories with their purpose and explanation. SQL Command Types Structured Query Language (SQL) is used to create a database(s) and perform different operations on it. There is a huge list of operations that can be performed […]