Chapter 2 Introduction to Data Definition Language - DDL
DDL is part of SQL (Structure Query Language). DDL is used to describe the database schema (Database Structure) and is used to create and modify the structure of database objects in database.In short: DDL used to create, modify and delete database structure (Tables).
Image: https://powerbidocs.com/
Slide prepsentation used in the video below
Free Khmer Ebook Download (PDF): Database | Microsoft Access | Python Programming
DDL commands: LEARN MORE CHECK THE VIDEO (IN KHMER)
◾ CREATE: used to create database or objects (database, table, function, views,...)
◾ ALTER: used to alter the structure of database.
◾ DROP: used to delete objects (like table) from database.
◾ TRUCATE: used to remove all records (data) from a table, even there are records in the table
◾ RENAME: used to rename an object in the database.
Learn More Introduction to Database (SQL) in Khmer with videos: Chapter 1 | Chapter 2 | Chapter 3
Video #1 Introduction to DDL and Datatype
Video #2 Create Table in Microsoft Access
Video #3 SQL Statement to creat table
Video #4 SQL Statement with Relationship
Video #5 SQL Statement create Tables
Video #6 SQL Statement to Create Tables with Relationship
Video #7 SQL Statement deal with Table