The Types of SQLs

 What is a Data Definition Language?


     Data Definition Language (or DDL) includes those SQL statements that create and drop locations, databases and database objects such as tables and indexes, it also includes statements to alter database objects and impose integrity constraints on tables.

Interactive Data Manipulation Language

     What is interactive Data Manipulation Language? It is simply a data manipulation language allows users to access and retrieve database contents in both interactive and embedded modes, now that's interesting!
     It also includes constructs that allow retrieval and manipulation of database content.

Embedded Data Manipulation Language

Now what about embedded data manipulation language? Well Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQL statements are SQL statements written inline with the program source code, of the host language.




Comments

Post a Comment

Popular posts from this blog

INTRODUCTION TO JSON

Image
XML      What is XML? The Extensible Markup Language (XML) is  a simple text-based format for representing structured information: documents, data, configuration, books, transactions, invoices, and much more . It was derived from an older standard format called SGML (ISO 8879), in order to be more suitable for Web use JSON     Moving on to JSON , it is a text-based data format following JavaScript object syntax, which was popularized by Douglas Crockford  Even though it closely resembles JavaScript object literal syntax, it can be used independently from JavaScript, and many programming environments feature the ability to read (parse) and generate JSON.     I s a string whose format very much resembles JavaScript object literal format. You can include the same basic data types inside JSON as you can in a standard JavaScript object  strings, numbers, arrays, booleans, and other object literals. This allows you to construct a data hierarchy. AJAX   AJAX or " Asynchronous JavaScript
Read more

Introduction to Computing Blog

Image
TECHNOLOGY           You can't deny the existence of technology and the fact that it truly improved the way of lifestyle for everyone, despite the downsides and negative effects it holds on the younger generation like gaming addictions.           Looking at the brighter side of the spectrum technology has helped humanity progress in a fast rate, new devices are being produced and sold to the public, advance computers, electrical cars, sophisticated gadgets and so much more helps entertain and assist us in our tasks almost everyday. MUSIC & ENTERTAINMENT           Music and overall entertainment had a huge effect on the lives of people, it keeps us motivated, happy and stable, without it people and society would look and feel a lot different in a more sad and monotone way, devoid of emotion and filled with negativity.            It really is a medium that we as individuals seek to help ease the everyday frustration and sadness we face, in a life of hardship and pain, that is wh
Read more

Activity Quiz (BLOGPOST#3)

Image
a.) If you will become a computer parts/gadgets or any ICT tools, what will you be and why? -  If I were to become an ICT tool, I prefer to be a digital camera, so I see beautiful and amazing sceneries and help users capture and store them, I can be useful in many aspects, taking photos for artistic and business purposes, I'll also be available and easy to use by everyone for their entertainment and hobbies, I can also help preserve memorable moments that are important to the users, so they can always remember the good old days and look forward to more memories to capture in the future. b.) What is the use of computer in your day to day activity? - I use my laptop mostly for my own entertainment, I either play online/offline games, and watch different types of videos varying in content on youtube, or browse the chrome for a website where I can watch anime and read mangas for a whole day. I also use my laptop for other reasons, such as research and educational purposes, not only th
Read more