SQL : Structured Query Language

SQL: Structured Query Language

By: Gonzales, Brian Gabriel E.




What is SQL?

- Structured Query Language, or SQL (pronounced "ess-que-el"), is a query language. A database can be communicated with using SQL. It is the preferred language for relational database management systems, claims ANSI (the American National Standards Institute). To update data in a database or to get data from a database, SQL statements are employed. Oracle, Sybase, Microsoft SQL Server, Access, Ingres, and other popular relational database management systems are only a few examples.


 


 SQL Commands

  • SELECT - extracts data from a database
  • UPDATE - updates data in a database
  • DELETE - deletes data from a database
  • INSERT INTO - inserts new data into a database
  • CREATE DATABASE - creates a new database
  • ALTER DATABASE - modifies a database
  • CREATE TABLE - creates a new table
  • ALTER TABLE - modifies a table
  • DROP TABLE - deletes a table
  • CREATE INDEX - creates an index (search key)
  • DROP INDEX - deletes an index





















Comments

Post a Comment

Popular posts from this blog

DATA DEFINITION LANGUAGE, INTERACTIVE DATA MANIPULATION LANGUAGE, EMBEDDED DATA MANIPULATION LANGUAGE

Image
DATA DEFINITION LANGUAGE, INTERACTIVE DATA MANIPULATION LANGUAGE, AND EMBEDDED DATA MANIPULATION LANGUAGE By: Gonzales, Brian Gabriel E. What is Data Definition Language (DDL)? - Although it may sound like another programming language, data definition language is merely a way of classifying the many kinds of SQL statements. The set of SQL commands known as Data Definition Language (DDL) can be used to design and modify database structures. Indexes, triggers, tables, and views are all examples of objects that can be created, modified, or removed using DDL statements. Common DDL statements are as follows: CREATE (generates a new table) ALTER (alters table) Drop (removes a table from the database) What is Interactive Data Manipulation Language? -  A relational database management system can employ the computer language Interactive Data Manipulation Language (IDML) to manipulate and alter data. (RDBMS). It is mostly used to extract, modify, and analyze data from databases that are...
Read more

Information Management: DATABASE MANAGEMENT SYSTEM

Image
DATABASE MANAGEMENT SYSTEM By: Gonzales, Brian Gabriel E. What is a Database Management System?           The system software used to create and administer databases is referred to as a database management system (DBMS). End users can create, protect, read, update, and remove data in a database with the help of a DBMS. Topics Functions of DBMS Advantages of DBMS Disadvantages of DBMS Functions Of DBMS These are the operations of a database management system and how it works. Data Definition Data Manipulation Data Security and Integrity Data Recovery and Concurrency Data Dictionary DATA DEFINITION Metadata must be accepted in source form by the DBMS and converted to the proper object form. DATA MANIPULATION It is the ability of the DBMS to be able to process user requests to access, update already-existing data in the database, and add new data. DATA SECURITY AND INTEGRITY Any efforts to bypass the security and integrity tests specified by the database admi...
Read more