• No products in the cart.

0

A Relation Database Management system (RDBMS) is a database management system that is based on the relational model.
All modern database management systems like SQL, MS SQL Server, IBM DB2, ORACLE, My-SQL and Microsoft Access are based on RDBMS.

4,001.00

Mode Of Examination

Online Examination

Number Of Question: 100 (1 Marks Each)

Total Time: 120 Min

Syllabus

Introduction to Relational Model and Sql:

Relational model basics, sql data definition, basic and set operations, aggregrate functions, nested subqueries and database modifications.

Intermediate and Advanced Sql:

Join expressions, views and transactions, integrity constraints, sql data types, olap and relational algebra.

Database Design and The ER Model:

Entity relationship model and diagrams, relational schema and e-r features.

Relational Database Design:

Relational design features, functional dependency theory and decomposition, decomposition algorithms and normal forms.

Application Design and Development:

Web fundamentals, servlets and jsp, application architectures and security.

Storage and File Structure:

Magnetic disk, raid, file and record organization.

Indexing and Hashing:

Ordered indices, b+ trees, bitmap indices, static and dynamic hashing.

Query Processing and Optimization:

Query processing, join operations, expressions evaluation, relational expressions, evaluation plans and materialized views./p>

Transactions:

Transaction concept, serializability, transaction isolation and its levels.

Concurrency Control:

Lock and timestamp based protocols, deadlock handling, multiversion schemes, validation based protocols, insert and delete operations.

Recovery System:

Failure classification and storage, recovery and atomicity.

Practical Questions:

Sql data definition and sql queries.

Course Currilcum

                • Diploma in RDBMS (Online Certification Courses) 02:00:00
              © All rights reserved
              Open chat