Introduction to SQL

 What is Data Definition Language?

    Data definition language (DDL) is a computer language used to create and modify the structure of database objects in a database. In the context of SQL, data definition or data description language is a syntax for creating and modifying database objects such as tables, indices, and users. DDL statements are similar to a computer programming language for defining data structures, especially database schemas. 

    Data Definition Language (DDL) is a subset of SQL. It is a language for describing data and its relationships in a database. You can generate DDL in a script for database objects to keep a snapshot of the database structure. Set up a test system where the database acts as the production system but contains no data.

What is Interactive Manipulation Language?

Interactive manipulation language is a component of the SQL that is used to insert, delete and update tuples in a relation.

What is Embedded Data Manipulation Language?

Embedded Data Manipulation Language is a method of inserting inline SQL statements or queries into the code of a programming language, which is known as a host language. Because the host language cannot parse SQL, the inserted SQL is parsed by an embedded SQL preprocessor.

Comments

Post a Comment

Popular posts from this blog

Introduction to JSON

Image
 WHAT IS XML?     XML or Extensible Markup Language is a markup language and file formal for sorting, transmitting, and reconstructing arbitrary data.  It defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. XML emphasizes simplicity, generality, and usability across the Internet. It is a textual data format with strong support via Unicode for different human languages. Although the design of XML focuses on documents, the language is widely used for the representation of arbitrary data structures such as those used in web services. JSON JavaScript Object Notation (JSON) is a standard text-based format for representing structured data based on JavaScript object syntax. It is commonly used for transmitting data in web applications. JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate and it is ...
Read more

Introduction to SQL

Image
 WHAT IS SQL?      SQL stands for Structured Query Language. SQL is used to communicate with a database. It is the standard language for relational database management systems. SQL statements are used to perform tasks such as updati ng data on a database or retrieving data from a database. Some common relational database management systems that use SQL are Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc.      Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as “Select”, “Insert”, “Update”, “Delete”, “Create”, and “Drop” can be used to accomplish almost everything that one needs to do with a database. WHAT SQL CAN DO? SQL can execute queries against a database SQL can retrieve data from a database   SQL can insert records into a database   SQL can update records in a database  S...
Read more