Ms Sql Detailed
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
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