You are here

SQL get started (EN)

A quick build you own database guide.

SELECT - step by step

The SQL command for querying data in a database is very powerfull and therefore can be quite complex. To adres sthat problem I provide here a small step by step tutorial how to build a SELECT command. May be it is easier for you to answer the following questions and to build so your custom SELECT command step by step:

Categories: 

CREATE DATABASE

Syntax:


    CREATE DATABASE dbname
    [ IN dbspace ]
    [ { WITH [ LOCATION = 'dbpath' ] [ TEMPLATE = template ] [ ENCODING = encoding ] }
    | { WITH [ BUFFERED ] LOG }
    | { WITH LOG MODE ANSI } ]

Description:

    Creates a new database in the database management system. Attention, the syntax and the options vary from database system to database system.

Categories: 

SELECT - retrieve data

-- english, deutsch, russian --

Syntax

Description:

CREATE TABLE - create a database table

Syntax

Description:

    CREATE TABLE creates a new empty table in the selectted database from the sructure description in the command.

Categories: 

Preface

The author has written this SQL-help in his free time because a quick and permanently online SQL-tutorial was needed. This is only a part of the whole SQL-standart, for more information about its implementations on different database systems please contact the software manyfacturers. The "Standard-SQL", first developed by IBM, was improved by software firms that develop relational database management systems (RDBMS). But all of this improvements can not be discussed in an brief help file. The small table after the command/keyword indicates in some cases, in wich system this command/keyword is implemented.

Categories: 
Subscribe to RSS - SQL get started (EN)