When we say databases, the first thing that comes into mind is data. It means it is something that deals with the data. So, basically what is a database? Database is a collection of tables, stored procedures, functions, triggers, indexes and jobs. So this definition uses a lot of new words that you may not be knowing. Nothing to worry about. We will come to know about all these terms in my next coming posts. To work on databases, we need an environment that could be either SQL Server environment, oracle, DB2 or any other environment. We are going to focus on SQL Server 2008 R2. The installation of the environment can be found here. When we install the environment, some folders get generated automatically. The folders are listed here: 80 folder - For SQL Server 2000 90 folder - For SQL Server 2005 100 folder - For SQL Server 2008 MSAS_10_50 - Analysis Services MSRS_10_50 - Reporting Services MSSQL_10_50.MSSQLSERVER - ...