R4R Team working to provide free of cost for experienced and freshers

Tutorials | Examples|Interview Questions and Answers|Java Tutorials| C Tutorials | C++ Tutorials | Spring Tutorials| Hibernate Tutorials | JSP Tutorials | Servelets Tutorials| C# Tutorials | PHP Tutorials etc , Basics | Download Software | Data Types | Variables | Constant | Storage & Classes | Operators | Decisions Making | Loops | Functions| Numbers | Arrays | Pointers | String | Datastructure | Expressions | Preprocessor Statement | I/O | Exception Handling | OOPs Tutorial | Classes and object |C++ Inheritance Overloading | Polymorphism | Abstraction | Encapsulation | Interfaces | Multithreading etc

DATABASE & SQL/PLSQL

Introduction (SQL)
Previous Home Next

MS SQL Server

  1. Fully Web Enabled.
  2. You can use HTTP to send queries to the server. It provides various feature and facility to accesses data on web.
  3. Highly Scalable and Reliable.
  4. SQL sever use scale up and scale out feature to fulfill requirement . In Scale up SQl server use 32 bit Processors and 64GB of RAM to increase the load. In scale out SQL distribute database and data load across the server. When suddenly system crash ,RDBMS recover data quickly with minimum loss. This feature called reliability.

Client Server Architecture (Two Tier Architecture)

SQL
  1. Language to access data object from the SQL server.
  2. Stands for Structured Query Language.
  3. SQL addresses data in sets of rows and column rather than addressing individual component or a single data.
  4. SQL support automatic navigation to target the data means user find data without knowing how to get this data and how to store the data.
  5. Using this user never waste the time on representation of data, user only concentrate on logic.
Previous Home Next