Category: SQL

OLTP in SQL SERVER

August 20, 2016 by Arti Khedkar

Filed under Database, SQL

Last modified September 22, 2016

OLTP in SQL SERVER   Online Transaction and Processing helps and manages applications based on transactions involving high volume of data. The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second. It involves Queries accessing individual record like Update your Email in Company database. For OLTP …

SQL Joins

August 3, 2016 by Arti Khedkar

Filed under Database, SQL

Last modified October 25, 2016

SQL Joins The SQL Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each. SQL is a special-purpose programming language designed for managing information in a relational database management system (RDBMS). The word relational here is key, it specifies that the database management …

Sql Interview Questions

August 2, 2016 by Giryavva Ghodake

Filed under SQL

Last modified August 2, 2016

Sql Interview Questions What is DBMS ? What is RDBMS ? What is SQL ? What are the different type of SQL’s statements ? What are the Advantages of SQL ? what is a field in a database ? What is a Record in a database ? What is a Table in a database ? What is a database transaction? What are properties of a …

Introduction to SQL

July 27, 2016 by Arti Khedkar

Filed under Database, SQL

Last modified July 27, 2016

  Introduction to SQL Sql is database language which is used by most of the companies for storing the data in it. SQL stands for Structured Query Language. SQL is the standard language for Relation Database System. All relational database management systems like MySQL, MS Access, Oracle, Sybase, Informix, postgres and SQL Server use SQL as standard database language. The first incarnation of SQL appeared …