Introduction To SQL

What is SQL?

  • SQL represents Organized Question Language
  • SQL enables you to entry and change databases
  • SQL is definitely an ANSI (American National Criteria Institute) standard
SQL is a standard language for accessing and manipulating databases.

What Can SQL do?

  • SQL may implement queries against a database.
  • SQL may get data from a database.
  • SQL may place documents in a database.
  • SQL may update documents in a database.
  • SQL may erase documents from a database.
  • SQL can make new sources.
  • SQL can make new platforms in a database.
  • SQL can make located techniques in a database.
  • SQL can make views in a database.
  • SQL may collection permissions on platforms, techniques, and views.

Some of The Most Important SQL Commands :

  • SELECT – extracts knowledge from the repository.
  • UPDATE – changes knowledge in a repository.
  • DELETE – removes knowledge from the repository.
  • INSERT INTO – positions new knowledge into a repository.
  • CREATE DATABASE – produces a fresh repository.
  • ALTER DATABASE – modifies a repository.
  • CREATE TABLE – produces a fresh desk.
  • ALTER TABLE – modifies a dining table.
  • DROP TABLE – removes a dining table.
  • CREATE INDEX – produces an catalog.
  • DROP INDEX – removes an catalog.
Posted in SQL

Leave a Reply

Your email address will not be published. Required fields are marked *