Название: SQL For Beginners: A Step-by-Step Guide to Learn SQL (Structured Query Language) from Installation to Database Management and Database Administration
Автор: Julian James McKinnon
Издательство: Amazon.com Services LLC
Год: 2020
Страниц: 191
Язык: английский
Формат: pdf (conv), rtf, epub
Размер: 10.1 MB

Learn SQL (Structured Query Language) from Installation to Database Management and Database Administration. Anything that stores data records is called a database. It can be a file, CD, hard disk, or any number of storage solutions. From a programming point of view, a database is a methodically structured repository of indexed data information that can be easily accessed by the users for creating, retrieving, updating and deleting information. Data can be stored in many forms. Most applications require a database for storing information.

A database can be of two types:

(1) flat database and (2) relational database.

As the name suggests a flat database has a two-dimensional structure that has data fields and records stored in one large table. It is not capable of storing complex information, which creates a need for relational databases. A relational database stores data in several tables that are related to each other.

SQL is a computer language we can use to work with the various database management systems. It is the standard language for the various relational database management systems such as Oracle, MySQL, MS Access, SQL Server, Postgres, Sybase, etc. With the use of SQL, a database user can create various database objects and perform various manipulations on them.

When they have accomplished the tasks, they were using the objects for, the users can drop these database objects. A good example of a database object is a table which is a combination of rows and columns. Tables allow us to group our data into rows and columns. SQL allows you to create a table, insert data into it, manipulate this data and even drop it when you are done with its use. Besides this, SQL allows you to impose constraints on the table to restrict the data that can be inserted into that table.

You must have data you need to store well. The data should be safeguarded against loss. If the data is sensitive, you need to safeguard it so it doesn’t land into the wrong hands. You also need a way of organizing this data so it becomes easy for you to retrieve it. You only need to get a database management system and SQL will help you achieve all of this. This book is an excellent guide for you to learn SQL. It explores everything about this computer database language.