Introducing SQL

SQL Statements






DATA DEFINITION LANGUAGE

Data definition language is also known as data description language as it describes the fields and records in a database table and define changes in the database schema. DDL is a subset of SQL or Structured Query Language which implements database modifications. DDL commands are used for altering the database structure such as creating new tables or objects along with all their attributes (data type, table name, etc.).


DATA MANIPULATION LANGUAGE

Data Manipulation Language or DML is a subset of operations used to insert, delete, and update data in a database. It is a sublanguage of SQL as it comprises some of the operators in the language. Selecting read-only data is closely related and is sometimes also considered a component of a DML, as some users can perform both read and write selection.

EMBEDDED DATA MANIPULATION LANGUAGE

Also known as 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 written inline with the program source code, parsed by an embedded SQL preprocessor and replaced by host-language calls to a code library. This allows programmers to embed SQL statements in programs written in any number of languages such as C/C++, COBOL and Fortran. 









Comments

Post a Comment

Popular posts from this blog

How do you manage a database?

Image
INTRODUCING : EXCEL & ACCESS WHAT IS A DATABASE?  It is a collection of information organized and presented to serve a specific purpose. WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE EXCEL ?  Microsoft Excel is a spreadsheet that features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA).  WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE ACCESS?  Microsoft Access is a database management system (DBMS) that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. WHAT ARE THE DIFFERENCES BETWEEN ACCESS AND EXCEL? Excel is a spreadsheet software program that is traditionally used to manage numerical information, it is used to build models for analyzing data, write simple and complex formulas to perform calculation and present data in a variety of charts. Meanwhile Access is an RDBMS program that can link and extract info...
Read more

Who's json, xml and ajax?

Image
Not who actually. JSON, or JavaScript Object Notation , is a lightweight format used for data exchange in web apps. It's easy to read and write for humans and can be parsed and generated by machines. JSON represents data using key-value pairs, arrays, and nested objects, making it popular in web development. It's widely supported by programming languages and frameworks, and its simplicity and compactness make it efficient for storing and serializing data. XML, or eXtensible Markup Language , is a markup language that encodes documents in a readable format for humans and machines. It uses tags to define elements and structures, allowing for complex data hierarchies. XML is commonly used in various domains for data representation and configuration files. It offers flexibility and supports features like namespaces and schemas for document validation, facilitating structured data exchange across systems and platforms. AJAX, or Asynchronous JavaScript and XML , is a web development ...
Read more