Knowledge Base
Inicio > Cursos > SQL
SQL Tutorial

SQL is an ANSI standard language for accessing databases! In this SQL tutorial you will learn how to use SQL to access, define, and manipulate the data in a database system, like Informix, DB2, Oracle, Sybase, Microsoft SQL Server, and others.

Table of Contents
 
SQL Basic

SQL Introduction
This chapter describes what SQL is, and how it can be used.

SQL Select
How to use the SELECT statement to select data from a table in SQL.

SQL Where
How to use the WHERE clause to specify a criterion for the selection.

SQL And & Or
How to use AND and OR to join two or more conditions in a WHERE clause.

SQL Between
How to use BETWEEN....AND to find data in a range.

SQL Distinct
How to use the DISTINCT keyword to return only different values in a column.

SQL Order By
How to use the ORDER BY keywords to return rows in a defined order.

SQL Insert
How to use the INSERT statement to insert new rows into a table.

SQL Update
How to use the UPDATE statement to update or change rows in a table.

SQL Delete
How to use the DELETE statement to delete rows in a table.

SQL Count
This chapter explains how to use the built-in COUNT functions in SQL.

 
SQL Advanced

SQL Functions
This chapter explains how to use the built-in functions in SQL.

SQL Group By
This chapter explains how to use the built-in GROUP BY function in SQL.

SQL Aliases
This chapter explains how to use aliases for column names and table names.

SQL Join 
How to use select information from more than one table.

SQL Create
How to create databases and tables, and how to delete them.

SQL Alter
How to use the ALTER TABLE statement to add or drop columns in an existing table.