← Software Knowledge
MODULE 05 · SOFTWARE KNOWLEDGE

Database & SQL

Understand how application data is stored, organized, queried, and changed.

How the module connects

Applications use SQL and database structures to turn business data into reliable, searchable records.

Application→SQL Query→Database→Rows / Results

Module 05 Topics

DatabaseStores and organizes application data.Open topic → DBMSManages, protects, and provides access to databases.Open topic → SchemaDefines the structure and rules of database objects.Open topic → Relational DatabaseOrganizes related data in connected tables.Open topic → PostgreSQLOpen-source relational database management system.Open topic → MySQLPopular relational database management system.Open topic → IndexHelps find matching rows faster.Open topic → TableStores related data in rows and columns.Open topic → RowOne complete record in a table.Open topic → ColumnOne type of information stored in every row.Open topic → Primary KeyUniquely identifies a row.Open topic → Foreign KeyConnects a row to another table.Open topic → RelationshipConnects related records across tables.Open topic → One-to-ManyDescribes a common table relationship.Open topic → ConstraintEnforces a data rule.Open topic → TransactionTreats operations as one unit.Open topic → NULLRepresents a missing, unknown, or inapplicable value.Open topic → NormalizationReduces unnecessary duplication and improves consistency.Open topic → SQLReads and changes relational data. Continue to Module 06 Authentication →Open topic →
↑