SQL Components

DATA DEFINITION LANGUAGE

    "Data Definition Language" is a term that refers to a programming language A DDL is a programming language that is used to construct and modify data structures. DDL commands may be used to add, delete, or change tables in a database, for example. The DROP command can be used to uninstall a table if it is no longer needed.


INTERACTIVE DATA MANIPULATION LANGUAGE

SELECT statements are used to retrieve data from a relational database, and INSERT, UPDATE, and DELETE statements are used to modify the data. The SQL sublanguage, also known as Data Manipulation Language, is made up of these sentences (or DML)


EMBEDDED DATA MANIPULATION LANGUAGE

Embedded SQL is intended for use in general-purpose programming languages like PL/1, Cobol, Java, Pascal, and C. Embedded Data Manipulation Language (EDML)- This version of SQL is intended for use in general-purpose programming languages.





Comments

Post a Comment

Popular posts from this blog

Image
XML Extensible Markup Language (XML) is an abbreviation for Extensible Markup Language. It is a text-built markup language based on the Standard Generalized Markup Language (SGML). Unlike HTML tags, which define how to show the data, XML tags describe the data and are used to store and arrange it rather than defining how to display it. XML will not replace HTML in the immediate future, but it will add new possibilities by incorporating several successful HTML features. JSON JSON is an abbreviation for JavaScript Object Notation. JSON is a lightweight data storage and transport format. When data is transmitted from a server to a web page, JSON is often used. JSON is "self-describing" and simple to grasp. AJAX AJAX stands for Asynchronous JavaScript. AJAX is a methodology for designing interactive and fast-loading websites. AJAX enables asynchronous web page updates by sharing tiny volumes of data with the server behind the scenes. This ensures that portions of a web page can b
Read more

Experiences and Lessons Learned in Work Environment

Image
  E xperiences and Lessons Learned in Work Environment My OJT was at Angel C Manglicmot High School in Brgy. Angeles San Antonio Zambales. At first, I was scared and thrilled, and it was difficult for me to engage with them since it was work from home. To think about it, they were professionals, and I was just a student trainee, and I couldn't interact with them effectively over internet. After the training, I realized that OJT is more than simply a need to be fulfilled; it is also an opportunity to demonstrate my abilities, knowledge, and talents, as well as to experience the sense of being a professional. In my OJT, I learn a lot of things, some of which I embrace and apply to myself, and others of which help me expand my abilities and knowledge. I was thrilled to have my OJT in this office. I learn to be more patient with every work that is assigned to me, to be polite and modest with everyone with whom I contact, and, most importantly, to LOVE MY WORK. The training helped me un
Read more
Image
 What exactly is SQL?      SQL (pronounced "ess-cue-el") stands for Structured Query Language. SQL is a language that is used to interact with databases. It is the basic language for relational database management systems, according to ANSI (American National Standards Institute). SQL statements are used to do things like update data on a database or extract data from a database. SQL Partitions The SQL language is divided into three parts: DML is used to retrieve and edit data in a table, such as inserting, deleting, and updating records. On the other hand, Select becomes a special declaration in this subset despite being a read-only instruction that does not modify data at all. DCL is used to manage access to data in a network, such as granting or robbing other users' privileges to execute specific tasks. DDL is used to describe data structures, such as creating, altering, or deleting tables. TCL commands, or transaction management language commands, deal with databas
Read more