Skip Navigation Links
ADVERTISEMENT
ADVERTISEMENT

Home

DBMS (Database Management System) Tutorials, Articles

DBMS – This section contains tutorials, articles on Database Management System (DBMS).

Latest Articles, Tutorials on DBMS

  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. What is Chomsky Normal Form?
  40. What is PJNF (Project-Join Normal Form)?
  41. What is the difference between 1NF and 2NF in DBMS?
  42. What is the difference between 1NF and 3NF in DBMS?
  43. DBMS | File Organization
  44. Design Decision about Indexing | DBMS
  45. Log based Recovery in Database Management System
  46. Buffering of Blocks | DBMS
  47. Classification of Schedules in DBMS
  48. Locking protocols and its types in DBMS
  49. Query Optimization, Recovery of transaction and Multiple Granularity | DBMS
  50. Concurrency and problem due to concurrency in DBMS
  51. DBMS | Concurrency Control
  52. DBMS | Concurrency Control and Various methods of concurrency control
  53. Lossless Decomposition in DBMS
  54. DBMS | Data Replication and its Types
  55. DBMS | Data Replication Schemes, Advantages and Disadvantages of Data Replication
  56. Redundancy Issues in a Database in DBMS
  57. Denormalization in Database | DBMS
  58. Tuple Relational Calculus | DBMS
  59. Row oriented vs Column oriented Data stores | DBMS
  60. Join operation vs nested query | DBMS
  61. Armstrong's Axioms in Functional Dependency | DBMS
  62. Dependency preserving decomposition | DBMS
  63. Domain-key normal form | DBMS
  64. Fourth Normal Form (4NF) | DBMS
  65. Fifth Normal Form (5NF) | DBMS
  66. How to find the highest normal form of a relation in DBMS?
  67. Thomas Write Rule in DBMS
  68. Equivalence of Functional Dependencies | DBMS
  69. Timestamp ordering protocol | DBMS
  70. Precedence Graph | DBMS
  71. 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


ADVERTISEMENT
ADVERTISEMENT


Preparation

Aptitude Questions MCQs Find Output Programs

What's New

ADVERTISEMENT

Top Interview Coding Problems/Challenges!

ADVERTISEMENT

ADVERTISEMENT

Comments and Discussions!



ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

ABOUT SECTION
» About us
» Contact us
» Feedback
» Privacy policy

STUDENT'S SECTION
» Internship
» Certificates
» Content Writers of the Month

SUBSCRIBE
» Facebook
» LinkedIn
» Subscribe through email

© https://www.includehelp.com some rights reserved.