Oracle PL/SQL Training and Seminars

Databases and SQL

Oracle PL/SQL Training Classes Oracle Database configuration and administration, improve your DBA skills
Some important terms: administration, database, dba, oracle, plsql, sql database, mssql, mysql, oracle, programming, rdbms and sql.
Oracle PL/SQL Training Seminars and Classes
From Serebra Learning Corporation
Oracle SQL and PL/SQL: Basic Concepts on-line e-learning cbt (computer based) The Oracle SQL and PL/SQL: Basic Concepts WBT is the first course in this curriculum. This course will explain basic concepts regarding a DBMS, RDBMS, and ORDBMS and give an Oracle implementation of these. It will also provide users with the basic functionality of PL/SQL for creating, viewing, maintaining, and altering data in Oracle.  more...
Basic PL/SQL Programming on-line e-learning cbt (computer based) The Basic PL/SQL Programming WBT is the second course in this curriculum. This course will enable users to create views, sequences, synonyms, records, tables, functions, and procedures. Additionally, it will enable users to create different kinds of PL/SQL blocks.  more...
Oracle SQL Specifics: Retrieving and Formatting Data on-line e-learning cbt (computer based) This course is the first in a two-part series on Oracle SQL Specifics that will teach participants how to use commands functions and operators supported by Oracle as extensions to standard SQL. Students will be introduced to the Oracle implementation of the relational database management system (RDBMS) and the object-relational database management system (ORDBMS). Users will learn how SQL  more...
Oracle SQL Specifics: Creating and Managing Database Objects on-line e-learning cbt (computer based) This course is the second in a two-part series on Oracle SQL Specifics that will teach participants how to use commands functions and operators supported by Oracle as extensions to standard SQL. Users will learn how to create and manage tables build integrity constraints and use the COMMIT and ROLLBACK statements to control transactions. Learners will create and maintain views sequences indexes  more...
Oracle SQL and SQL*Plus: Advanced SELECT Statements on-line e-learning cbt (computer based) This course is the first course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the advanced SELECT statements and the use of subqueries in Oracle Statements. In addition this course explores the functions used in Oracle and covers the use of set operators to combine two or more queries.  more...
Oracle SQL Tuning: Diagnostics and Tuning the Schema on-line e-learning cbt (computer based) This course is the first in a two-part series on SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths such as partitioned views B-tree indexes bitmapped indexes index clusters and hash clusters. Participants will  more...
Oracle SQL for End Users Part 1 on-line e-learning cbt (computer based) Oracle SQL and SQL*Plus are powerful components of Oracle's relational and object relational database management systems. This course is designed for end users who want to learn how to write SQL SELECT statements to retrieve data from a database. This course identifies relational database properties introduces the Oracle server and indicates how SQL and SQL*Plus are used in the Oracle product  more...
Oracle SQL for End Users Part 2 on-line e-learning cbt (computer based) This course is the second in a two-part SQL for End Users series that is based on Introduction to Oracle: SQL and PL/SQL. In this course the learner displays data from multiple tables by using equijoins non-equijoins and self joins. In addition this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database. This course also covers  more...
Oracle SQL: Basic SELECT Statements on-line e-learning cbt (computer based) This course is the first in a three-part Oracle SQL series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing retrieving and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing basic SQL statements;  more...
Oracle SQL: Data Retrieval Techniques on-line e-learning cbt (computer based) This course is the second in a three-part Oracle series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course describes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries. In addition how to  more...
Oracle SQL: DML and DDL on-line e-learning cbt (computer based) This course is the third in a three-part Oracle SQL series that is based on the Oracle ILT course Introduction to Oracle: SQL and PL/SQL. Using the Oracle SQL*Plus environment this computer-based training course uses Structured Query Language (SQL) to create and populate Oracle database tables. Learners create tables and other database objects and learn to maintain and modify these data objects.  more...
Oracle PL/SQL: Basics on-line e-learning cbt (computer based) This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design develop and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming. Numerous  more...
Oracle PL/SQL: Procedures, Functions and Packages on-line e-learning cbt (computer based) This is the first course in a two part series. It introduces the learner to the basics of PL/SQL subprograms. This course covers the building and invoking of procedures and functions. Additionally this course introduces the basics of creating and using packages.  more...
Oracle PL/SQL: Database Programming on-line e-learning cbt (computer based) This is the second course in a two part series that discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored subprograms and  more...
Advanced Oracle PL/SQL: Design Considerations and Object Types on-line e-learning cbt (computer based) This course introduces students to subtypes subprograms cursor variables and the NOCOPY parameter used in advanced function definitions and packages. Students also learn about object types data dictionary views and collections.  more...
Advanced Oracle PL/SQL: Implementation and Advanced Features on-line e-learning cbt (computer based) This course introduces students to advanced interface methods practices and techniques that improve the efficiency and performance of PL/SQL operations. Students also learn about essential Oracle supplied packages that are commonly used in developing applications.  more...
Oracle9i PL/SQL: Basics on-line e-learning cbt (computer based) The Oracle9i PL/SQL: Basics course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design develop and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming.  more...
Oracle9i PL/SQL: Procedures Functions and Packages on-line e-learning cbt (computer based) This course introduces users to the basics of PL/SQL subprograms. Users will learn how to build and invoke procedures and functions. This course also covers debugging PL/SQL subprograms using Procedure Builder. Additionally users will learn how to trap and handle errors in a PL/SQL block. This course also covers the basics of packages and how to create and use them.  more...
Oracle9i PL/SQL: Database Programming on-line e-learning cbt (computer based) This course discusses the features of stored subprograms and packages. Participants will learn how to create and invoke stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. Participants will learn how to manage stored subprograms and packages. This course also introduces  more...
Oracle Application Server: Getting Started with PL/SQL Web Applications on-line e-learning cbt (computer based) This course introduces PL/SQL programmers to the essential concepts and techniques needed to build and deploy applications on Oracle Application Server. You will learn how to create PL/SQL packages that output interactive Web pages with database content including HTML tables and forms.  more...
Oracle 8i PL/SQL - Intro to RDBMS and SQL *Plus on-line e-learning cbt (computer based) The course aims to familiarize you with the basic concepts of database design. The course also provides a brief overview of relational database model since the Oracle database is based on this model. The course familiarizes you with the use of SQL and SQL *PLUS commands. The course will enable you to construct queries using SELECT statement with clauses such as WHERE ORDER BY and DISTINCT. You  more...
Oracle 8i PL/SQL - Functions, Tables, and Groups on-line e-learning cbt (computer based) This course covers the concepts of single row functions that enable the manipulation of data. The course essentially focuses on three single row functions: character functions number functions and date functions. The course also covers the concept of conversion that enables the conversion of a value from one datatype to another. The concept of retrieving data from more than one table by using  more...
Oracle 8i PL/SQL - Adv SQL, SQL *Plus & Data Dictionary on-line e-learning cbt (computer based) In this course you will learn to create subqueries and queries using SET operators. The course describes the SQL *PLUS file commands and SET commands that are used to customize the SQL *PLUS environment. Furthermore the course discusses the SQL *Plus format commands and script files. The concept of data dictionary tables and views is also covered in the course. Related Exam: Oracle Exam #1Z0-001:  more...
Oracle 8i PL/SQL - DML and DDL Statements on-line e-learning cbt (computer based) This course introduces the DDL and DML statements. It explains the concept of creation of tables and views. It also covers the various commands for manipulating a database. In addition the course explains the transaction processing features. It highlights the concept of altering a table definition in a database dropping a table adding comments to a table and renaming a table. It describes the  more...
Oracle 8i PL/SQL - Database Objects and Security on-line e-learning cbt (computer based) This course is aimed at familiarizing the learner with the inbuilt objects and security options in Oracle. The course includes creating and managing sequences indexes and users. It also includes PL/SQL block PL/SQL records and tables PL/SQL variables and datatypes. Related Exam: Oracle Exam #1Z0-001: Introduction to Oracle: SQL and PL/SQL.  more...
Oracle 8i PL/SQL - Oracle PL/SQL Basic Operations on-line e-learning cbt (computer based) The course is aimed at familiarizing the learner with the basic concepts of PL/SQL. It describes the different datatypes and variables available with PL/SQL. The course provides an overview of PL/SQL records and tables and explains how to access a database from PL/SQL. It also describes the steps to write conditional constructs and controlling structures in PL/SQL along with different types of  more...
From Bidw Solutions
Oracle Developer Track 11g This course is for people either new to Oracle database or are trying to learn the new Oracle 11g database version. This instructor led course will take you from Basics to Advanced level of training. At the end you get experience certificate from us.  more...
From IIHT-Vadapalani
Oracle DBA Training in Chennai Phone: 9677055562 / 8939992936. IIHT (Indian Institute of Hardware Technology) is a No. 1 Hardware & Networking Training Company in India. With 220+ branches around world, IIHT is delivering International Standard training to students & corporate. IIHT has partnered with around 13 MNCa ™s of world which includes Microsoft, Cisco, Red hat, Sun Microsystems, etc to deliver High End training in  more...
From Itloc
ORACLE PLSQL ONLINE TRAINING CLASSES on-line e-learning cbt (computer based) Exclusive Oracle PL/ SQL Training with Interview preparation questioner. Offering ORACLE PL/ SQL ONLINE training, couching CLASSES. Extensive training for developers on programming with PL/ SQL. Detailed coverage on oracle pl/ sql programming concepts. Online couching with one on one interaction. We offer exclusive online training classes which train programmers to achieve success in their  more...
Advanced Oracle SQL PLSQL Programming Our advanced pl/ sql programing includes the folllowing concepts. Overview of Basic SQL queries Overview of Basic PL/ SQL structures Sub queries Advanced queries Database Integrity Database Security Creating Database Objects Varrays, Nested Tables and Multi level Collections LOBs, CLOBs, BLOBs, BFILEs High Performance SQL Tuning. Basic pl/ sql programing knowledge is a must for traing  more...
Interview Preparation - Oracle PlSQL on-line e-learning cbt (computer based) We offer exclusive online training classes which train programmers to achieve success in their work place. Online training courses are provided by experienced professionals. Online training classes are flexible and convenient way to get trained. Online training classes are provided in the following categories. Oracle PL/ SQL Programming a Basic - Online Oracle SQL & PL/ SQL Programming a  more...
From Impart IT Training
Introduction to PLSQL This course will give you an introduction to Oracle Corporationa s proprietary procedural extension to the SQL database language, PL/ SQL. PL/ SQL (Procedural Language/ Structured Query Language) is embedded in the Oracle Database, and allows the creation of powerful programming blocks - procedures and functions - which interact with SQL to dramatically increase the functionality of your Oracle  more...
Want to Sell More Oracle PL/SQL training?
Custom Search
tcw11-v473M-03/27/17-00:59:22-()[A]-[B]-[A]