Book:Databases

src: i.ytimg.com

Video Book:Databases

Introduction: Data management; Database; Database system; Database management system; Types of DBMS; Data store; Technical Information Project

Introduction to Data Modeling: Data modeling; Data model; Database model; Database design; Conceptual schema; Data structure diagram; Hierarchical database model; Network model; Navigational database

ERD: Entity-relationship model; Has-a; Many-to-many; Enhanced Entity-Relationship Model; Weak entity; Associative Entities; Structured-Entity-Relationship-Model; Barker's Notation; Peter Chen

Relational Schema: Relational model; Relational database; Relational database management system; Life cycle of a relational database; Logical data model; Logical schema; Relation; Table; Tuple; Row; Attribute domain; Candidate key; Unique key; Natural key; Key field; Compound key; Foreign key; Persistent Object Identifier; Cardinality; Recordset; Superkey; Integrity constraints; Check Constraint; Propagation constraint; Transition constraint; Wide and narrow data; Universal relation assumption; Reference table; Junction table; Nested set model; Information schema; Codd's 12 rules; Edgar F. Codd

Relational algebra: Relational algebra; Projection; Rename; Selection; Generalized selection; Range query; Monotonic query; Recursive join; Relvar; Relational calculus; Tuple relational calculus

src: elephanttube.me

Overview: Query language; Data Definition Language; Varchar; Data Manipulation Language; Create, read, update and delete; SQL; SQL-92; SQL:1999; SQL:2003; SQL:2008; SQL:2011; Data; Metadata
Database objects: Table; Column; Field; Row; Data type
Statements: Select; Result set; Synonym; Alias; Insert; Update; Merge; Delete; Join; Set operations; Commit; Rollback; Truncate
Views: View; Materialized view

src: i.ytimg.com

Databases Programming: Active database; Open Database Connectivity; Java Database Connectivity; Meta-SQL; ADO.NET

src: i.ytimg.com

Normal Form: Data redundancy; Database normalization; Functional dependency; Armstrong's axioms; Transitive dependency; Superkey; First normal form; Second normal form; Third normal form; Boyce-Codd normal form; Lossless-Join Decomposition; Join dependency; Multivalued dependency; Fourth normal form; Fifth normal form; Sixth normal form; Denormalization; Domain/key normal form; Single Source of Truth; Single version of the truth; Principle of Orthogonal Design

Transaction Management: Database transaction; Transaction processing; Concurrency control; Transaction Control Language; ACID; Atomicity; Isolation; Durability; Atomic commit; Schedule; Serializability; Precedence graph; Serializability theory; Read-write conflict; Write-read conflict; Write-write conflict; Lock; Record locking; Multiple granularity locking; Two-phase locking; Readers-writer lock; Blind write; Conservative two-phase locking; Strong strict two-phase locking; Index locking; Snapshot isolation; Non-lock concurrency control; Commitment ordering; Long-running transaction; Timestamp-based concurrency control; Pseudoconversational transaction; Thomas write rule; Global concurrency control; Global serializability; Modular concurrency control; Multiversion concurrency control; Optimistic concurrency control; Autocommit; Transaction log; Savepoint; No-force; Non-blocking algorithm; Data recovery; Point-in-time recovery; Redo log; Extreme transaction processing; In-database processing; Locks with ordered sharing; Nested transaction; Transaction processing system; Transaction processing systems; Transaction server; Priority inversion; Priority ceiling protocol; Priority inheritance

Query Optimization and Indexing: Query optimization; Query optimizer; Query plan; Index; Partial index; Expression index; Reverse index; Bitmap index; Inverted index; Sargable; V-optimal histograms; Cardinality; Online aggregation

Distributed DB: Very large database; Big data; XLDB; Secondary database server; Centralized database; Distributed database; Distributed database management system; Distributed file system; Distributed data store; Heterogeneous Database System; Simple Sloppy Semantic Database; Distributed transaction; Network transparency; Long-lived transaction; Distributed concurrency control; Consistency model; Distributed Transaction Coordinator; Two-phase commit protocol; Three-phase commit protocol; Xeround; Vector-field consistency; Storage area network; Partition; Shared nothing architecture; Shard; Quorum

Physical Design: Physical data model; Physical schema; Storage model; Storage block; Tablespace; Database tuning; Database dump; Spindling

Source of article : Wikipedia