Learn how to work professionally with the Oracle databa

Anyone who wants to learn how to work professionally with the DBMS Oracle,

but do not know where to start!


Starting course for beginners, which will create a solid foundation for the successful development of the specialist expertise of any Oracle



If you are interested in this topic, it is likely that you have one of the following situations:




You are only at the beginning of his career in IT and have not yet decided on what will specialize. You often hear that Oracle - it´s cool, and Oracle specialists without work bored and earn good money. You´ve already spent a lot of time online, visiting a variety of resources, forums and blogs. There you will find the discussion of how to write a SQL query, the installation instructions for a few pages, links to documents in English. As a result of all these fragmentary information does not add up in your big picture.

It is clear that Oracle - is large and complex system, which suddenly will not do. To dispel any doubts, whether to devote this much time and effort, it would be nice to get a comprehensive view of what Oracle and how it works.

You decide you want to become a PL / SQL-programmer, designer database administrator or Oracle. You already know something in this field, but this information is scattered and fragmentary. You are at a crossroads: whether to delve into the study of language SQL, you whether PL / SQL, and maybe in the first place is given to the administration? How to obtain the basic knowledge to get you moving in the right direction?

You have several years of work IT-professionals involved in support of information systems, but to work with the Oracle had ever. Your company begins implementation of the information system, the core of which is the database Oracle. Outside the organization that implements the system terminates. A separate Oracle administrator position is not, and you fall down on the task of support and maintenance of the system.

You - the programmer already established, such as Delphi or C #, but have always worked with Microsoft SQL Server. When you are thinking about changing jobs, we saw that in the position that you are interested, requires the ability to work with the DBMS Oracle. You need to quickly learn to work with Oracle on your primary programming language, as well as the basic level of programming in PL / SQL dialect and specificity of Oracle SQL.


What types of facilities has a database Oracle?

As stored PL / SQL code in the database?

How to implement transactions in Oracle?

How is the performance of SQL statements?

As the data is physically stored in Oracle?

What are the logical storage structures?

What is an instance of Oracle?

As an administrator manages an instance?


The course consists of 47 lessons grouped into 5 modules:


Module №1 - Relational data structures Oracle

This module covers all the main types of schema objects that are used by virtually every database Oracle. Details considered constraints that play an important role in the implementation of the relational data model.


Module №2 - programming languages \u200b\u200bSQL and PL / SQL

The purpose of this module - to acquaint with SQL and PL / SQL. Along with an overview of SQL-operators themselves in the classroom shows the stage of the statement by sending it to the user the result. In the second part of the module describes software units PL / SQL, which can be implemented using a complex business application logic on the server side.


Module №3 - Transaction Management

This module reveals one of the most important issues - the transaction to Oracle. Since the implementation of the transaction is different from other Oracle database, this module will be useful for those who already have experience with other databases.


Module №4 - storage structures

The fourth module describes which files is any database, what is the function of