Database Management System (DBMS)

DDL, DQL, DML, DCL and TCL Commands

DDL, DQL, DML, DCL, and TCL Commands

Database Management System (DBMS), NTA UGC PAPER II (CS)

These SQL (Structured Query Language) commands are mainly categorized into four categories:  DDL – Data Definition Language DQl – Data Query Language DML – Data Manipulation Language DCL – Data Control Language   DDL (Data Definition Language) A database system provides a data-definition language (DDL) to specify the database schema List of DDL commands: • CREATE• […]

DDL, DQL, DML, DCL, and TCL Commands Read More »

database management system

Database Management System (DBMS) | Overview | Syllabus | Book

Database Management System (DBMS), NTA UGC PAPER II (CS)

What is a database? A database system is basically just a computerized record-keeping system. What is enterprise An enterprise might be a single individual with a small personal database, or a complete corporation or similar large body with a large shared database, or anything in between. Here are some examples: A manufacturing company A bank

Database Management System (DBMS) | Overview | Syllabus | Book Read More »