WHAT IS SQL?

-

 Blogspot #5

A. Engage

What is SQL?

- SQL, which stands for Structured Query Language, is a widely-used language for managing relational databases. It enables businesses and organizations to manipulate large amounts of data efficiently by creating, updating, deleting, retrieving, and manipulating data stored in tables. SQL is a declarative language, which means that users specify what they want to do with the data, and the database system determines how to carry out the task. In addition to creating and modifying database structures like tables and indexes, SQL provides a wide range of querying capabilities, such as searching for specific data, aggregating data, and joining multiple tables. Because SQL is supported by many relational database management systems and has a standardized syntax, it facilitates data and command transfer between different database systems.


B. Explore and Explain


1. What are some SQL commands?

- CREATE DATABASE, SELECT, UPDATE, DELETE, INSERT INTO, DROP INDEX, CREATE INDEX, DROP TABLE, ALTER TABLE, CREATE TABLE.


2. What is the difference between drop and delete command?

- In a database, the DELETE command removes one or multiple records from a table. On the other hand, the DROP command eliminates the entire table from the database.


C. ELABORATE & EVALUATION

SELECT 1. Extracts data from a database.

INSERT INTO 2. Inserts new data into a database.

ALTER TABLE 3. Modifies a table.

SQL 4. A standard language for accessing and manipulating databases.

GRANT AND REVOKE 5. Can set permissions on tables, procedures, and views.

Comments

Post a Comment

Popular posts from this blog

XML | JSON | AJAX

-
Image
 Blogpost #6 A. Engage Instruction: Based on your own understanding, kindly define the following terminologies:  A.XML  XML is a language used for storing and moving data. It is based on tags that define different elements within a document, and these tags can be customized to suit specific requirements. XML enables developers to structure and organize data in a way that is suitable for their particular use case. B.JSON  JSON is an acronym for JavaScript Object Notation, which is a simple and lightweight data format that can be easily read and written by humans and machines. It is not tied to any specific programming language and is supported by many popular programming languages. The data in JSON is organized as key-value pairs, with the key being a string and the value being one of several data types. JSON objects are enclosed in curly braces, while arrays are enclosed in square brackets. C.AJAX AJAX stands for Asynchronous JavaScript and XML. It is a web development technique that
Read more

Function, Advantages, Disadvantages of DBMS

-
Image
 Blogpost #2 A. Engage (a) Functions of DBMS Data Definition -  The DBMS must be able to accept data definitions in source form and convert to the appropriate object form.  Data Manipulation -  The DBMS must be able to handle request from the user to retrieve and possibly update existing data in the database, or to add a new data to the database. Data Security and Integrity - The DBMS must be able to monitor user requests and reject any attempts to violate the security and integrity checks defined by the database administrator. Data Recovery and Concurrency -  The DBMS must have the capability of recover from or minimize the effects of a system crash. Data Dictionary -  The DBMS must provide a system database called the database dictionary. The Main function of a DBMS it organizes your database files and provides end users more access and control over their data.  (b) Advantages of DBMS DATA INTEGRITY  - Since a single copy of a particular data is stored in the database, you ca
Read more