Skip Navigation Links

Subscribe

Ask a Question



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




TOP Interview Coding Problems/Challenges




Comments and Discussions

Ad: Are you a blogger? Join our Blogging forum.





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.