Introduction To SQL
Blogpost #4 A. Engage a. DATA DEFINITION LANGUAGE - Data definition language is a language for describing data and how it relates to other data in the database. b. INTERACTIVE DATA MANIPULATION LANGUAGE - IDML is a programming language used for manipulating data in a database, where users can directly interact and modify data in real-time. c. EMBEDDED DATA MANIPULATION LANGUAGE - EDML is a programming language that is integrated into software applications to help users manipulate database data within the application. With EDML, users can easily perform data manipulation tasks without having to leave the application interface. B. EXPLORE & EXPLAIN 1. What are the basic SQL expression? · SELECT: Used to retrieve data from a database table · INSERT: Used to add new records to a database table · UPDATE: Used to modify existing records in a database table · DELETE: Used to remove records from a database table · WHERE: Used to filter