Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Structured Query Language (SQL): a Practical Introduction

Buy
Let's start from basics. What is a database? In very general terms, a database is a collection of related data. Notice the word related, this implies that the collection of letters on this page do not by themselves constitute a database. But if we think of them as a collection of letters arranged to form words, then they can be conceptualised as data in a database. Using similar reasoning, we can also say that a tome such as a telephone directory is also a database. It is a database first, because it is a collection of letters that form words and second, because it is an alphabetical listing of people's names, their addresses and their telephone numbers. How we think of a database depends on what use we want to make of the information that it contains.

So far, we have talked about a database in it's broadest sense. This very general definition is not what most people mean when they talk about a database. In this electronic age, the word database has become synonymous with the term "computerised database". Collins English Dictionary describes a database as "A store of a large amount of information, esp. in a form that can be handled by a computer." In this book, we will be dealing only with computerised databases. In keeping with popular trend though, we will be using the word database to refer to a computerised database.

A database (computerised database remember) by itself, is not much use. The data is stored electronically on the computer's disk in a format which we humans cannot read or understand directly. What we need is some way of accessing this data and converting it into a form which we do understand. This is the job of the database management system or DBMS for short. A DBMS is essentially a suite of programs that act as the interface between the human operator and the data held in the database. Using the DBMS, it is possible to retrieve useful information, update or delete obsolete information and add new information to the database. As well as data entry and retrieval, the DBMS plays an important role in maintaining the overall integrity of the data in the database. The simplest example of is ensuring that the values entered into the database conform to the data types that are specified. For example, in the telephone book database, the DBMS might have to ensure that each phone number entered conforms to a set format of XXX-XXXXXXX where X represents an integer.
(HTML tags aren't allowed.)

Yoghurt: Science and Technology, Second Edition
Yoghurt: Science and Technology, Second Edition

Yoghurt: Science and Technology is a standard work in its field for both industry professionals and those involved in applied research. Because manufacture is still, essentially, a natural biological process, it remains difficult to control the quality of the final product. Such control depends on a thorough understanding of the nature of...

Linear Algebra and Probability for Computer Science Applications
Linear Algebra and Probability for Computer Science Applications

Based on the author’s course at NYU, Linear Algebra and Probability for Computer Science Applications gives an introduction to two mathematical fields that are fundamental in many areas of computer science. The course and the text are addressed to students with a very weak mathematical background. Most of the...

Learning Perl, Second Edition
Learning Perl, Second Edition
Among other things, this book is about 260 pages long. It is also a gentle introduction to Perl. By the
time you've gone through this book, you'll have touched on the majority of the simpler operations and
common language idioms found in most Perl programs.

This book is not intended as a comprehensive guide to Perl; on the
...

Shatnerquake
Shatnerquake

It's Shatner VS Shatners!

William Shatner? William Shatner. WILLIAM SHATNER!!! It's the first ShatnerCon with William Shatner as the guest of honor! But after a failed terrorist attack by Campbellians, a crazy terrorist cult that worships Bruce Campbell, all of the characters ever played by William Shatner are...

Taste and Smell: An Update (Advances in Oto-Rhino-Laryngology, Vol. 63)
Taste and Smell: An Update (Advances in Oto-Rhino-Laryngology, Vol. 63)

Chemosensory dysfunction is a quite frequently occurring problem which significantly affects the patient's quality of life. It can result from infectious agents, environmental factors, toxins, traumatic brain injuries, as well as neurodegenerative diseases. This publication provides up-to-date articles on the chemical senses including the...

Making Use of Python
Making Use of Python

A step-by-step guide on how to use Python for CGI scripting, GUI development, network programming, and much more!

Organizations such as NASA, Hewlett-Packard, and Xerox have already discovered the power that Python has to offer. This multipurpose development language can be used on virtually every platform, from Windows and Linux...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy