Learn DBMS in 24 Hours
Alex Nordeen
Casa editrice: Publishdrive
Sinossi
Table Of Content Chapter 1: What is DBMS (Database Management System)? Application, Types & Example What is a Database?What is DBMS?Example of a DBMSHistory of DBMSCharacteristics of Database Management SystemDBMS vs. Flat FileUsers in a DBMS environmentPopular DBMS SoftwareApplication of DBMSTypes of DBMSAdvantages of DBMSDisadvantage of DBMSWhen not to use a DBMS system? Chapter 2: Database Architecture in DBMS: 1-Tier, 2-Tier and 3-Tier What is Database Architecture?Types of DBMS Architecture1-Tier Architecture2-Tier Architecture3-Tier Architecture Chapter 3: DBMS Schemas: Internal, Conceptual, External Internal Level/SchemaConceptual Schema/LevelExternal Schema/LevelGoal of 3 level/schema of DatabaseAdvantages Database SchemaDisadvantages Database Schema Chapter 4: Relational Data Model in DBMS: Concepts, Constraints, Example What is Relational Model?Relational Model ConceptsRelational Integrity ConstraintsOperations in Relational ModelBest Practices for creating a Relational ModelAdvantages of using Relational ModelDisadvantages of using Relational Model Chapter 5: ER Diagram: Entity Relationship Diagram Model | DBMS Example What is ER Diagram?What is ER Model?History of ER modelsWhy use ER Diagrams?Facts about ER Diagram ModelER Diagrams Symbols & NotationsComponents of the ER DiagramWHAT IS ENTITY?RelationshipWeak EntitiesAttributesCardinalityHow to Create an Entity Relationship Diagram (ERD)Best Practices for Developing Effective ER Diagrams Chapter 6: Relational Algebra in DBMS: Operations with Examples Chapter 7: DBMS Transaction Management: What are ACID Properties? Chapter 8: DBMS Concurrency Control: Timestamp & Lock-Based Protocols Chapter 9: DBMS Keys: Candidate, Super, Primary, Foreign Key Types with Example Chapter 10: Functional Dependency in DBMS: What is, Types and Examples Chapter 11: Data Independence in DBMS: Physical & Logical with Examples Chapter 12: Hashing in DBMS: Static & Dynamic with Examples Chapter 13: SQL Commands: DML, DDL, DCL, TCL, DQL with Query Example Chapter 14: DBMS Joins: Inner, Left Outer, THETA Types of Join Operations Chapter 15: Indexing in DBMS: What is, Types of Indexes with EXAMPLES Chapter 16: DBMS vs RDBMS: Difference between DBMS and RDBMS Chapter 17: File System vs DBMS: Key Differences Chapter 18: SQL vs NoSQL: What’s the Difference Between SQL and NoSQL Chapter 19: Clustered vs Non-clustered Index: Key Differences with Example Chapter 20: Primary Key vs Foreign Key: What’s the Difference? Chapter 21: Primary Key vs Unique Key: What’s the Difference? Chapter 22: Row vs Column: What’s the Difference? Chapter 23: Row vs Column: What’s the Difference?
