DBMS Tutorial
Table of Content:
A Database is a collection of related data organised in a way that data can be easily accessed, managed and updated. Database can be software based or hardware based, with one sole purpose, storing data.
During early computer days, data was collected and stored on tapes, which were mostly write-only, which means once data is stored on it, it can never be read again. They were slow and bulky, and soon computer scientists realised that they needed a better solution to this problem.
A database system provides a data definition language
to specify the database schema
and a data manipulation language
to express database queries and updates. In
practice, the data definition and data manipulation languages are not two separate
languages; instead they simply form parts of a single database language, such as the
widely used SQL language.
About This Tutorial
This DBMS tutorial has been prepared for the beginners to help them understand the basic to advanced concepts of DBMS. This tutorial will give you enough understanding on the various components of DBMS along with suitable examples.
Prerequisites
Before you start proceeding with this tutorial, it is recommended that you have a good understanding of basic computer concepts such as primary memory, secondary memory, and data structures and algorithms.
Audience
- Students who are pursuing BCA, MCA, B.E/B.Tech (CS/IT/EC/EE/ME/Civil/Any other discipline)
- Students who have "DBMS" in their curriculum
- Candidates who wish to switch from service based companies to product based
- Candidates who want to continue their career as JAVA developer with SQL, DBA etc.
- Candidates who are passionate about coding