SQL For Beginners: A Step-by-Step Guide to Learn SQL (Structured Query Language) from Installation to Database Management and Database Administration - Couverture souple

McKinnon, Julian James

Couverture souple

ISBN 10 : 1801235031 ISBN 13 : 9781801235037

Editeur : DM Publishing, 2020

Synopsis

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 w, 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.


Let's take the example of a school.


A school will have to maintain data for several students. To find information for a student, we will first ask the class name. After the class name, we will ask for the first name. However, if there are two children with the same first name, then we will ask for the surname.


If there are two children will identical names, we can still discriminate the information related to them based on their student id, parents' name, date of birth, siblings in the same school, etc.


This is all related information. When all of this information is stored on paper, it takes a lot of time to retrieve it. The relational database allows easy access to all of this information.


SQL is a computer language we can use to work with the various database management systems.

Détails de l'édition

• Éditeur: DM Publishing
• Date d'édition: 2020
• ISBN 10: 1801235031
• ISBN 13: 9781801235037
• Reliure: Broché
• Langue: anglais
• Nombre de pages: 204
• Coordonnées du fabricant: non disponible