PRACTICES FOR DATABASE SYSTEMS [Karol Matiaško, Michal Kvet, Marek Kvet] | edis.uniza.sk

PRACTICES FOR DATABASE SYSTEMS
Karol Matiaško, Michal Kvet, Marek Kvet

PRACTICES FOR DATABASE SYSTEMS

ISBNcena v €cena v Sks 10% DPH
978-80-554-1396-923.44706.15

zaradenie publikácie: Študijná literatúra

roky vydania: 2017

Anotácia

INTRODUCTION

     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.

ORGANIZATION OF THE BOOK

     The textbook itself is divided info seven parts organized into sixteen chapters. Besides the Introduction where  we described the aims, prerequisites and necessary environment for the correct work with the Database system, following parts can be recognized:

     °    Data Manipulation Langauge (DML),
     °    Data modeling,
     °    Data Definition Language (DDL),
     °    Advanced  SELECT statements,
     °    PL/SQL introduction
     °    Data integrity (DI),
     °    Additional SQL extension

     Each chapter contains the short description of the theory, examples, and tasks for the evaluation  of the received knowledge.
     During the lab 1, we enclosed the documentation:

     °    for the installing and preparing the Database system Oracle,
     °    for the work under oparating sytem Linux  and
     °    first examples of the verification of the functionality.

     In the sections highlighting the DML statements, also the first attempts with SELECT statements are included with detail description of the INSERT, DELETE and UPDATE statements.
     Next part is reprosented by the fifth  chapter characterizing independent part with all necessary knowledge about  data modelling.
     The part DDL includes details about Data Definition Language. Data types, Data Access statements and about importing and exporting data to and from the database.
     Advenced SELECT statements part inclides a description of the aggregate functions and  their  management, fundamentals for Group  By clause  management and table joining options.
     Procedural extension of the  SQL language is covered  by the lab 10 dealing with procedures, functions, and packages. It also deals with  Select statement management  in blocks, exception handling and details about work with methods, triggers and cursors.
     The part about the data integrity offers  the rules to keep the database in correct and  consistency  state. This part contains information about work with views and their influence on the data integrity, as well.
     Last part extends the practical knowledge and skills related to the work with temporal  data types and reports covered by the data dictionary.
     At the end, we added  the Appendix with  three models for the practices and for the verification  of embedded examples and tasks.
     We believe that this textbook will be a useful document  for gaining theoretical and practical knowledge with contemporary database systems.









Z obsahu

Preface

     Introduction
  
     Organization of the book

Lab 1  -  Preparing environment
     1.1   Introduction
     1.2   Installing Oracle Database Express Edition
    
1.3   Creating user account
    
1.4   Privileges
     1.5   Data import
     1.6   Putty
     1.7   SQL developer environment
     1.8   Winscp
     1.9   Toad Modeler
Lab 2  -  Introduction to Linux and SQL
     2.1   Linux/UNIX
     2.2   Sqlplus
     2.3   Sytax symbols
Lab 3 -  Select 1
     3.1   Introduction
     3.2   Projection, selection, column alias
     3.3   Using functions
     3.4   Managing NULL values
     3.5   Comparing strigs (equality, operator Like)
     3.6   Using Order By clause
     3.7   JOIN
     3.8   Cartesian product
     3.9   SETs operations (IN,EXISTS)
     3.10  Managing duplicate values
     3.11   Table alias
Lab 3  -  Select 1
PRACTICE
Lab 4  -  Insert, Update, Delete+transactions
     4.1   Introduction
     4.2   Insert statement
     4.3   Update statement
     4.4   Delete statement
     4.5   The order of operations
     4.6   Foregn key definition
     4.7   Changing primary key value
     4.8   Transactions
Lab 4  -  Insert, Update, Delete+transactions
PRACTICE
Lab  5  -  Data modelling
     5.1    Introduction
     5.2    Creating data model
     5.3    Conceptual modeling
     5.4    Entity- relational (E-R) conceptual model
     5.5    Conceptual schema notation in E-R model
     5.6    Type diagram/Occurrence E-R diagram
     5.7    Attributes
     5.8    Relationships and  integrity constraints
     5.9    Data modelling in Toad modeler tool   
PRACTICE
Lab  6  -  Create, Alter, Drop
     6.1     Introduction                                                                                                                             6.2    Data types
     6.3    User managemen                                                                                                                    6.4    Table management
     6.5    Index
Lab  6  -  Create, Alter, Drop
PRACTICE
Lab  7  -  Data loading                                                                                                                  7.1   Introduction
Lab 8  -  Grant, Revoke
     8.1   Introduction
     8.2   Grant
     8.3   Accessing another schema object
     8.4   Revoke
     8.5   Grouping privileges to roles
Lab 8  -  Grant, Revoke
PRACTICE
Lab 9  -  Select 2
     9.1    Introduction
     9.2    Aggregate functions
     9.3    Fundamentals for Group  By clause management
     9.4    Working with aggregate function Count and Group By clause
     9.5    Having clause
     9.6    JOIN (extended versions)
     9.7    Relational algebra operations
     9.8    Recursive relationships
     9.9    Using the same table multiple times in Select statement
Lab 9  -  Select 2
PRACTICE
Lab 10 -  Procedures, functions, packages
     10.1   Introduction
     10.2   Code preliminaries
     10.3   PL/SQL anonymous block
     10.4   Procedure, function
     10.5   Executing stored method
     10.6   Calling function from the Select statement
     10.7   Exception handling
     10.8   Ways of passing parameters
     10.9   Differences between anonymous and stored (named) PL/SQL block
     10.10 Removing procedures and functions
     10.11 Select statement in PL/SQL
     10.12 Increasing control-access rights
     10.13 Packages
Lab 10 -  Procedures, functions, packages
PRACTICE
Lab 11 -  Triggers
     11.1   Introduction
     11.2   Syntax
     11.3   Restrictions for trigger definition
     11.4   Triggers turning on and definition
     11.5   Changes monitoring
     11.6   Default values
     11.7   Conditions for trigger firing
     11.8   One trigger - multiple operations
     11.9   Referential integrity management
     11.10 Changing value of the primary key
     11.11 Sequences and triggers
     11.12 DDL triggers
     11.13 Event triggers    
Lab 11 -  Triggers
PRACTICE
Lab 12 -  Relational integrity
     12.1   Introduction
     12.2   Integrity constraints classofication
     12.3   Entity integrity
     12.4   Referential integrity
     12.5   User integrity
     12.6   Column integrity
     12.7   Domain integrity
     12.8   Integrity constraints controlling processing
Lab 12 - Relational integrity
PRACTICE
Lab 13 -  Views
     13.1   Introduction
     13.2   Syntax
     13.3   Exceptions
     13.4   Managing data in views
     13.5   Atrtribute name redefinition in views
     13.6   Check option clause
     13.7   Read only view
     13.8   View based on multiple tables and triggers
     13.9   Summary
Lab 13 -  Views
PRACTICE
Lab 14 -   Select 3 - Date time value management
     14.1   NLS parameters & session format
     14.2   Transformation of the personal_id into date of birth
     14.3   Get the list of persons, who celebrate birthday today
     14.4   Get the list of students, who passed exam this month
     14.5   Get the list of student, who passed exam previous last month
     14.6   Get the list of the npersons, who will celebrate birthday next Sunday
     14.7   Get the Date of the second Sunday of the month
     14.8   Get the list of the persons, who will celebrate birthday next  week
     14.9   Get the difference betwen Date values
     14.10 Get the betwen Date values - sophisticated solution
     14.11 YY vs. RR
     14.12 Actual employees
     14.13 Period models and Allen relationships
     14.14 Unlimited validity definition
     14.15 Data type Interval management
Lab 15 -  Data dictionary views
     15.1   Introduction
     15.2   Data dictionary - strcture
     15.3   Querying data dictionary
Lab 15 -  Data dictionary views
PRACTICE
Lab 16 -  Reports
    16.1   Overwiev
    16.2   Enviroment
    16.3   Filtering, sorting
    16.4   Hidden columns
    16.5   Binding multiple reports - Master - Child
    16.6   Graph reports
    16.7   Pie graph type reports
    16.8   Line type reports
    16.9   Three dimensional (3D) graph types
    16.10 Binding multiple reports of various types
    16.11 Exports
    16.12 Script format (Insert)







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:


Ako veci vidíme

Ako veci vidíme

Ivan Turek
11,00SKLADOM

Manažment podnikov v železničnej doprave 2

Manažment podnikov v železničnej doprave 2

Eva Nedeliaková, Ivan Nedeliak
14,75SKLADOM