Advanced DBMS Topics

Advanced Database Topics
(Click on the links to navigate)

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.....

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

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.....

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.....

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

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.....

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





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

 





No comments:

Post a Comment

Popular Posts