Loading lesson path
Concept visual
Start at both ends
Most of the actions you need to perform on a database are done with SQL statements. SQL statements consist of keywords that are easy to understand. The following SQL statement selects all records from the table named "Customers":
Select all records from the Customers table:
SELECT * FROM Customers;In this tutorial we will teach you all about the different SQL statements.
A database most often contains one or more tables. Each table is identified by a name (e.g. "Customers" or "Orders"), and contain records (rows) with data.
Formula
In this tutorial we will use the well - known Northwind sample database(included in MS Access and MS SQL Server).
Customers table used in the examples:
Obere Str. 57
12209
Avda. de la Constitución 2222 México D.F. 05021
Antonio Moreno TaquerÃa
México D.F. 05023
120 Hanover Sq.