Short SQL Guide

Some of the most exciting IT career choices right now and probably in foreseeable future are in database field. With the surge of Big Data and NoSQL databases, the opportunities for DBAs, database developers and BI developers seem endless. This short tutorial is meant as an introduction to Structured Query Language simply known as SQL.

SQL History

SQL was developed by IBM in the early 70s, and was based on Dr. Codd’s paper, "A Relational Model of Data for Large Shared Data Banks". SQL is a query language used to communicate with Relational Database Management Systems. SQL language has several element types including clauses, expressions, queries, and statements to name a few.

Data Manipulation Language (DML)

The Data Manipulation Language is the subcategory of SQL commands used to add, update and delete records in a database table.

SQL INSERT

If you want to add new records to a database table you can use the INSERT SQL statement. Here is an example of inserting data:

INSERT INTO Table1
(Filed1, Field2) VALUES ('Value 1 goes here', 'Value 2 goes here')

SQL UPDATE

To modify existing rows in your table you can use the UPDATE SQL statement. Here is a simple example of updating data with SQL:

UPDATE Table1
SET Field1 = 'New Value goes here'
WHERE Field1 = 'Value 1 goes here'

SQL DELETE

If you need to delete data from a table you can do it like this:

DELETE FROM Table1 
WHERE Field1 = 'Value 1 goes here'

Data Query Language (DQL)

Another subcategory of the SQL language commands is the Data Query Language or simply DQL. This subset of SQL is used to retrieve data from a database.

SQL SELECT

The SQL SELECT command is used to query data from one or multiple database tables and/or views. Here is how to select all records from a table:

SELECT * FROM Table1

Data Definition Language (DDL)

The Data Definition Language or DDL is a SQL subset used to deal with database object creation, modification, and deletion.

SQL CREATE TABLE

SQL CREATE is used to create database objects like table. Here is an example:

CREATE TABLE Table1 
(
  Field1 VARCHAR (255),
  Field2 VARCHAR (255)
)

SQL DROP TABLE

Here is how to delete a database table:

DROP TABLE Table1

SQL WHERE Clause

The SQL WHERE clause is used to limit the number of rows that you are retrieving or manipulating. Here is how to select only rows that have the value 'Value 1 goes here' from the table Table1:

SELECT * FROM Table1
WHERE Field1 = 'Value 1 goes here'

SQL JOIN Clause

The JOIN SQL clause is used to select data from multiple tables and/or views. Here is how to use SQL JOIN, to select data from 2 tables that have common fields:

SELECT Table1.Field1, Table2.Field3 
FROM Table1
JOIN Table2
ON Table1.Field1 = Table2.Field1

Conclusion

In conclusion database development is an exciting career field and learning basic SQL is the first step towards your goal to become a great database developer or database administrator.