Online Oracle SQL Pl SQL eLearning Training

Oracle SQL PL SQL Using Procedure Builder Curriculum The courses in this curriculum cover the concepts of relational databases and the SQL and PL/SQL programming languages. Students learn how to create and maintain database objects and to store, retrieve, and manipulate data. In addition, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. This curriculum  more...

Oracle SQL Specifics Retrieving and Formatting Data Course Overview 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  more...

Oracle SQL Specifics Creating and Managing Database Objects Course Overview 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  more...

Oracle SQL and SQL Plus Advanced SELECT Statements Course Overview 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. L earn To: Write single-row  more...

Oracle SQL and SQL Plus SQL Plus and Reporting Course Overview This is the second course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the fundamental concepts of SQL*Plus and queries using SQL*Plus runtime variables. In addition, this course explores saving customizations and enhancing query output. L earn To: Identify the fundamental concepts of SQL*Plus and write queries  more...

Oracle SQL Tuning Diagnostics and Tuning Schema Course Overview 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  more...

Oracle SQL Tuning Tuning SQL and the Optimizer Course Overview This course is the second in a two-part series on SQL Statement Tuning. This course will help application developers to design SQL statements that can reuse parsing and influence the optimizer to improve performance. L earn To: Identify the factors that affect network traffic. Identify the factors that affect parsing. Identify the guidelines for the reuse of  more...