Learning SQL




SQL Components

        SQL is a comprehensive language that has its own DDL and DML components:


    DATA DEFINITION LANGUAGE

  • Data Definition Language is used to create, design, define schemes, or set up your desired database structure.


    INTERACTIVE DATA MANIPULATION LANGUAGE 

  • Interactive Data Manipulating Language is used for interacting or manipulating your data in your database. It allows you to do certain operation and these are insert new data, delete existing data, or update your data.


    EMBEDDED DATA MANIPULATION LANGUAGE

  • Embedded Data Manipulation Language is like a helpful translator that translate our programming languages to an SQL command in order for our program to be executed.

            

Comments

Post a Comment

Popular posts from this blog

DEFINE SQL

Image
SQL     SQL stands for Structured Query Language. Mainly used for accessing and manipulating relational databases. Basically it is used for interacting and organizing databases easily. It has basic commands that executes certain functions such as SELECT, DELETE, INSERT INTO, and etc.  The command names describes its function already which makes it easy to identify and apply in the database. 
Read more