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

React JS for Beginners

Image
  IT Seminars and Educational Trips Reflection Report Jerika Soriano BSIT 4B React JS for Beginners  Details of the Event/Activity: I recently completed the "React JS for Beginners" course by The New Boston. This course provided an introduction to React JS, a popular JavaScript framework maintained by Facebook, Instagram, and several other companies. React JS is widely used in the development of dynamic and responsive web applications, including those for Netflix, Imgur, Feedly, Airbnb, SeatGeek, HelloSign, and Walmart.   Reflections on the Webinar/Activity and Learnings: The course was well-organized, starting with the basics of React JS and progressively covering more advanced concepts. It explained the core principles of React, including components, state, and props. The instructor's approach was clear and engaging, making complex ideas accessible even for beginners. The hands-on coding examples and practical exercises were particularly helpful in reinfo...
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