Ms Sql Detailed

Only available on StudyMode
  • Download(s) : 22
  • Published : August 23, 2012
Open Document
Text Preview
SEQUEL SERVER 2000
_________________________________________________________________________ ➢ Microsoft SQL Server is a client/server database engine. ➢ Microsoft SQL Server is a client/server – based relational database management system.

Advantages of Client-Server computing model:
✓ Cost Savings
✓ Effective use of resources
✓ Improved Productivity
✓ Data Sharing (sharing of data is possible even though the user is unaware of the actual location of the data) ✓ Attractive User Interface
✓ Increased availability of data
✓ Migration towards an open system

Disadvantages of Client-Server computing model:
✓ Maintenance Cost
✓ Implementing a client/server application is also not easy since diff hardware platforms speak to each other over a network.

• What is DBMS (Data base Management System):
It is software; it is used to store data in the form of tables. It’s not for programming. Actually data is stored in column wise and row wise. In this data base we can add data, remove data, and modify existing data easily and more efficiently. To communicate with database we require a language i.e. SQL. Retrieving data and Sharing data is very easy by maintain database in computer.

• SQL: It is a language. It is used to communicate with any database (oracle, Sybase, sql server…) (or) • Structured Query Language (SQL)
To work with data in a database, you must use a set of commands and statements (language) defined by the DBMS software. There are several different languages that can be used with relational databases; the most common is SQL. Both the American National Standards Institute (ANSI) and the International Standards Organization (ISO) have defined standards for SQL.

• Databases:
A database in Microsoft SQL Server consists of a collection of tables that contain data, and other objects, such as views, indexes, stored procedures, and triggers, defined to support activities performed with the data. SQL Server can support many databases, and each database can store either interrelated data or data unrelated to that in the other databases. For example, a server can have one database that stores personnel data and another that stores product-related data. Alternatively, one database can store current customer order data, and another; related database can store historical customer orders that are used for yearly reporting. Before you create a database, it is important to understand the parts of a database and how to design these parts to ensure that the database performs well after it is implemented.

Questions:
1. What is the building block of a relational database?
The Table
2. What are some of the objects held in a database?
Tables, columns, data types, stored procedures, trigger, rules, keys, constraints, default, and indexes. 3. How do I perform a client-tools-only installation?
Perform a custom setup and then uncheck the server components. 4. Which file system is recommended for SQL Server when running on Win NT? The NTFS file system – it has better security and reliability.

• SQL Server Features:
Microsoft SQL Server supports a set of features that result in the following benefits: Ease of installation, deployment, and use
SQL Server includes a set of administrative and development tools that improve your ability to install, deploy, manage, and use SQL Server across several sites. Scalability
The same database engine can be used across platforms ranging from laptop computers running Microsoft Windows® 95/98 to large, multiprocessor servers running Microsoft Windows NT®, Enterprise Edition. Data warehousing

SQL Server includes tools for extracting and analyzing summary data for online...
tracking img