DDL and DML.pptx ddl vs dml ddl and dml ddl and dml

Ddl and dml

1. DML and DDL

2. INDEX SQL Introduction of DML & DDL Statements of DML & DDL Advantages and Disadvantages Conclusion

3. Objective SQL To know about DML & DDL. Structures Advantages and Disadvantages Conclusion

4. SQL SQL is a standardized query language for requesting information from a database. The original version called SEQUEL (structured English query language) was designed by an IBM research center in 1974 and 1975. SQL was first introduced as a commercial database system in 1979 by Oracle Corporation.

5. Introduction of DML DML stands for Data Manipulation Language. A  data manipulation language  ( DML ) is a family of syntax elements similar to a computer programming language used for selecting, inserting, deleting and updating data in a database.

6. Statements of DML DML provides the following statements to manipulate the object in database:- SELECT:- Select records from a table. UPDATE:- Update / Modify existing records. DELETE:- Delete existing records. INSERT:- Insert new records.

7. Advantages of DML The DML statements can modify the data stored in a database. User can specify what data is needed. DML tends to have many different flavors and capabilities between database vendors. It provides efficient human interaction with the system. 

8. Disadvantages of DML DML cannot be used to change the database structure. Tables or columns cannot be created or deleted using DML. View the data without storing the data into the object.   Restrict the view of a table i.e. Can hide some of columns in the tables.

9. Introduction of DDL DDL stands for Data Definition Language. DDL statements are used to build and modify the structure of tables and other objects in the database. DDL is a sub-language of SQL used to create and manipulate objects in a database.

10. Statements of DDL DDL provides the following statements to manipulate the object in database:- CREATE:- This command simply means to create the table. ALTER:- It is used to modify the structure of an existing object. DROP:- It removes the entire table from the database. TRUNCATE:- It is used to delete all data from a table which is faster then delete. RENAME:- It is used to rename a database table.

11. Advantages of DDL Shared data Data independence Improved integrity Multiple user Improved security Efficient data access

12. Conclusion From this presentation, we are able to learn about DDL and DML.

13. Any Queries?