SQL TRAINING

1.Fundamentals of DBMS

Data is the most important component in any work that we do.

Data means collection of information or collection of raw facts.

Data Base is a collection of related data.

Data Base Management System is the management system or maintenance system on databases.  (Or)

It is a suit of software program for creating, maintaining & manipulating the data in database.    (Or)

It allows the users to insert the data, to retrieve the data, to modify the data and to delete the data.

The first databases of kind existed in the form of files.

A file is nothing but collection of records.

A Record is nothing but collection of information or data.

But the file system was not very efficient .it was crippled by slow data search speed. It includes the following Drawbacks.

1.Security

2.Data Redundancy

3.Data Integrity

4.Concurrency Control

5.Slow in Process

Security: No Login name No Password.

Data Redundancy: Data reputation or data duplication is very high.

Data Integrity: No Data Validation process.

Concurrency Control: No control in files system when concurrency exists.

Slow in process: File System follows Sequential-searching process.

Data Base System models or Types of DBMS

1.      HIERARCHICAL MODEL

2.      NETWORK MODEL

3.      RELATIONAL MODEL