DBMS (Database Management System) Tutorials, Articles

1. Basic Terminologies/terms used in DBMS
2. Introduction of Database Management system
3. Users, Applications, Advantages and Disadvantages of DBMS
4. When Not to Use a DBMS?
5. Types of Database Management System
6. File Oriented and Database Approach in DBMS
7. Difference between DBMS and Traditional File System
8. Views in Database Management System (DBMS)
9. Architecture of Database Management System
10. Instances and Schemas in DBMS
11. Different types of Data Model in DBMS
12. Drawbacks of Data Models and Architecture of Data Model
13. Database Languages in DBMS
14. Data Manipulation in a Network Database
15. Data Definition and Integrity Constraints in Hierarchal Database Model
16. Data Dictionary in DBMS
17. Database Administrators (DBA) in DBMS
18. Database Users and User Interfaces in DBMS
19. Differences between DBMS and RDBMS?
20. Introduction of ER Diagram/ER Modelling
21. Conversion of ER Diagram to Relational Model
22. Differences between SQL Vs NoSQL
23. Aggregate Operators, GROUP BY and HAVING clause in DBMS
24. Nested Queries, Correlated Nested Queries and Set Comparison Operators in DBMS
25. Functional Dependency and Attribute Closure in DBMS
26. Closure set of attribute and irreducible set of functional dependency
27. 12 Golden Rules of EF-Codd | DBMS
28. Relational Algebra in DBMS
29. DBMS | Basic Operators in Relational Algebra
30. DBMS | Extended Operators in Relational Algebra
31. Basic and additional operations of Relational Algebra
32. Relational Calculus in DBMS
33. SQL Joins Tutorial with Queries and Examples
34. Inner Join vs Outer Join in DBMS
35. Transaction in Database Management System
36. Commit Point of Transaction | DBMS
37. Keys in Database Management System (DBMS)
38. Normalization in Database Management System
39. DBMS | File Organization
40. Design Decision about Indexing | DBMS
41. Log based Recovery in Database Management System
42. Buffering of Blocks | DBMS
43. Classification of Schedules in DBMS
44. Locking protocols and its types in DBMS
45. Query Optimization, Recovery of transaction and Multiple Granularity | DBMS
46. Concurrency and problem due to concurrency in DBMS
47. DBMS | Concurrency Control
48. DBMS | Concurrency Control and Various methods of concurrency control
49. Lossless Decomposition in DBMS
50. DBMS | Data Replication and its Types
51. DBMS | Data Replication Schemes, Advantages and Disadvantages of Data Replication
52. Redundancy Issues in a Database in DBMS
53. Denormalization in Database | DBMS
54. Tuple Relational Calculus | DBMS
55. Row oriented vs Column oriented Data stores | DBMS
56. Join operation vs nested query | DBMS
57. Armstrong's Axioms in Functional Dependency | DBMS
58. Dependency preserving decomposition | DBMS
59. Domain-key normal form | DBMS
60. Fourth Normal Form (4NF) | DBMS
61. Fifth Normal Form (5NF) | DBMS
62. How to find the highest normal form of a relation in DBMS?
63. Thomas Write Rule in DBMS
64. Equivalence of Functional Dependencies | DBMS
65. Timestamp ordering protocol | DBMS
66. Precedence Graph | DBMS
67. Database Recovery Techniques | DBMS

PL/SQL

1. Introduction to PL / SQL in DBMS
2. Block Structure of PL/SQL in DBMS
3. Looping in PL/SQL (Procedural Language Extension of SQL)
4. Case Statements in PL/SQL
5. How to input from user in PL/SQL?
6. Strings in PL/SQL - 1 (Types of string with Example)
7. Strings in PL/SQL - 2 (Functions with Examples)
8. Arrays in PL/SQL (with its properties, syntaxes and examples)
9. Procedure in PL/SQL to find minimum of 2 numbers

DBMS Interview Questions

1. Top 50 DBMS Interview Questions and Answers

Latest DBMS Aptitude Questions and Answers

• Basic Database Management System (DBMS) Aptitude Questions and Answers
• Basic Database Management System (DBMS) Aptitude Questions and Answers (2)
• Basic Database Management System (DBMS) Aptitude Questions and Answers (3)
• Basic Database Management System (DBMS) Aptitude Questions and Answers (4)