Advanced DBMS Topics

Advanced concepts in DBMS

Advanced Database Topics

(Click on the links to navigate)

• Advanced Concepts in DBMS:

This link takes you to the section which broadly discusses about Database Design using ER model and Normalization techniques, various normal forms, Indexing and Tuning, Performance issues in DBMS, basic building blocks of a DBMS software, etc. with appropriate examples (in some posts). This section is especially meant for those who are naive to DBMS. More.....

• ADBMS Quizzes:

You can give quizzes on various topics in DBMS basics and advanced concepts. Also, set of solved exercises are included. More.....

• Parallel Database Concepts:

In this section, I have discussed about parallel database concepts like, parallel database architectures, basic issues in parallelizing database accesses, data distribution to parallel machines, types of parallel operations, achievability of parallel operations, some keywords used in parallel databases, real time parallel implementation through Oracle, MySQL, etc. More.....

• Distributed Database Concepts:

This link is about architecture used in distributed database, data distribution through fragmentation and replication, distributed transactions, distributed concurrency control, some examples on how to fragment and allocate databases, etc. More.....

• Object Database Concepts:

This link will take to the Object database concepts like object oriented database, object relational database, concepts of types, inheritance etc. More.....

• SQL:

This link lists the syntaxes for creating tables, and executing queries (Handling DDL, DML, TCL queries) mainly for SQL new learners. More.....

• Previous Year University Exam Questions:

Set of University exam questions can be found here. University questions comprises of Indian and few foreign Universities. Some of them are solved or links are provided for answers. More.....

• Other Computer Science and Engineering Subjects:

Notes, PPTs, PDFs, Question papers etc. for other computer science related subjects are provided here. More.....

• Links to useful video lectures in Computer Science and Engineering Subjects:

In this page you can find the links to most popular, useful, simple and easily understandable online video lectures for students in the field of computer science and engineering by many eminent speakers. More.....

******************************