|
|
|
 |
O8iSQLIntroduction to Oracle8i: SQL
The course acquaints with concepts of a relational and objective-relational database, acquaints with possibilities of language SQL. Students of this course will learn to create and accompany with database objects and learn, how storage, sampling and data processing is organized. Practical exercises allow to apply the received knowledge.
the Purposes of course
To explain concepts of a relational and objective-relational database
To fulfil inquiries, an insert, upgrade and deleting of the data
To create and accompany with database objects
To control transactions
To control access of users to the data
To use main SQL*Plus
Developers of applications
Managers of databases
Systems analysts
Experts on technical support
Necessary preliminary preparation:
Acquaintance to concepts and methods of data processing
Is desirable to have an operational experience with graphics user interface (GUI)
The program of course:
- Introduction
- Stages of design cycle of system
- Discussion of theoretical, conceptual and physical aspects of a relational database
- Handle of a relational database with the help of a relational database management system (RDBMS)
- Implementation relational (RDBMS) and objective-relational (ORDBMS) data base management systems
- Main commands of language SQL
- Possibilities of Select command
- Simple Select command
- Distinctions between SQL commands and SQL*Plus
- Criteria of sampling and sorting of the data
- Limitation of the strings selected by inquiry
- Sorting of the strings selected by inquiry
- One-line functions
- the Types of functions used in language SQL
- Usage of character, numerical functions, Functions of processing of dates in SELECT
- Sampling of the data from several tables
- SELECT Commands on sampling the data from several tables
- the Cartesian product
- Four various such as connections of tables, their usage
- Examples of connections
- Aggregation the data with the help of group functions
- the Description of group functions
- Usage of group functions
- Splitting of strings into groups phrase GROUP BY
- Inclusion or exception of groups with the help of phrase HAVING
- Subrequests
- the Tasks decided with the help of subrequests
- As are fulfilled subrequests
- Types of subrequests
- Writing of one-line and multilower case subrequests
- the Subrequests returning a little bit столбцов
- Usage of the subrequests returning a little bit столбцов
- the Subrequests returning uncertain values
- Subrequests in phrase FROM
- Formatting of output data with help SQL*Plus
- Creation of the inquiries demanding input of values of variables
- Customization of SQL*Plus
- Creation and execution of batch files
- Saving of settings
- Data manipulation
- Commands of a data manipulation language (DML)
- the Insert of strings in the table
- Upgrade of table lines
- Deleting of strings from the table
- Handle of transactions
- Execution of transactions
- Integrity of reading, Obvious and implicit lockings
- Creation and support of tables
- the Description of main database objects
- Creation of tables
- Data types of version Oracle7 and data types of version Oracle8
- Change of definition of the table
- Destruction and renaming of tables, deleting of all table lines
- Addition of limitations of integrity
- Main data about оганичениях integrity
- Creation and support of limitations of integrity
- Creation of representations
- Representations and their usage
- Creation of representations
- Sampling of the data with the help of representations
- Insertion, upgrade and deleting of the data through representations
- Destruction of representations
- Change of definition of representation
- Inline Views
- Analyse most operators
- Other database objects
- Creation, support and usage of sequences
- Creation and support of indexes
- Creation of private and public synonyms
- Access control of users
- Concepts of users, roles and the privilege
- Allocation and selection of object privileges
- Creation of roles and allocation of privileges by him
- Creation of synonyms for simplification of access to tables
- the Practical work on language SQL
- Application of knowledge, Received on course
- Preparation for learning the subsequent courses on Oracle
For the further training courses are recommended:
Introduction in Oracle8i: Bases PL/SQL.
Education coast on cource - USD 750
Cource duration (days) - 3
|
|
