PL SQL Course

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
Post Reply
mineiro
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 7
Joined: Fri, 01 May 2009 7:53 pm
Location: são paulo

Hello ..

Can anyone tell me where I can find a good course in PL SQL in São Paulo / SP?

Thanks.
User avatar
stcoutinho
Moderador
Moderador
Posts: 850
Joined: Wed, 11 May 2011 5:15 pm
Location: são Paulo - SP

Mineiro,

If you want official courses, Oracle University has a teaching trail focused on PL / SQL developers. In the case of beginners, Oracle recommends these 2 courses:

Oracle Database: Program WITH PL / SQL
Oracle Database 11g: Advanced PL / SQL

99] More details on these two official courses, you can find in this link: http://education.oracle.com/pls/web_pro ... &path=DBPS
But I do not know what your level of knowledge of SQL Oracle. If you still do not know (or know very little), I would recommend that before these two you took an Oracle SQL course, such as "Oracle Database: Introduction to SQL".

About teaching institutions in São Paulo, I could recommend for you the courses offered by Oracle representatives such as en-sofa, Senac or Veris (former IBTA). It may be that some of these institutions offer weekend courses.

If your technical English is OK, Oracle University also offers e-kits, through which you can study at home without having to come to Sampa. Further details on these kits can be obtained from the link: http://education.oracle.co.uk/html/orac ... D_MP_7.htm
As you can see, I only relocated to you the courses and official Oracle materials. I believe there are other (unofficial) educational institutions that offer courses in this area at a more affordable price. Maybe the forum colleagues can indicate some for you.

Hugs and Welcome to the PL / SQL world.

Sergio Coutinho
User avatar
stcoutinho
Moderador
Moderador
Posts: 850
Joined: Wed, 11 May 2011 5:15 pm
Location: são Paulo - SP

Miner,

I forgot to mention one thing: if you wish to study for your own, there is an excellent book of PL / SQL in Portuguese:


Despite being Oracle 9i, this book allows you to develop complex PL / SQL programming logics. I would say Que is an "honest" technical book where you really learn to develop complex programs. Just read the chapters and do the exercises.

You can find and order it by the culture bookstore.

Hugs,

Sergio Coutinho
marcus.kobel
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 45
Joined: Thu, 12 May 2011 4:54 pm
Location: Porto Alegre - RS

I think you have courses at PUC-RS by Oracle Academy, but also has Target Trust.
I recommend Target Trust. I took SQL, PL / SQL and ADM in BD Oracle and the guys are beasts.
mineiro
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 7
Joined: Fri, 01 May 2009 7:53 pm
Location: são paulo

Actually I am a layman in the subject, I have knowledge in Oracle EBS in the air modules, AP, CE and I want to leave for the knowledge of the structure in the language of the bank and then try a vacancy as a functional consultant.

This book "Oracle 9i - PL / SQL programming" that informed me covers basic knowledge to advanced?

Buying this book as faço to steal the practical part, has some .exe of the plsql?, There are tests for tests to the similar so that I can study?

Thanks.
User avatar
stcoutinho
Moderador
Moderador
Posts: 850
Joined: Wed, 11 May 2011 5:15 pm
Location: são Paulo - SP

Hello Mineiro,

The book would be good and would teach you to program in PL / SQL. He would be beyond BE-A-Bá, presenting some programming techniques.

However, I suggest you do an Internet search to see if you can download this book or find free material about PL / SQL and SQL. I believe that in Glufke has an area where some interesting study materials are offered.

Another suggestion I make you call for the culture bookstore and book (without buying, okay?) This book, asking to deliver him in the store closest to you.

You can remove the book into the ordering section and sit somewhere to analyze the book. If you find him interesting, then buy.

Oracle EBS involves a series of technologies beyond PL / SQL. You also have Oracle Forms, which has an extended PL / SQL. But it may be even interesting to start by SQL and then start for PL / SQL.

If you want to follow the functional career, I would not recommend taking Oracle's official course on database administration. But if it is important to have an overview, look for an unofficial course that gives you a mini overview on database. I think Veris offers a compact DBA course. See their website.

On the official courses, if it is valid, then do the SQL or PL / SQL. These courses will not make you expert, but it will be a starting point for you to study on your own.

Maybe the forum colleagues can give other tips, based on the information you posted in your last comment.

Hugs,

Sergio
User avatar
stcoutinho
Moderador
Moderador
Posts: 850
Joined: Wed, 11 May 2011 5:15 pm
Location: são Paulo - SP

Mineiro,

See the Glufke The Tutorial / Handouts forum.

has much material in Portuguese there and even copy of books.

About what I told you about culture, when a book interests me, I usually visit the bookstore and even book books if they are not in stock. And only after taking a veneer, I choose to buy or not.

Hugs,

Sergio
bertosro
Rank: Analista Júnior
Rank: Analista Júnior
Posts: 88
Joined: Fri, 18 Aug 2006 11:13 am
Location: São Paulo - SP
Bertosro
MSN / TALK - roberto.fernandes@gmail.com

In this school has PL course http://www.ittraining.com.br
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest