O9i-INTROIntroduction to Oracle9i
This course can be for a good starting point in the program of preparation of managers of database servers Oracle9i and developers of applications of databases. Common concepts, bases of structured query language SQL, programming language PL/SQL are stated, questions of differentiation of the rights, object extensions of relational data model are considered. The course acquaints with a diversity of possibilities of database server Oracle9i After learning course you can - understand the architecture of server Oracle9i;
- to apply predefined types of the data;
- to customize and use utility SQL*Plus;
- to configurate and apply iSQL*Plus;
- to write inquiries in language SQL;
- to use different types of connection of tables (JOIN) in inquiries SELECT;
- to apply subrequests;
- to receive the information from the data dictionary (data dictionary);
- to build simple reports, using utility SQL*Plus;
- to differentiate data access;
- to update the data by means of operators of a data manipulation language (INSERT, UPDATE, DELETE);
- to apply COMMIT operator to completion of transaction;
- to apply ROLLBACK operator to rollback of transaction;
- to use savepoints (savepoint);
- to understand the mechanism of lockings;
- to use SQL*Loader for loading the data;
- to apply intrinsic functions;
- to use operations from the theory of sets for a combination of inquiries (UNION, etc.);
- to create, delete and update objects of various types, using, operators of a data definition language (DDL);
- to apply various types of indexes;
- to use language PL/SQL;
- to apply cursors at programming on PL/SQL;
- to create stored procedures and packages of stored procedures.
the Contents of course - Introduction.
- Programming on SQL.
- Usage of the data dictionary.
- Utility SQL*Plus.
- Learning of a data manipulation language (Data Manipulation Language).
- Usage of functions SQL.
- More complex concepts SQL.
- Objects of databases.
- Indexes.
- the New possibilities which have come from standard ANSI.
- Introduction in methods and resources of differentiation of access iSQL*Plus.
- Introduction in programming in language PL/SQL.
- Controlling constructions.
- Operation with cursors.
- Procedures and functions.
- Packages.
- Overload (overloading.)
Students Systems analysts, developers, designers, managers and staff of services of support. Preliminary preparation Is recommended to have experience in the field of data processing and programming.
Education coast on cource - USD 734 Cource duration (days) - 5
|