Category Archives: RDBMS

CREATE TABLE in Teradata with examples

There are different ways to create tables in Teradata. We can also define the tables in such a way that it will allow or not allow the duplicates. We can also create tables with data from another table on the fly. Create table – Default We can create a table in Teradata with the default… Read More »

Difference between ISNULL and COALESCE in SQL

In this article, we will see the difference between ISNULL and COALESCE in SQL Server. Both ISNULL and COALESCE evaluates the expression for NULL and returns a non-null value. ISNULL The ISNULL function replaces NULL with a specified value. ISNULL ( check_expression, replacement_value ) It contains two parameters. The first parameter is to evaluate the… Read More »

MySQL Installation steps

In this article, we will see how to install MySql in the Ubuntu machine. MySql can be installed in linux based machines through the terminal window Execute the command “sudo apt-get install mysql-server mysql-client” from the terminal. The below-given picture is for reference. You will be asked to enter the machine password here. Give the… Read More »

ALTER TABLE usages in MS SQL Server

In SQL server, ALTER TABLE statement is used for the following purposes  ADD columns/ constraints in the existing table.  DROP columns/ constraints in the existing table.  ALTER columns in the existing table.  ENABLE/ DISABLE triggers. ADD columns/constraints Syntax to add columns and constraints while creating column Syntax to add column(s) One or more columns can… Read More »