SQL Bootcamp: Learn the Basics of SQL Programming in 2 Weeks (2016)

Chapter 1. SQL - Basic Information

This book offers a unique teaching approach: it will help you learn the fundamentals of the SQL programming language in 2 weeks. Additionally, it will provide you with examples that can aid you in mastering this language immediately.

Basically, SQL is a computer language used in databases. It involves data rows, column modifications, and database generation.

SQL - Structured Query Language

SQL is a language that you can use to store, manipulate, and retrieve information stored inside a relational database.

This is considered as the standard computer language for RDSs (i.e. Relational Database Systems). Modern database systems such as MySQL, Oracle, Informix, Sybase, and MS Access utilize SQL as their standard language.

The Main Advantages Offered by SQL

SQL allows you to do the following:

· Access information within relational database systems.

· Add descriptions for the information you’ll store.

· Define and manipulate the data stored in your databases.

· Use other languages through its built-in libraries, pre-compilers, and modules.

· Generate and delete tables and databases.

· Generate, view, and store functions within your databases.

· Assign access rights on your tables and database objects.

How Does SQL Work?

Whenever you run SQL commands on a relational database management system, the system identifies the ideal way to process your request. Then, the SQL engine will interpret the activities involved.

The process outlined above involves different components. These are: Optimization Engines, Query Dispatcher, SQL Query Engine, and Classic Query Engine. The image below will show you the basic architecture of an SQL process:

The Commands That You Can Use in SQL

This section of the book will explain the basic SQL commands. Study this material carefully since it can help you learn SQL within 2 weeks.

According to expert programmers, the standard commands in SQL are SELECT, CREATE, UPDATE, DROP, DELETE, and INSERT. Let’s classify these commands according to their 'margin-bottom:21.65pt;text-align:justify;line-height: 18.0pt'>

The Data Definition Language (also known as DDL)

· CREATE– Generates a new object or table inside a database.

· ALTER– Edits existing objects within a database.

· DROP– Removes database objects.

The Data Manipulation Language (also known as DML)

· INSERT– Generates a new record in a database.

· UPDATE– Edits existing records in a database.

· DELETE– Removes existing database records.

The Data Control Language (also known as DCL)

· GRANT– Allows you to give access privileges to certain database users.

· REVOKE– Allows you to take back access privileges from certain users.

The Data Query Language (also known as DQL)

· SELECT– Allows you to retrieve records from your database.