Education

Education

 



PDF Print E-mail
Oracle Advanced PL/SQL Training

Oracle 11g PL/SQL Programming Workshop

Course has been prepared by author for Zurich Financial Services (www.zurich.com) and has been successfully read for Oracle specialists in Germany (Munich).
Duration of the course: 5 days
Dates of the course: June 18, 2012 — June 22, 2012
Training class UNiORA at Bucuresti 117
Trainer: Igor Duca, OCP (http://duca.at )
Price: 1375 US Dollars w/o VAT per student
Payment - prepayment in MDL - wire transfer - exchange rate to be fixed by BNM for the day of transfer
Location of the course : Training room of UNiORA: Alba Iulia 190/1 of 26 (KVINT building: across the street - Orange Moldova)
Language — Romanian or Russian (to be selected by students), terminology - English
Maximum number of students: 11.

Audience: PL/SQL Developers and Business Analysts, Database Administrators.

Prerequisites: You must possess some programming skills to benefit from this class. For students, who have experience in PL/SQL programming, this class will be especially useful. You will acquire skills to use PL/SQL more efficiently and get your code cleaner and clearer. Also, experience with a procedural language (e.g. Java, C or COBOL), SQL and SQL*Plus is required.

To enroll, please, register.

Read more
 
PDF Print E-mail
Schedule for the trainings in May, June 2009

18 May - 22 May 2009: Oracle 10G Database Administration
15 June - 19 June 2009: Oracle 10G Performance Tunning for Developers and DBAs

Oracle 10G Database Administration

The course has been prepared by Oracle Partner company Skillbuilders (U.S.) (www.skillbuilders.com )
Duration of the course: 5 days
Dates of the workshop: 18-May-2009 - 22-May-2009
Trainer: Igor Duca, OCP (http://duca.at)
Price: 1375 US Dollars w/o VAT per student, including books and lunch

Method of Payment - prepayment in MDL - wire transfer - exchange rate to be fixed by BNM for the day of transfer
Location of the course : Training room of UniORA: Alba Iulia 190/1 of 34, 35 (New KVINT building: across the street - Orange Moldova)
Language - Russian, terminology - English

Oracle 10G Performance Tunning for Developers and DBAs

The course has been prepared by Oracle Partner company Skillbuilders (U.S.) (www.skillbuilders.com )
Duration of the course: 5 days
Dates of the workshop: 15-June-2009 - 19-June-2009
Trainer: Igor Duca, OCP (http://duca.at)
Price: 1375 US Dollars w/o VAT per student, including books and lunch

Price: 1375 US Dollars w/o VAT per student, including books and lunch. Method of Payment

Read more
 
PDF Print E-mail
Oracle 10g SQL Tuning Training

Oracle10g SQL Tuning for Developers and DBAs


Learn to tune SQL statements with EXPLAIN PLAN, SQL Trace and TKPROF (and AUTOTRACE and CBO 10053 trace and Much More).

Your Oracle database has so much more to offer.

Have you learned about optimizer (CBO) features like bind variable peeking, histograms, dynamic sampling?

Do you know when hints should be used - and when they should not?

No? Then why expect your SQL statements to perform (and scale) well?

This hands-on course will provide you with the skills necessary to create scalable, high performance SQL-based Oracle applications (proactive SQL tuning). You will also learn how to identify existing high-load, poor performing SQL statements and tune them (reactive SQL tuning). Particular attention is paid to making the best use of Oracle architecture, bench-marking various SQL formulations and identifying the best schema object (e.g. heap table, IOT, etc.) for a given situation. Oracle10g introduces "automatic tuning" features such as the Automatic Workload Repository, Automatic Database Diagnostic Monitor and SQL Tuning Advisor. These features are covered in this class.

The course also includes a lesson on tuning PL/SQL programs. This includes using bulk processing and profiling to identify high-load statements.

Working examples are included throughout the course book. Students have access to electronic versions of all sample scripts and lab solutions. Approximately 50% of class time is spent on hands-on exercises.

As with all of our courses, this class is highly customizable to your specific training requirements. Hands-on workshops constitute approximately 50% of the class.

Read more
 
  • «
  •  Start 
  •  Prev 
  •  1 
  •  2 
  •  Next 
  •  End 
  • »


Page 1 of 2

Your are currently browsing this site with Internet Explorer 6 (IE6).

Your current web browser must be updated to version 7 of Internet Explorer (IE7) to take advantage of all of template's capabilities.

Why should I upgrade to Internet Explorer 7? Microsoft has redesigned Internet Explorer from the ground up, with better security, new capabilities, and a whole new interface. Many changes resulted from the feedback of millions of users who tested prerelease versions of the new browser. The most compelling reason to upgrade is the improved security. The Internet of today is not the Internet of five years ago. There are dangers that simply didn't exist back in 2001, when Internet Explorer 6 was released to the world. Internet Explorer 7 makes surfing the web fundamentally safer by offering greater protection against viruses, spyware, and other online risks.

Get free downloads for Internet Explorer 7, including recommended updates as they become available. To download Internet Explorer 7 in the language of your choice, please visit the Internet Explorer 7 worldwide page.