Category Archives: SQL

Introduction to SQL

SQL stands for structured query language. SQL is a tool which is used to interact with database in very easier and friendly manner. It provides the functionality of retrieving, updating and deleting the database and applying security and integrity constraints also.SQL originally called ‘Sequel’ and was first developed by IBM. As the time passed, various… Read More »

Category: SQL

Database Tuning – Effective Tips for Database Performance Tuning

Database tuning is nothing but a set of activities that is required for the purpose of optimization of the overall performances by the database. During the database performance tuning, the developers need to know few important things regarding the coding. Let us now discuss about those few important tips. Image Source Statistics Of Database: The… Read More »

Category: SQL

Dynamic SQL in DBMS

Here you will learn about dynamic sql in dbms. What is Dynamic SQL? When the pattern of database access is known in advance then static SQL is very adequate to serve us. Sometimes, in many applications we may not know the pattern of database access in advance. For example, a report writer must be able to decide… Read More »

Category: SQL

Embedded SQL (Static SQL) in DBMS

The structured query language provides us 2 features: It allows us to write queries. It allows us to use it in programming languages so that database can be accessed through application programs also. Due to this duality SQL is sometimes called dual mode language. Actually all the queries can’t be expressed in SQL alone. There… Read More »

Category: SQL