Between Operator in SQL
Between Operator in SQL is used to filter out the output within a specified range specified in the WHERE condition. It can be used with SELECT, INSERT,UPDATE or DELETE SQL statements. Syntax : SELECT...
Author: Shikha Katariya
Pattern Matching in SQL – Using Wildcards
In the previous post we have studied about the ‘WHERE’ clause (used to filter out the output ) and the ‘EQUALITY’ operator ( used along with the WHERE clause to specify the filter condition)....
Where Clause
Where Clause….is used to filter results from SQL statements like Insert,Update,Select,Delete that meet the filter criteria. Syntax : SELECT * FROM <Tablename> WHERE <Column> = <Value>; Sample Database ILLUSTRATION OF WHERE CLAUSE USING...
Character Functions()
Sample Database : There are following Character Functions(). 1. INITCAP() It converts the Initial letter of every word into Upper Case and rest in Lower case. This changes are only temporary and done only in...
System Defined Functions in SQL
Functions can basically be divided into two types : User Defined System Defined. System Defined Functions in SQL: In this Post we will discuss about the System Defined or Inbuilt functions provided by SQL...
Data Types
What is a Data Type?? A data type is something that assigns some predefined characteristics to the values and tells the SQL engine , what type of value it is and helps to differentiate...
Data Dictionary
What is Data dictionary ? Data Dictionary is basically a repository which contains data about the database such as information about tables , column names,their length , datatypes, attributes and other database structures etc....
Internal Working of Query Execution
When we execute an SQL statement e.g. SELECT * FROM EMP , Lets see what happens behind the scene i.e Internal working of query execution.In other words , Life cycle of an SQL statement...
Most Important …Live Project Scenarios
As we have understanding of all the modules required for ETL testing i.e. Data Warehouse , UNIX , SQL , ETL Concepts , Now its time to integrate the knowledge gained so far and...