عربي
This course addresses Oracle Database 11g Programming with SQL and is focused on: - Using SQL to Query Your Database - Conversion Functions, Group Functions, and Joins - Subqueries, Set Operators, and Data Manipulation - Using DDL, Views, Sequences, Indexes, and Synonyms - Controlling User Access and Managing Schema Objects - Data Dictionary Views and Large Data Sets - Managing Data in Different Time Zones - Using Subqueries and Regular Expressions
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, stored procedures, and functions. Students learn about declaring variables and trapping exceptions. Students learn to develop stored procedures, functions, packages and database triggers. Students learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages.
This course is designed to give students a firm foundation in basic administration of Oracle Database. In this class, students learn how to install and maintain Oracle Database. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.
Oracle Developer Forms course will enable students to develop, implement and deploy internet applications using Oracle’s Forms Application. Working in a rapid development environment, students learn how to customize forms through user input items and how to control data access by creating event-related triggers using PL/SQL.
In this course, learner figure out how to design and construct an assortment of standard and custom Web and paper reports utilizing Oracle Reports Developer. Working in the definitive condition of Reports Builder, Students figure out how to recover, show, and configuration information from any information source in various revealing styles and distribute the yield to any goal. In this course, understudies figure out how to outline and fabricate an assortment of standard and custom Web and paper reports utilizing Oracle Reports Developer. Working in the decisive condition of Reports Builder, understudies figure out how to recover, show, and organization information from any information source in various detailing styles and distribute the yield to any goal.
Primavera P6.
Primavera P6 is the standard project management software tool used worldwide in industries such as Construction, Oil & Gas, Manufacturing, Energy and even IT. While there are lots of project management tools on the market, Primavera P6 shines in being able to manage large and complex projects and to do it well. Learning Primavera P6 can have its advantages and even lead to a great career in project planning & scheduling. Read-on and learn about about how you can succeed with Primavera P6.Primavera P6 is the standard project management software tool used worldwide in industries such as Construction, Oil & Gas, Manufacturing, Energy and even IT. While there are lots of project management tools on the market, Primavera P6 shines in being able to manage large and complex projects and to do it well. Learning Primavera P6 can have its advantages and even lead to a great career in project planning & scheduling. Read-on and learn about about how you can succeed with Primavera P6.
This course offers students an introduction to Oracle Database 19c 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, and create database objects.
The Oracle Database 19c: PL/SQL Fundamentals course introduces students to PL/SQL, Procedural Language for SQL. Explore the differences between SQL and PL/SQL. Examine the characteristics of PL/SQL and how it is used to extend and automate SQL.
