SQL Programming & Database Management For Absolute Beginners

ERD is the graphical representation of database scheme. ERD contains tables in the database, the columns within those tables and relationships between the tables.

SQL is a scripting language which means that SQL code is not required to be compiled before execution

Front end or commonly referred to as user interface and backend which consists of code that interact with the database.

Foreign Key

Foreign keys are used to create relationship between two tables. Foreign key column contains values from the primary key column of some other table.

Primary Key

Primary key is used to uniquely identify records within a table.

When an application is being executed, it stores data in RAM (Random Access Memory)

it stores data in RAM

will be executed or none will execute

set of queries in Boolean fashion.

UPDATE Examinations

SET price = price * 1.1

WHERE price < 250