Page 2 :
SQL was developed in 1970 , in IBM, Laboratory., SQL sometime also referred to as SEQUEL, IS a 4th generation non – procedural language., , , In non –procedural languages “WHAT IS REQUIRED”, Instead of “ How it be done”., , SQL is not a case sensitive languages,, popular data manipulation languages., , STRUCTERED QUERY LANGUAES
Page 4 :
DATA DEFINITION LANGUAGE, DDL is used to define the structure of, data., DDL commands are used for creating,, modifying and dropping the structure of, Data base object like tables, indexes, and, user., , , DDL
Page 5 :
Create, Rename, Alter, Drop, , Truncate, , DDL COMMAND
Page 6 :
Data Manipulation Language :- It includes, Commands to enable users to enter and, manipulate data., A DML is a language that enables users to, access and manipulate data in database., , , DML
Page 7 :
, , , , , , , , Data Types: Data types are used to, identify which type of data (value) we are, going to store in the database., Open Office base are broadly classified, into five categories listed below., Numeric Types, • Alphanumeric Types, • Binary Types, , Data Types
Page 8 :
• Date time, • Other Variable types, Numeric Types:, Numeric data types are used for, describing numeric values for the field, used in the table of a database., , , Data Types
Page 9 :
• Binary Types, • Date time, • Other Variable types, , , Data Types