Korte beschrijving/Annotatie

This book describes what databases are and how they can be designed. The book also describes how to make queries with which the data in a relational database can be retrieved with the use of SQL.

Tekst achterflap

The first half of ‘Databases and SQL’ discusses what a database is, the essence of what a database management system is, the place of database technology in system development and the relational model on which relational databases are based. The book gives definitions of the concepts of the relational model, it shows the way a relational database is designed, how to verify the design of a relational database and how to implement a relational database with the use of SQL. The second half of the book shows how to retrieve data from a relational database with the use of queries. There are separate chapters for the development of queries with joins, for the use of GROUP BY / HAVING and for the use of subqueries. The use of subqueries is split up in a chapter for the use of subqueries without correlation, a chapter for the use of subqueries with correlation and a chapter that explains how [NOT] EXISTS can be used in subqueries for group-group comparisons.

Slogan/Promotie

The first half of ‘Databases and SQL’ discusses what a database is, the essence of what a database management system is, the place of database technology in system development and the relational model on which relational databases are based. The book gives definitions of the concepts of the relational model, it shows the way a relational database is designed, how to verify the design of a relational database and how to implement a relational database with the use of SQL. The second half of the book shows how to retrieve data from a relational database with the use of queries. There are separate chapters for the development of queries with joins, for the use of GROUP BY / HAVING and for the use of subqueries. The use of subqueries is split up in a chapter for the use of subqueries without correlation, a chapter for the use of subqueries with correlation and a chapter that explains how to use [NOT] EXISTS in subqueries for group-group comparisons.

Biografie

Ton de Rooij lectures in the field of information system development: business analysis, specifying requirements, data modelling, databases, SQL and Business Intelligence. In addition to that he is a consultant (Educom, www.educom.nl) in the field of information architecture, and makes analyses and designs for information systems. He has been involved in content management for transition projects (transition to a different software environment). If you want to know more about Ton de Rooij, please take a look at his author website, www.tonderooij.com.

Inhoudsopgave

The first half of the book deals with the functioning of a DBMS and the relational model and is based on the assumption that a relational design is created by converting an information model into a relational schema. Normalization is treated as a subject, but for composing a relational database design we do not use normalization. In the chapters 3, 4 and 5 you will find a full discussion of the relational model. Based on that we can evaluate whether a relational schema meets: • the requirements of the relational model • the requirements of a good relational database design. The second half of the book focusses on the composition of SQL-statements with which relational databases can be consulted and with which changes can be made in the content. We will extensively discuss strategies that help with the composition of queries. The book is modular. The chapters are organised in such a way that everything about a specific subject is kept together. In addition to that parts of the book can be studied separately.: • chapter 2 about database management systems • chapter 3-5 about the relational model • chapter 7-10 about composing queries ranging from very simple ones to very complex ones.

Details