PHP - Oracle

• Dauer:
  1 Tag
• Zeit:
  10:00 - 16:00
• Lieferart:
  Online
• Zielgruppe:
  Programmers, Web developers
• Vorkenntnisse:
  PHP Basics
• Methode:
  Lecture with examples and exercises.
• Erfahren Sie in der Demo mehr darüber, wie Online-Kurse durchgeführt werden.
• Kursnummer:
  2022975
• 
  Themen:
  This PHP Oracle training is for PHP programmers developing applications for Oracle Database. It bridges the gap between the world of PHP and the universe of Oracle and shows how to use the PHP scripting language with Oracle Database. This training gives you the fundamental building blocks needed to create high-performance PHP Oracle Web applications.

Connecting to Oracle Using OCI8 - Connection Types - Connection and Environment Errors - Transactions and Connections - Authorization and Authentication - Executing SQL Statements With OCI8 - Fetch Functions - Insert, Update, Delete, Create and Drop in PHP OCI8 - PHP Error Handling - Using Bind Variables in Prepared Statements - Improving Performance by Prefetching and Caching - Monitoring OCI8 SQL Statements - LIMIT, Auto-Increment, Last Insert ID and Multiple Inserts

Connecting to Oracle Using PDO - Executing SQL Statements - Using Bind Variables in Prepared Statements - Transactions - PL/SQL-Integration in PDO

PL/SQL Overview - Blocks, Procedures, Packages and Triggers - Using PL/SQL With OCI8: Calling PL/SQL Code, Array Binding and PL/SQL Bulk Processing, Using REF CURSORS for Result Sets, Oracle Collections in PHP, Using PL/SQL and Oracle Object Types in PHP, Getting Output With DBMS_OUTPUT, PL/SQL Backtraces in a PL/SQL Exception Handler

Working With LOBs in Oracle and PL/SQL - Inserting and Updating LOBs - Fetching LOBs - Temporary LOBs - Uploading and Displaying an Image - Working With BFILEs

Fetching Relational Rows as XML - Fetching Rows as Fully Formed XML - Using the SimpleXML Extension in PHP - Fetching XMLType Columns - Inserting Into XMLType Columns - Fetching an XMLType from a PL/SQL Function - XQuery XML Query Language

Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling in XML, shortly before any of the current Semantic Web standards had been adopted. He started working as a lecturer and consultant in 2002.

Veröffentlichungen

• "PHP und OOP" (Comelio Medien, ISBN 978-3-939701-01-9)
• "PHP und XML" (Comelio Medien, ISBN 978-3-939701-00-2)
• "PHP und Oracle" (Comelio Medien, ISBN 978-3-939701-01-9)
• "Oracle PL/SQL" (Comelio Medien, ISBN 978-3-939701-40-8)
• "Oracle SQL" (Comelio Medien, ISBN 978-3-939701-41-5)
• "Oracle, PL/SQL und XML" (Comelio Medien, ISBN 978-3-939701-49-1)

Erfahrung: - He works as an IT-consultant and project manager. He developed various business applications with his team in India and is today mainly involved in Business Intelligence (Big Data, OLAP, Data Mining) projects. - He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Projekte: - He works as an IT-consultant and project manager. He developed various business applications with his team in India and is today mainly involved in Business Intelligence (Big Data, OLAP, Data Mining) projects.

Forschung: - He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Zertifizierung: - Marco Skulschus is "Microsoft Certified Trainer", “Oracle Associate” and passed the ComptiaCTT+ examination.

Bei der Anmeldung von mehreren Teilnehmern bieten wir Ihnen attraktive Rabatte an. Ab drei Teilnehmern kann sich ein Inhouse-Seminar bei Ihnen lohnen. Gern erstellen wir Ihnen ein individuelles Angebot.
Alle Preise zuzüglich der gesetzlichen Mehrwertsteuer.