SQL Developer_day1.
Mon, Aug 21, 2023
-
SQL (Structured Query Language)
- DML: Data Manipulation Language
- DDL: Data Definition Language
- DCL: Data Control Language
- TCL: Transaction Control Language
-
Data Modeling: Data modeling in software engineering is the process of creating a data model for an information system by applying certain formal techniques. It may be applied as part of broader Model-driven engineering concept.
-
Schema: In a SQL database, a schema is a list of logical structures of data. A collection of database objects like tables, triggers, stored procedures, etc. A database schema defines how data is organized within a relational database; this is inclusive of logical constraints such as, table names, fields, data types, and the relationships between these entities.
<DDL (Data Definition Language)> first.
