SQL COMMANDS CHEATSHEET

DDL (Data Definition Language)

  • CREATE Command
  • DROP Command
  • ALTER Command
  • TRUNCATE Command

DML (Data Definition Language)

  • INSERT Command
  • UPDATE Command
  • DELETE Command

DQL (Data Query Language)

  • SELECT Command

DCL (Data Control Language)

  • Grant Command
  • Revoke Command

TCL (Transaction Control Language)

  • Commit Command
  • Rollback Command
  • Savepoint Command
  • DDL ( Data Definition Language )

Copy to Clipboard
  • DML ( Data Manipulation Language )

Copy to Clipboard
  • DCL ( Data Control Language )

Copy to Clipboard
  • TCL ( Transaction Control Language )

Copy to Clipboard
  • DQL ( Data Query Language )

Copy to Clipboard
  • Save 6 Points to optimize database performance.

    • Check your database server
    • Improve indexing strategies
    • Identify access to the database
    • Evaluate connection capacity
    • Optimize Queries
    • Database Performance Resources