SQL Tutorial

SQL Where Clause

When we have to UPDATE, DELETE or SELECT a particular set of data we use SQL WHERE clause. The WHERE clause is an integral part of SQL as it provides the feature to add conditions….

SQL Delete Query

SQL Delete Query SQL Delete Query is used to remove rows from table in a database. In a database the storage and retrieval of data is the most important aspect. But, there are cases when….

SQL Update Statement – Update Query in SQL

SQL Update Statement or Update Query in SQL is used to modify the column data in tables. Earlier we looked into SQL Select and SQL Insert queries. SQL Update In a database the storage and….

SQL Insert Query

SQL INSERT Query also referred as SQL INSERT INTO is the command used for inserting data into database. SQL INSERT statement allows insertion of data into one table at a time. SQL Insert Query SQL….

SQL Select

SQL or Structured Query Language is all about storing, retrieving and manipulating data in the database. The most important aspect of SQL is retrieval of data from database. SQL Select statement is used to retrieve….

SQL Keywords

SQL keywords are the reserved words for SQL operations. These Keywords are used across SQL version for different functionalities. SQL Keywords SQL keywords are case insensitive. So the keyword SELECT and select will behave in….

SQL Expressions

SQL expression is a combination of one or more values, operators and SQL functions that results in to a value. These SQL EXPRESSIONs are similar to a formula and they are written in query language…..

SQL Operators

SQL Operators are a series of characters, symbols and words which are used as part of the WHERE clause. SQL Operators SQL operators are used to perform operations like comparisons and arithmetic operations. These Operators….

SQL Interview Questions and Answers

SQL interview questions are asked in almost all interviews because database operations are very common in applications. SQL stands for Structured Query Language, which is a domain-specific programming language used for database communications and relational….

SQL Data Types

SQL Data Types define the type of value that can be stored in a table column. For example, if we want a column to store only integer values, then we can define its data type….

Generic selectors
Exact matches only
Search in title
Search in content