DBMS Resources

A compilation of resources for DBMS.

Index

Introduction to Database Concepts

• Introduction to DBMS
• File system vs DBMS
• Data abstraction in DBMS
• Data independence in DBMS
• DBMS system architecture
• The database administrator

Entity–Relationship Data Model

• Introduction to the ER model
• Drawing an ER model
• Entity participation in ER
• Extended ER(EER)

Relational Model and Relational Algebra

• Introduction to relational model in DBMS
• Introduction of relational model and codd rules in DBMS
• Relational schema in DBMS
• Types of keys in relational model
• Mapping from ER model to relational model

Structured Query Language (SQL)

• SQL tutorials (follow all the parts)

• SQL | DDL, DQL, DML, DCL and TCL Commands

• Datatypes in SQL

• Operators in SQL

• DDL commands

  • CREATE
  • DROP and TRUNCATE
  • ALTER
  • RENAME

• DQL commands

  • SELECT

• DML commands

  • INSERT
  • UPDATE
  • DELETE

• DCL commands

  • GRANT and REVOKE

• TCL commands

  • COMMIT, ROLLBACK and SAVEPOINT

• EXPLAIN in SQL

• Constraints in SQL

• String functions in SQL

• Set operations in SQL

• Aggregate functions in SQL

• GROUP BY in SQL

• HAVING in SQL

• VIEW in SQL

• Joins in SQL(follow all the subsequent parts)

• Nested queries in SQL

• SQL Correlated Subqueries

• Triggers in SQL

• Regex in SQL

Relational Database Design

• Concept of normalization
• Functional dependencies
• Normal forms

Transactions Management and Concurrency and Recovery

• Transaction in DBMS
• Concurrency problems in DBMS transactions
• Concurrency control in DBMS
• Database recovery in DBMS
• Deadlock in DBMS
• Wait-Die scheme vs Wound-Die scheme

Miscellaneous

• Cascade in SQL
• WITH in SQL
• Cursor in SQL
• ROLLUP in SQL
• GROUP BY on multiple columns
• MySQL LIMIT x,y
• Difference between Hierarchical, Network and Relational Data Model
• What is Data Abstraction in DBMS and what are its three levels?
• The relational data model(video)
• Functional dependency in DBMS(video)
• Types of functional dependencies in DBMS
• Basic concept of normalization | Need of Normalization in DBMS(video)

Interview Preparation Materials

• DBMS MCQs
• DBMS MCQs(chapter wise)
• 50 SQL Query Questions and Answers for Practice