Top Menu

Search This Blog

Introduction

What is the SQL? 
The history of SQL begins in an IBM laboratory in San Jose, California, where SQL was developed in the late 1970s. It was originally developed for IBM's DB2 product (a relational database management system, or RDBMS, that can still be bought today for various platforms and environments).two standards organizations, the American National Standards Institute (ANSI) and the International Standards Organization (ISO), currently promote SQL standards to industry. SQL stands for "Structured Query Language". SQL is used to communicate with a database. It is the standard language for relational database management systems.


What is the SQL Server?
SQL Server is Microsoft "relational database management system" (RDBMS).


What is RDBMS?
Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be created and maintained across and among the data and tables. In a relational database, relationships between data items are expressed by means of tables. Inter dependencies among these tables are expressed by data values rather than by pointers. This allows a high degree of data independence. An RDBMS has the capability to recombine the data items from different files, providing powerful tools for data usage. 

What is the Databases?
Database systems store information in every conceivable business environment.  

Why use SQL?
  • create new databases 
  • create new tables in a database
  • insert records in a database and tables
  • update records in a database and tables
  • delete records from a database and tables
  • retrieve data from a database and tables
  • create stored procedures in a database
  • create views in a database 

 

 


Post a Comment

Designed by OddThemes | Distributed By Gooyaabi Templates