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.)

Professional Ajax, 2nd Edition (Programmer to Programmer)
Professional Ajax, 2nd Edition (Programmer to Programmer)
Professional Ajax 2nd Edition provides a developer-level tutorial of Ajax techniques, patterns, and use cases. The book begins by exploring the roots of Ajax, covering how the evolution of the web and new technologies directly led to the development of Ajax techniques. A detailed discussion of how frames, JavaScript, cookies, XML, and XMLHttp...
CompTIA A+ Exam Prep (Exams A+ Essentials, 220-602, 220-603, 220-604)
CompTIA A+ Exam Prep (Exams A+ Essentials, 220-602, 220-603, 220-604)
This book covers every skill measured by the latest A+ Exams including:
  • Understanding all essential PC terminology, concepts, internal components, and peripherals
  • Installing, upgrading, configuring, and optimizing PC components
  • Troubleshooting hardware and performing essential preventive maintenance
  • ...
Beginning SharePoint Communication Sites: Creating and Managing Professional Collaborative Experiences
Beginning SharePoint Communication Sites: Creating and Managing Professional Collaborative Experiences
Understand SharePoint communication sites and create one on your own using SharePoint Home available in Office 365. This beginner's book will advise you about the ways to integrate your existing collaboration channels with SharePoint communication sites. Along the way you will see how to embed documents, videos, and real-time data...

Pro Spring MVC with WebFlux: Web Development in Spring Framework 5 and Spring Boot 2
Pro Spring MVC with WebFlux: Web Development in Spring Framework 5 and Spring Boot 2

Explore the designs of the Spring MVC and WebFlux frameworks, and apply similar designs and techniques to your own code. Along with detailed analysis of the code and functionality, this book includes numerous tips and tricks to help you get the most out of Spring MVC, WebFlux, and Java-based web application development in general...

Networking All-in-One For Dummies
Networking All-in-One For Dummies

The ultimate reference guide for network administrators

Network administrators now have a single, convenient place to turn for all the information they need. Networking All-in-One For Dummies, 4th Edition is like ten books in one, covering such topics as networking basics, network security, setting...

Handbook of Nanostructured Materials and Nanotechnology, Five-Volume Set, Volume 1-5
Handbook of Nanostructured Materials and Nanotechnology, Five-Volume Set, Volume 1-5

Nanostructured materials is one of the hottest and fastest growing areas in today's materials science field, along with the related field of solid state physics. Nanostructured materials and their based technologies have opened up exciting new possibilites for future applications in a number of areas including aerospace, automotive, x-ray...

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