Structured Query Language ( SQL ) - Database شرح عربى

SQL Statement Categories Learn basic SQL statements for creating database structures • SQL is not a programming language but rather a data sublanguage. • SQL statement categories are as follows: – Data definition language (DDL) ▪ Statements used to create database structures رقم التليفون لحجز الشروحات و الاعمال: https://wa.me/+201065761668 رابط حساب فيسبوك:   / studentguide101   – Data manipulation language (DML) ▪ Statements used to query, insert, modify and delete data – Transaction control language (TCL) ▪ Statements used to mark transaction boundaries – Data control language (DCL) ▪ Statements used to grant and revoke database permissions SQL primary and foreign keys • Primary keys serve as unique identifiers for each row in a database table. • Foreign keys link data in one table to the data in another table. A foreign key column in a table points to a column with unique values in another table