The course describes the methodology that can be used for solving various performance problems related to Oracle® SQL – more specifically the 11g version.
The course deals with concepts of relational and object-relational databases and powerful programming language Oracle SQL.
The course is an introduction to the Oracle PL/SQL procedural language. The language version used in DBMS 11g is considered in this training.
The course offers a more detailed study of the procedural language Oracle PL/SQL. During the course we explain how to use the PL/SQL stored objects of Oracle DBMS (procedures, functions, packages, triggers), which offer powerful possibilities to create business logic in Oracle based applications. New features of 10g version are discussed as well.
This training covers the new features in Oracle versions 18.104.22.168, 22.214.171.124 that are useful for developers: pluggable databases and containers, partitioning, indexing, flashback enhancements, new SQL and PL/SQL features.
This training offers an introduction to SQL and helps participants develop the necessary skills for searching and modifying data in SQL databases. It is aimed at developers, analysts and other specialists who need to learn SQL basics.
This is an introductory course that covers the basics of data warehouse.