<blockquote id="ad0y4" ></blockquote>

<blockquote id="ad0y4" ><meter id="ad0y4" ></meter></blockquote>

  • <source id="ad0y4" ></source>
  • <nobr id="ad0y4" ></nobr>

        <noscript id="ad0y4" ></noscript>
        <dl id="ad0y4" ><ins id="ad0y4" ><listing id="ad0y4" ></listing></ins></dl>

        <progress id="ad0y4" ><ol id="ad0y4" ></ol></progress>
      1. <dfn id="ad0y4" ></dfn>
          <optgroup id="ad0y4" ><dfn id="ad0y4" ><span id="ad0y4" ></span></dfn></optgroup>

          RKG Logo training-ITBiz
          RKG Logo
          幸运彩票手机版官网 Courses Fees Schedule REGISTER NOW Corporate Training Locations
          ITBiz
          columtop
          Microsoft Office Tools
          Adobe Acrobat Courses
          SharePoint Training
          Microsoft Dynamics
          Social Media Courses
          Project Management
          Application Devp Tools
          Oracle Developer Tools
          Data Warehouse & BI
          Data Base & System Admin
          Programming Languages
          Reporting Tools
          Networking & Security
          Web Technologies
          BootCamps
          Medical Records
          Business Skills
          ERP Training
          Corporate Training On-Site
          columnbottom
          ITBiz
          columnbottom
          Oracle PL/SQL
          Oracle PL/SQL
          Oracle SQL and PL/SQL
           
          Software Version Oracle Developer Tools 6i and 9i
          Course Duration 2 Days
          Course Type Class Room and Instructor-Led On-Line (E-Learning) Hands-On Training
          Course Overview Introduction to SQL and PL/SQL is an intensive course designed to give the student maximum exposure to Oracle SQL and PL/SQL. The student will be guided from very simple SQL commands to increasingly complex PL/SQL coding techniques. The topics start with the basics of SQL and progress into increasingly complex queries, including table joins, subqueries and creating Oracle views.
          Intended Audience for this course This course is designed for Office Staff, End Users, Office Secretaries, Analysts, IT management and Staff, Business Analysts, Functional Implementers, Project Managers, Students and also those who want to become use this Software for managing their day to day business operations.
          Course Topics
          SQL Section
          • Introduction to SQL Constructs
          • Using SQL*Plus
          • Joining Oracle Tables
          • Advanced SQL Operators
          • Aggregation in SQL
          • SQL access methods
          • SQL Tuning
            • Introduction to rule-based optimization
            • Introduction to cost-based optimization
            • Collecting table and index statistics
            • Changing the default optimizer modes
            • Using TKPROF
            • Using SQL*Trace
            • SQL reusability within the library cache
            • Table striping and table partitions
            • EXPLAIN PLAN
            • Using indexes to improve performance
            • Identifying full-table scans
            • Re-writing SQL queries
            • Using hints to improve SQL performance
            • Using parallel query to improve performance
            • Tuning sub-queries
          PL/SQL Section
          • Basics of PL/SQL
          • PL/SQL Structures
          • Error Checking – Exception Handling
          • Boolean Logic in PL/SQL
          • Cursors in PL/SQL
          • Iteration in PL/SQL
          • PL/SQL Tables
          • Dynamic SQL in PL/SQL
          • Nested Blocks in PL/SQL
          • Triggers n PL/SQL
          • Stored Procedures, Functions and Packages
          • Bulking in PL/SQL

          Enroll Online   

          Live Chat
          Enroll Online
          Enroll By Fax
          Fee & Schedule
          Send Message
          Testimonials
          ITBiz
          columtop
          columnbottom
          ITBiz
          Follow us on .....
          ITBiz
          For further information call 949-387-3772 or FAX 949-681-8247 or email to info@
          SONU Training is the training wing of RKG Technologies Inc
          Disclaimer: RKG Technologies is not linked with Microsoft, Oracle, Adobe, IBM or any other software company we provide training
          幸运彩票手机版官网 © 2004 RKG Technologies Inc. All rights reserved.