SQL.pptx

COLLEGE OF CITY of MALABON UNIVERSITY COMPUTER STUDIES FOUNDED 1994 Introduction to SQL  COLLEGE OF CITY of MALABON...

COLLEGE OF CITY of MALABON UNIVERSITY COMPUTER STUDIES FOUNDED 1994 Introduction to SQL  COLLEGE OF CITY of MALABON UNIVERSITY COMPUTER STUDIES FOUNDED 1994 SQL Structured query language (SQL) is a programming language for storing and processing information in a relational database. A relational database stores information in tabular form, with rows and columns representing different data attributes and the various relationships between the data values. You can use SQL statements to store, update, remove, search, and retrieve information from the database. You can also use SQL to maintain and optimize database performance.  COLLEGE OF CITY of MALABON UNIVERSITY COMPUTER STUDIES FOUNDED 1994 Data Manipulation Language Data Manipulation Language (DML) is a subset of SQL statements used to manipulate data stored in tables. It includes commands such as SELECT - The SELECT statement is used to select data from a database. INSERT - The SQL INSERT INTO Statement​​The INSERT INTO statement is used to insert new records in a table. UPDATE - The UPDATE statement is used to modify the existing records in a table. UPDATE Syntax. UPDATE table_name DELETE - The SQL DELETE Statement​​The DELETE statement is used to delete existing records in a table.  COLLEGE OF CITY of MALABON UNIVERSITY COMPUTER STUDIES FOUNDED 1994 Data Manipulation Language Data Definition Language (DDL) is used to create and modify the structure of objects in a database using predefined commands and a specific syntax. These database objects include tables, sequences, locations, aliases, schemas and indexes.  COLLEGE OF CITY of MALABON UNIVERSITY COMPUTER STUDIES FOUNDED 1994 Data Control Language Transaction Control Data Control Language (DCL): DCL is a subset of SQL (Structured Query Language) that deals with defining and controlling access to the data within a database. It includes commands for granting privileges to users and revoking those privileges when necessary. Examples of DCL commands include: GRANT: Allows users to access specific database objects or perform certain operations on them. REVOKE: Removes previously granted privileges from users.  COLLEGE OF CITY of MALABON UNIVERSITY COMPUTER STUDIES FOUNDED 1994 Data Control Language Transaction Control Transaction Control: Transaction control commands are used to manage the transactions within a database. A transaction is a unit of work performed against a database, which is treated in a coherent and reliable way independent of other transactions. Transaction control commands ensure the consistency and integrity of the data. Examples of transaction control commands include: COMMIT: Saves all changes made during the current transaction permanently. ROLLBACK: Undoes all changes made during the current transaction and restores the database to its state before the transaction began. COLLEGE OF CITY of MALABON UNIVERSITY COMPUTER STUDIES FOUNDED 1994 THANK YOU