Database for Software Developers

Relational (MySQL, PostgreSQL, Oracle) | Key-Value (Memcached, Redis) | Columnar (HBase, Cassandra) | Document (MongoDB, CouchDB)

Search (Elasticsearch, Apache Solr) | Geospatial (PostGIS) | Graph (Neo4j)

Requirement collection & analysis | Conceptual data model | Logical data model | Entity | Weak entity | Entities - type and set | Attributes | Attributes - simple vs composite | Attributes - single-valued vs milti | valued | Attributes - complex | Attributes - derived vs stored |Attributes - key attributes | Attributes - null values

Relationship | Relationship - degree of relationship | Relationship - cardinality ratio | Relationship - participation constraints | Relationship - associative / intersection entity | Entity - generalization | specialization | Relational Schemas | Automatically Convert ER Diagrams to Relational Schemas | Star Schemas |Export SQL

ERD to DB Schema - Entity | ERD to DB Schema - Attributes | ERD to DB Schema - Recap | ERD to DB Schema - Relations One to Many | ERD to DB Schema - Relations One to Many - with attribute | ERD to DB Schema - Relations Many to Many | ERD to DB SchemaRelations Many to Many - with Attribute | Fine-tune the Schema | Data Types | Data Types - INT | Data Types - DECIMAL | Data Types - Strings | Data Types - Enums | Data Types - Date-Time

Modify The Schema Updating Tables | Modify The Schema Dropping Things | Random Sample Data | Normalization In Database Schema Design | First Normal Form (1NF) | Second Normal Form (2NF) | Third Normal Form (3NF)

" Combining Multiple Conditions | Combining Multiple Conditions Order of Precedence | Sorting RecordFiltering Records | Operators of WHERE Clause | Sorting by Multiple Fields? | Getting a Slice of Records | Create New Record | Inserting Multiple Records Ensure Input For ALL* fields | Quoting NAMEs Some other things to check If an Update/Insert fails | Handling Special Characters | String Literals Quoting Strings | String Literals Escaping Other Special Characters | Let’s start Selling Tickets | Let’s start Selling Tickets How application does it? | Updating Records | Verify Payments | Deleting Records "

| Ticket Moderation | Deleting Record | Handling Data-Type and Length Mismatch | Exceeding String Lengt | Managing MySQL STRICT mode | Errors and WarningsFinding issues in the last query | CREATE TABLE events | Inserting records | Deleting records | String Literals | Quotations in string | Length and type mismatch | Check SQL Modes | SET SQL Modes | Inestigating Errors and Wornings

Data Integrity | Primary threats to Data Integrity | Types of Data Integrity | Entity Integrity | Referential Integrity | Domain Integrity | User-defined Integrity | MySQL Constraints

"The UNIQUE Constraint | The CHECK Constraint | Where to ensure integrity Front-end, Backend or Database? | How JOIN Works? | Types Of Join | Left Join | Self Join "