Oracle sql courses

... and alter tables, indexes and views, Insert, update, merge and delete rows, Grant and. Suitable for: This course is designed for experienced SQL users who need to access and work with an Oracle Database. This course is suitable for users of versions 9i, 10g and...

...This course is designed to give experienced SQL users practical experience in accessing an Oracle Database. This course is suitable for users of versions 9i, 10g and...

...Oracle Database Design and SQL Programming Course Summary: This course is delivered in the evening. Course Content: This course is delivered on-line... Learn about: Database Design...

... the Efficiency of SQL Statements using SQL Trace and AutotraceUsing the SQL Tuning AdvisorIdentifying SQL Statements that Perform BadlyUsing Hints to Influence Execution PlanIdentifying Unused Indexes... Learn about: Database training, Oracle 10g...

...The Oracle RDBMS is typically deployed throughout a business, from the corporate mainframe, to enterprise Unix servers, down to departmental level intel platforms. For a database of any significant size, performance immediately becomes an issue. Users may resent a query taking 3.5h, for instance...

...This Oracle 12C SQL Performance Tuning course introduces the delegate to the main concepts of Oracle SQL performance tuning. It is designed to give delegates practical experience in analysing and tuning the performance of SQL. This course is suitable for users of Oracle Database 11g and Oracle... Learn about: Database training...

...Oracle PL/SQL Program Blocks What's the course about? Areas covered by the course include: Creating DML Triggers Creating ON DATABASE and ON SCHEMA...

.... Benefits to You: Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds. Advanced Features of SQL: By enrolling in this course, you'll also gain exposure to using... Learn about: Database training...

...On completion of the course delegates will be able to: Query and manipulate data. Use SQL*Plus to format query output. Suitable for: The course has been designed for System Analysts, Managers and End Users...

... Certified Associate examination #1Z0-001: Introduction to Oracle SQL and PL/SQL. This course is suitable for delegates intending to sit the Oracle PL/SQL Developer Certified Associate examination...

... to sit the Oracle examination #1Z0-147: Program with PL/SQL. Suitable for: This course, designed for Oracle software development personnel and database administrators who need to write new, or maintain existing, PL/SQL triggers, program units and packages...

... for PerformanceExamining and Interpreting the Execution Plan of a SQL Statement using EXPLAIN PLANExamining the Efficiency of SQL Statements using SQL Trace and AutotraceUsing the SQL Tuning AdvisorIdentifying SQL Statements that Perform BadlyUsing Hints to Influence Execution PlanIdentifying Unused Indexes... Learn about: Database training...

..., delegates will be able to: Write PL/SQL Control Structures. Edit, store &. Suitable for: This course is for programmers and support staff who wish to gain a comprehensive understanding of how the Oracle Procedural Language / Structured Query Language (PL/SQL) is used...

... to sit the Oracle examination #1Z0-147: Program with PL/SQL. Note: Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience...

...Upon completion of this course, the participant should be competent to code PL/SQL applications incorporating PL/SQL components and constructs shown under 'Core Topics' in the detailed outline. Suitable for: PL/SQL developers, DW ETL developers, DBAs and production DBAs...

... some of the Oracle-supplied packages. Who will the Course Benefit?Oracle database administrators, software development personnel and database support staff who need to write PL/SQL scripts and implement or maintain database triggers, program units and packages. Learning Objectives The delegates will practise... Learn about: Database training...

...The Oracle RDBMS is typically deployed throughout a business, from the corporate mainframe, to enterprise Unix servers, down to departmental level Intel platforms. For a database of any significant size, performance immediately becomes an issue. Users may resent a query taking 3.5h, for instance...

...By the end of this course, the delegate will be able to use SQL*Plus and SQL Developer effectively and write SQL statements to query an Oracle Database. The delegate will also be able to create and run SQL script files, use Oracle's numeric, character and date functions, implement Oracle's enhanced...

...Upon completion of this intensive hands-on course, the delegate should feel comfortable when working with the 'Core Topics' (in the detailed outline), especially SQL query optimisation. Suitable for: SQL*Plus application developers, DBAs and system administrators...

... and trapping exceptions.Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.Benefits to YouEnsure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service... Learn about: Database training...