INFORMATION MANAGEMENT(MODULE 4) Zyvrex John R Perez BSIT - 1A What is SQL? Structure Query Language stands for Structured Query Language. A database access and manipulation standard language. It follows the ANSI standard. SQL can do: SQL can execute queries against a database SQL can retrieve data from a database SQL can insert records in a database SQL can update records in a database SQL can delete records from a database SQL can create new databases SQL can create new tables in a database SQL can create stored procedures in a database SQL can create views in a database SQL can set permissions on tables, procedures and views SQL Commands : SELECT - extract 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 DR...
Posts
Showing posts from May, 2022
- Get link
- X
- Other Apps
Information Management (Module 6) Zyvrex John R Perez BSIT - 1A XML Extensible markup language (XML) is a markup language similar to HTML. It was created with the purpose of storing and transporting data while also being self-descriptive. Is a recommendation from the W3C. JSON JavaScript Object Notation is abbreviated as JSON. Is a lightweight data storage and transmission format. When data is transmitted from a server to a web page, this is commonly utilized. Is it "self-descriptive" and simple to comprehend? AJAX Ajax is a developer's dream because you can: - Read data from web server - after a web page loaded - Update a webpage without reloading the page - Send data to a web server - in the backgrou d