What you will learn
Learn the SQL essentials using SQL Developer on Linux. This course offers students an introduction to Oracle Database 10g database technology. In this class, students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data. Demonstrations and hands-on practices reinforce the fundamental concepts. In this course, students use Oracle SQL Developer on Linux as the main development tool.
Differentiate between Single Row and Multiple Row SQL Functions Categorize the Character Functions into Case Manipulation and Character Manipulation types Explain the Numeric Functions ROUND, TRUNC, and MOD List the Rules for Applying the Arithmetic Operators on Dates Use the Arithmetic Operators with Dates in the SELECT Clause Explain the DATE functions MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, LAST_DAY, ROUND, and TRUNC Explain Implicit and Explicit conversion Nest Functions to Perform Multiple Tasks in One Statement
This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. They learn about declaring variables, trapping exceptions and they also learn to declare and control cursors. In class students learn to develop, execute and manage PL\SQL stored program units like procedures, functions, packages and database triggers. Student also learns to manage object dependencies and recompilation of invalid objects. This course also describes the characteristics and ways of manipulation of large objects. Students are introduced to the utilization of some of the Oracle-supplied packages. Learn To: Create Executable Section and write Control Structures Create and manage Procedures, Functions, Packages and Triggers Work with Composite Data Types and cursors Utilizing Oracle-Supplied Packages in Application DevelopmentIncluding Exception HandlingManage Dependencies and Large ObjectsThis course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.
Leverage your investment by taking advantage of web technologies to easily and quickly construct sophisticated database forms and business logic with minimal effort. This course focuses on teaching students to use Oracle Forms Developer 11g (10.1.2.0.2) to rapidly build scalable, high-performance applications for the Internet. In this course students build, test, debug, and deploy interactive Internet applications. Working in a graphical user interface (GUI) environment, they develop an order entry application from the ground up. This application incorporates several advanced features that provide a rich user experience while implementing business rules. This course counts towards the Hands-on course requirement for the Oracle Forms Developer Certified Professional Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.
Customize forms with user input items such as check boxes, list items, radio groups, and Pluggable Java Components Integrate Java into Forms applications by using JavaBeans Control navigation, data access, validation, and transactions by creating event-related triggers Enable Forms applications running on the Web to access files and applications on the client computer Display Forms elements and data in multiple canvases and windows Deploy Forms applications to the Web
In this course, participants learn how to design and build a variety of standard and custom Web and paper reports using Oracle Reports Developer (22.214.171.124.1). Working in the declarative environment of Reports Builder, participants learn how to retrieve, display, and format data from any data source in numerous reporting styles and publish the output to any destination. Participants learn how to add dynamic content to a static Web page and publish reports to the Web. In addition, participants learn how to customize more complex reports, embed graphical charts, and use OracleAS Reports Services to deploy the reports.
Use report parameters and customize a runtime parameter form Enhance reports using graphs and PL/SQL trigger code Maximize report performance using OracleAS Reports Services and tune reports Publish a report on the Web and build reports to run in various languages Manage report templates, create mailing labels and letters Identify the main components in a report document and how they are related Identify the differences between Web and paper reports Identify standard report design styles and run existing reports to various output destinations Create and modify basic tabular reports and high quality Web reports Create other report styles such as break reports and matrix reports Create reports by accessing data from various data sources Add dynamic data to an existing HTML page
M-48, OLD DLF Colony, Sec-14, Gurgaon, Haryana
M-48, OLD DLF Colony, Sec-14, Gurgaon, Haryana