Creating and working with Views in a Database

  Introduction Views are generally used to focus, simplify, and customize each user’s perception of the database. You can use a view as a security mechanism by allowing a user to access data through the view without granting the user… Continue Reading


Joins in SQL Server 2005

  In this article, we are going to discuss SQL Server Joins. A join is used to combine columns from two or more tables into a single result set. To join data from two tables you write the names of… Continue Reading


Create, Delete, and Update Triggers in a Database

  Triggers Triggers are a special type of procedure that are fired automatically when an query is executed on a table or a view. Triggers provide a powerful way of control how action queries modify the data in your database.… Continue Reading

Physical data organization and indexing

  Introduction This article is intended to explain the main storage structures used in database systems through examples in Microsoft SQL Server and Oracle Database. Choosing the right structure is an important strategy for database developers and architects in order… Continue Reading