SQL – Select Statement

Select statement is a DML (Data Manipulation Language) statement.The SELECT statement is an SQL statement that specifies which rows and columns to fetch from one or more tables or views. The SELECT statement is very helpful in finding filtered records from a database.

Continue reading

SQL Join

A SQL Join clause is used to combine rows from two or more tables, views, or materialized views based on a common field between them. A SQL join condition is used in the where clause of select, update, delete statements.

Continue reading

Pentaho Data Integration(PDI)

Pentaho Data Integration(PDI) is the most powerful open source ETL tool available in market. It is one of the important tools available in Pentaho BI Suite. Also known as ‘KETTLE’, Pentaho Data Integration(PDI) is powerful extract, transform, and load (ETL) solution that uses an innovative metadata-driven approach.It is classified as an ETL…

Continue reading

SQL – Alter Table

SQL – Alter Table is DDL (Data definition language) statement.The ALTER TABLE command is used to modify the definition (structure) of a table by modifying the definition of its columns.It is used to add, delete or modify columns in an existing table.

Continue reading