Ovido
Idioma
  • Inglês
  • Espanhol
  • Francês
  • Português
  • Alemão
  • Italiano
  • Holandês
  • Sueco
Texto
  • Maiúsculas

Usuário

  • Entrar
  • Criar conta
  • Atualizar para Premium
Ovido
  • Início
  • Entrar
  • Criar conta

Basic SQL

a standard language for storing, manipulating, and retrieving data in databases.

SQL (Structured Query Language)

What SQL stands for?

Structured Query Language

This statements are used to define the database structure or table.

DDL (Data Definition Language)

This statements are used for managing data within table object.

DML (Data Manipulation Language)

Create new database/table.

CREATE

Modifies the structure of database/table.

ALTER

Deletes a database/table.

DROP

Remove all table records including allocated table spaces.

TRUNCATE

Rename the database/table.

RENAME

Retrieve Data from table

SELECT

Insert data into a table.

INSERT

Updates existing data with new data within a table

UPDATE

Deletes the records rows from the table.

DELETE

It also called UPSERT statements to INSERT new records or UPDATE existing records depending on condition matches or not.

MERGE

lock one or more tables in a specified mode. Table access denied to a other users for the duration of your table operation.

LOCK TABLE

It's made up of a single constant, variable, scalar function, or column name and can also be
the pieces of a SQL query that compare values against other values or perform arithmetic calculations.

Expression

Quiz
Entity Relationship Modeling
DATABASE ARCHITECTURE
DATABASE PRINCIPLE
A level bio cells and cell techniques
UNIT 1 INTRODUCTION TO THE HUMAN BODY
morfología
Forensic Toxicology (4)
Histologia 2da Unidad (Citoplasma celular)
information technology
Layouts and Pages
Forensic Toxicology (2)
Heuristics
XAML CONTROLS
SOCIOLOGY
solidificação,fusão,vaporização,condensação
psicologia sócio-histórica
social science.
Series and parallel circuits
Resistance
Electrical cells and circuits
les verbes irréguliers en anglais
tandsköterska
Expresiones de cortesia y saludos
finska v436 hälsningsfraser
akusativ eller dativ
tyska glosor v.36
Quimica Analitica
Specialpedagogik
engineering
SCIENCE
arnold
Fonologia
Derecho mercantil
Who Said That? {Unwanted Vowing}
Temperature conversion (Celcius to Fahrenheit)
Weight conversions (Grams to Oz)
Volume conversions (metric to imperial)
Chapter 1
Figuras Literarias
Kroppen
ANATOMIA 2do. parcial
law
Lo2
Magnetic forces and Magnetic Poles
Chapitre 1A - semaine 36
Mass and Weight
Svea
principios de biomateriles
ART APPRECIATION AND HUMANITIES
Different kinds of sampling