Databases and SQL
design and retrieval with queries
Paperback EN 2025 1e druk 9789082888058Samenvatting
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.
Specificaties
Lezersrecensies
Inhoudsopgave
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.
Vaak samen gekocht
Anderen die dit kochten, kochten ook
-
R.P. Boeklagen€ 49,50 -
R. Boeklagen€ 64,50
-
R. Boeklagen€ 69,50
-
R. Boeklagen€ 34,50
-
R. Boeklagen€ 49,50
-
R. Boeklagen€ 69,50
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan