OBJECTIVE: -

The goal of this course is to provide an introduction to PHP. The course will discuss topics necessary for the participant to be able to create and execute PHP web applications. The lectures and presentations are designed to provide knowledge and experiences to students that serve as a foundation for continued learning of presented areas.

COURSE DURATION:

• 2 Months /72 Hrs.

COURSE OUTLINE

•  Introduction to oracle database
•  Retrieve data using the SQL select statement
•  Learn to restrict and sort data
•  Usage of single-row functions to customize output
•  Invoke conversion functions and conditional expressions
•  Aggregate data using the group functions
•  Display data from multiple tables using joins
•  Use sub-queries to solve queries
•  The set operators
•  Data manipulation statements
•  Use of DDL statements to create and manage tables
•  Other schema objects
•  Control user access
•  Management of schema object
•  Manage objects with data dictionary views
•  Manipulate large data sets
•  Data management in different time zones
•  Retrieve data using sub-queries
•  Regular expression support
•  Oracle PL/SQL training outline
•  Introduction to PL/SQL
•  PL/SQL identifiers
•  Write executable statements
•  Interaction with the oracle server
•  Control structures
•  Composite data types
•  Explicit cursors
•  Exception handling
•  Stored procedures and functions
•  Create stored procedures
•  Create stored functions
•  Create packages
•  Packages
•  Implement oracle-supplied packages in application development
•  Dynamic SQL
•  Design considerations for PL/SQL code
•  Triggers
•  Create compound, DDL, and event database triggers