Free Training and Career help

In this tutorial you will learn about Database Creation in SQL Server 2005, The process of Database design and administration, Understanding Database Design concepts, Creating the Personnel Database, Table Designer, Keys, Indexes, Triggers, Constraints, Query and View Designer, View Designer and Query Designer.

Databases are defined to meet business needs of the organization. Optimal performance of the database will depend on the DBA’s understanding of the components that enable optimization of database performance.

An SQL Server database is made up of a collection of tables which contain the data and other objects such as views, triggers, indexes, stored procedures, user defined functions etc which support the activities performed by the business entity.

A Client /Server database system has an interface for client based users to access data and a database structure that is maintained in the server for storing and managing data.

The process of Database design and administration involves the following:

Understanding of the database concepts, descriptions, files, filegroups and log files available in SQL Server 2005
Designing Databases including the understanding of the rules, restrictions and guidelines for database design.
Implementing Databases involves an awareness of the rules, restrictions imposed when creating, modifying or deleting the databases.
Maintaining databases
Optimizing databases to maximize performance
Database snapshot concepts and guidelines for creating and administering database snapshots.

Read More...

http://www.exforsys.com/content/view/1854/356/