Programming

Oracle Database Administration Fundamentals II is the third in a series of four courses covering Oracle Certification course #1Z0-032, and more. Like the other courses in this series of Oracle Certification titles, this course teaches and demonstrates by example using thoroughly tested examples. In this course, instructor Gavin Powell covers Oracle Net Services, Backup and Recovery including RMAN, Oracle Enterprise Manager, Transportable Tablespaces and SQL*Loader. In addition, there are small sections introducing other Oracle optional features such as Standby databases (both Logical and Physical) plus Replication (both traditional and using Streams). Net Services covers architecture, connection configuration, listener configuration (from basics to connection profiling and load balancing), all the facts about connection strings and Oracle Net Services naming methods, even introducing some advanced features.

Virtual Training Company's Introduction to Oracle SQL and PL/SQL tutorial will cover the relational Database Model, the Oracle Architecture and the Physical database. The tutorial is aimed at programmers, and individuals who have had prior SQL and relational database experience. Gavin Powell, your instructor, will begin teaching you many Oracle tools such as the SQL Plus, SQL Plus Worksheet, and Oracle Enterprise Manager. This tutorial will explain how to maintain the Logical Database, and the difference between the Logical Database and the Physical database. You will be guided, in great detail, in the following areas: retrieving, changing, adding, and deleting data from the Database. From there, you will learn about Logical Database objects, Security, Select Statements, and much more. Introduction to Oracle SQL and PL/SQL will cover areas for the Oracle Certification course (1Z0-007).

In Perl 5 Essential Training, author Bill Weinman explains the fundamentals of programming in Perl, a flexible and powerful programming language that’s well suited for projects as varied as simple scripts to complex web applications. This course covers the details of the language, from conditionals, loops, and data structures to regular expressions, functions, and object-oriented programming. A quick-start guide is included for experienced developers who want to get up and running with Perl 5 fast. Exercise files are included with the course.

In this course, author Drew Falkman shows how to install the latest version of PHP, the popular web application server, and reviews the performance enhancements and language improvements in the 5.4 release, including short array syntax, function arrays, and support for the $this reference to current objects in closures. The course also introduces traits, the mechanism for code reuse in single inheritance languages such as PHP.