FuzzDuck
FuzzDuck
FuzzDuck

SQL – Structured Query Language

Programming language used to communicate with databases.

The SQL or Structured Query Language is used to communicate and shape databases with different commands. The whole database system is being referred to as a RDBMS or Relational Database Management System. So when we type in SQL commands, we are ordering the RDBMS to perform different actions. There are different SQL variants such as MS SQL, Transact-SQL, MYSQL and PL/SQL. At this page, I will explain about basic SQL often used in MS SQL and MYSQL.


Creating databases with SQL.

Pointing commands to a specific database.

Changing the database.

Removing a database.

Creating a table into the database.

Removing a table from the database.

Storing values inside a table.

Changing the content of a table.

Selecting, deleting or updating specific rows.

Creating databases with SQL.

Pointing commands to a specific database.

Changing the database.

Removing a database.

Creating a table into the database.

Removing a table from the database.

Storing values inside a table.

Changing the content of a table.

Selecting, deleting or updating specific rows.


Operators / Symbols

The SQL language uses different operators as the semicolon (;), to signify the end of a query, and the equal (=), to give new values to parameters. The brackets are used after a type like VARCHAR, to tell how long it is going to be. (e.g. VARCHAR (100), can contain max 100 letters). The curly brackets can be used right after a table, telling the content of the table. e.g. CREATE TABLE TableName {id int, Name varchar (10) };