Oracle. PL/SQL for beginners. The application of SQL and PL/SQL in the Oracle database (Q2756968)

The book gives an introduction to SQL and PL/SQL for Oracle database users and is subdivided into three equally weighted parts. The first shows the key concepts of databases and explains how to use Oracle's command-line interface SQL\(^*\)Plus to define, manage, and query Oracle databases with standard SQL. The second part explains advanced SQL query techniques like subqueries, view definitions, the usage of SQL functions to analyze grouped datasets, the application of indexes to improve query-performance, basic database modeling rules including data-integrity constraints, and how to manipulate and use further Oracle database objects like sequences, aliases or the Oracle Data Dictionary. The last part of the book introduces the reader to the built-in programming functionality of Oracle named PL/SQL. It gives a brief overview of the basic procedural programming constructs and how to use them to write procedures, functions, or triggers. The book concludes with a guide of how to connect to an Oracle database to standard applications via the Microsoft database interface ODBC.NEWLINENEWLINENEWLINEThe reader awaits a well written beginners guide on how to use Oracle databases in daily work. Throughout the book the lectures are presented from a practitioners view, and many suggestive examples illustrate and explain the contents with real-world tasks and problems in a motivating, non-academic way. This book is well suited to learn the overall usage of Oracle databases via SQL, but the parts which cover the programming facilities of Oracle with PL/SQL only present a rough and short overview of the main concepts and should be hard to comprehend for non-proficient users with no fundamental programming knowledge.