Advanced Databases

This document contains study notes good for a student seeking in depth knowledge on database manipulation using SQL. It contains simple notes that the student can peruse when studying or during revision with much ease and without any guidance from the tutor.

SQL is majorly used in creating databases that go a long way in storing a variety of data. This document is a step by step guide used by a student revising for an exam or studying independently. The notes a re short and precise and the student can understand the concepts being explained with much ease.

This is a study guide for a student who wants to grasp the concept of mapping a Entity Relationship Diagram(ERD) into a Relational Database. It contains short notes that are easy to understand by the student since all the concepts are explained in detail. It can be used by a student revising for their examinations or a student trying to studying on their own.

Being a quite revolving world, there is an emergence of new trends in the field of information Technology. This document focuses on the various trends that have emerged in the Database Technology. It contains short notes the student can use to revise for exam or study in private away from the professor or tutor

With the increasing need to keep information safe, there rises the need to have secure databases whose security cannot be easily breached. This document contains step to step notes on the measures to be taken in order to keep information safe in the databases. These are easy notes that the student can peruse with much ease and grasp the concept fast. Thank me later!

Transaction Management and Concurrency Management is an important topic in study of Database Management Systems. This document contains precise notes that a student can extensively use to study and revise away from the tutor and grasp the content adequately

This document contains slides on query optimization in databases and it is quite helpful for a student trying to grasp the various concepts in Database Manipulation and Query Optimization in Database Management Systems