Scribd
Upload
23 views2 pages

SQL Operations Guide

This document outlines essential SQL commands for database operations, including Data Definition Language (DDL) for creating, altering, and deleting tables, and Data Manipulation Language (DML) for inserting, updating, and deleting data. It also covers querying techniques using SELECT and various clauses, as well as different types of joins for combining tables. Additionally, it discusses transaction control commands like COMMIT and ROLLBACK for managing changes.

Uploaded by

robstark.thewhitewolf
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
23 views2 pages

SQL Operations Guide

This document outlines essential SQL commands for database operations, including Data Definition Language (DDL) for creating, altering, and deleting tables, and Data Manipulation Language (DML) for inserting, updating, and deleting data. It also covers querying techniques using SELECT and various clauses, as well as different types of joins for combining tables. Additionally, it discusses transaction control commands like COMMIT and ROLLBACK for managing changes.

Uploaded by

robstark.thewhitewolf
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

SQL Commands Guide

Fundamental SQL Commands and Database Operations Guide

This document provides a summary of essential Structured Query Language (SQL) commands for

database administrators and developers.

1. Data Definition Language (DDL)

- CREATE TABLE: Used to create a new table.

- ALTER TABLE: Modifies an existing database object.

- DROP TABLE: Deletes a table.

2. Data Manipulation Language (DML)

- INSERT INTO: Adds new data to a table.

- UPDATE: Modifies existing data.

- DELETE: Removes data.

3. Querying

Using SELECT with WHERE, GROUP BY, ORDER BY, and HAVING clauses to filter and organize

data.

4. Joins

Explanations of INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN for combining

rows from two or more tables.


5. Transaction Control

- COMMIT: Saves changes.

- ROLLBACK: Undoes changes.

You might also like