CD - Practices for database systems [Karol Matiaško, Michal Kvet, Marek Kvet] | edis.uniza.sk

CD - Practices for database systems
Karol Matiaško, Michal Kvet, Marek Kvet

CD - Practices for database systems

ISBNcena v €cena v Sks 10% DPH
978-80-554-1397-62.2066.28

Kód výrobku: 401514

zaradenie publikácie: Študijná literatúra

roky vydania: 2017

Anotácia

We have just prepared the first edition of the book for people with the goal to increase practical knowledge and skills in the area of Database systems. The content and labs of the  textbook are prepared under our experiences with the education  of Database systems in our university. From time to tim, we perceive that students, researchers or practitioners have problems with the correct way  of using Database systems during the implementation processes into any information systems. This book was written for strudents  and practitioners. It is intended as a practical guide for them and for others developers to involve the analysis, design, and implementation of commercial information systems. The language and diagram cenventions aplly ANSI standards with the strength of the Oracle Database Systems and the Toad data modeler. We suppose that reader can recognize that using database systems and SQL is an important knowledge for the design process, with opportunities for choice and creativity.
      In the text, we propose a lot of  practical exercises highlighting the problems, solutions, tricks, and improvements.

Z obsahu

Preface
Introduction
Organization of the book
Lab 1  -  Preparing environment
Lab 2  -  Introduction to Linux and SQL
Lab 3 -  Select 1
PRACTICE
Lab 4  -  Insert, Update, Delete+transactions
PRACTICE
Lab 5  -  Data modelling
PRACTICE
Lab 6  -  Create, Alter, Drop
PRACTICE
Lab 7  -  Data loading                                                                                                                  
Lab 8  -  Grant, Revoke
PRACTICE
Lab 9  -  Select 2
PRACTICE
Lab 10 -  Procedures, functions, packages
PRACTICE
Lab 11 -  Triggers
PRACTICE
Lab 12 -  Relational integrity
PRACTICE
Lab 13 -  Views
PRACTICE
Lab 14 -   Select 3 - Date time value management
Lab 15 -  Data dictionary views
PRACTICE
Lab 16 -  Reports
Literature
Abbreviations
Index
Appendix 1
Appendix 2
Appendix 3
File management

Vyberte si
uptavka

Obchodné podmienky

Všetky práva vyhradené.
© 2010 EDIS vydavateľstvo ŽU

Konverzný kurz: 30.1260 Sk/€



Registracia | Zabudli ste heslo?

Nákupný košík obsahuje
0 položiek
0 € (0 Sk)


Vydavateľstvo EDIS odporúča:


Enviromentálne problémy sídelných útvarov

Enviromentálne problémy sídelných útvarov

Daniela Ďurčanská, Martin Decký, Dušan Jandačka, Eva Remišová
8,00SKLADOM

Elektromobilita

Elektromobilita

Michal Frivaldský a kolektív
39,00SKLADOM