Before we learn about what SQL server is and how SQL
will work, first we would like to know what are
DATA, DATABASE, and DBMS keywords
Data: information
that has been translated into a form that it is more convenient to transfer or process
Database:
It is a systematic collection of data that is stored in computer
DBMS:
Database management system- Is a collection of programs which enables its users
to access Database, Manipulate data and retrieve relevant information.
Different Types of DBMS:
1. Hierarchical
DBMS(Tree structure – E.g. Windows
Registry
2. Network DBMS –it implements network mode and
it is Many to Many model.
3. Relational DBMS –
it defines the database relations in the form of relations(Rows and Columns).
Most of the systems will use RDMS E.g. MYSQL, SQL SERVER, ORACLE and it uses Query
language called SQL to SELECT/INSERT/UPDATE/DELETE the data
Here we will concentrate on Relation DBMS i.e. SQL SERVER
Before we move on to SQL Server, Let’s get some idea
on what are Rows and Column
In the above diagrams EmpID, Ename, and Dept are COLUMNS and data which is associated to
those columns are called ROWS
0 comments:
Post a Comment