OVERVIEW
The term database is made up of two separate words,i.e.,data and base. A database allows easy and efficient storage, retrieval and modification of data, regardless of the amount of data being manipulated, essentially, database is a computerized record keeping system. For example, an Employee database contains similar data. For all Employees and every Employee’s entry contains a similar type of information. The organised information(i.e.,database) serves as a base from which the desired information can be retrieved, conclusions can be drawn and decisions can be made, by further recognising or processing this data.
“A Database Management System(DBMS) is a collection of interrelated data and a set of programs to access those data.”
Database is the combination of two words: Database + Management System = DBMS
- A database is a collection of related information stored, so that is available to many users for different purposes. On the other hand, management system is a collection of programs that enables users to create and maintain the database.
- DBMS can also be defined “as an interface between the application program and the operating system to access or manipulate the database.
- ”The primary goal of a DBMS is to provide an environment that is congenial and efficient to retrieve and store information.
- It allows guest to store, update and retrieve data in abstract terms. DBMS eases the maintenance and retrieval of information from a database.
- A DBMS also relieves the user from having to know about the exact physical representations of data and from specifying detailed algorithm for sorting, updating and retrieving the data.
- We frequently use a database in our everyday life. Dictionary is one of the most common example of a database where words are arranged alphabetically. Similarly, a telephone directory is another example of a database, where the names of telephone subscribers are listed in alphabetical order.
IMPORTANT TOPICS INCLUDES:
- Architecture of DBMS
- E-R Model Concepts
- Extended E-R Model
- Role of DBA
- Codd Rule for RDBMS
- Integrity Constraints
- Query Language
- Relational Algebra
- Relational Calculus
- PL/SQL
- Functional Dependency
- Normal forms
- Properties of Transaction
- Recovery from Transaction Failures
- Concurrency Control Techniques
- Serializability of Schedules
- Deadlock Handling and Detection
- Recovery from Deadlock
- Mode of Locking
- Multiple Granularity
Tricks for efficient learning :
- Start from basics– Do not ponder much over the hardest topics from the very beginning, start studying the basics first. Clear your concepts of database or else you would not be able to learn DBMS efficiently.
- Emphasise on the queries solving practise– Try to solve the SQL queries by itself, practise as much as you can. It will make your SQL query solving stronger.
- Solve Tutorial Exercise– DBMS is not a complete theoretical subject, it has a practical approach too.
- Solve Previous Years Question Papers- For efficient problem solving and for gaining more marks, solve the previous years question paper. Try and reduce the time you take for solving each query and learn to answer question efficiently.
Books to refer:-
- DBMS by McFadden is the best book
- For beginners I’ll suggest DBMS by Korth(study only 2-3 chapters of starting from this book)
- For ORACLE the best book is by Ivan Bayross.
- DBMS by P.K Yadav could also be referred for simple and efficient learning.
Leave a Reply