曙海教育集团
全国报名免费热线:4008699035 微信:shuhaipeixun
或15921673576(微信同号) QQ:1299983702
首页 课程表 在线聊 报名 讲师 品牌 QQ聊 活动 就业
   班.级.规.模.及.环.境--热.线:4008699035 手.机:15921673576( 微.信.同.号)
       坚持小班授课,为保证培训效果,增加互动环节,每期人数限3到5人。
   上.课.时.间.和.地.点
上课地点:【上海】:同济大学(沪西)/新城金郡商务楼(11号线白银路站) 【深圳分部】:电影大厦(地铁一号线大剧院站)/深圳大学成教院 【北京分部】:北京中山学院/福鑫大楼 【南京分部】:金港大厦(和燕路) 【武汉分部】:佳源大厦(高新二路) 【成都分部】:领馆区1号(中和大道) 【沈阳分部】:沈阳理工大学/六宅臻品 【郑州分部】:郑州大学/锦华大厦 【石家庄分部】:河北科技大学/瑞景大厦 【广州分部】:广粮大厦 【西安分部】:协同大厦
最近开课时间(周末班/连续班/晚班):即将开课,详情请咨询客服!
   实.验.设.备
     ☆资深工程师授课
        
        ☆注重质量 ☆边讲边练

        ☆合格学员免费推荐工作
        ★实.验.设.备请点击这儿查看★
   质.量.保.障

        1、免费重修;
        2、课程结束后,授课老师留联系方式,保障培训效果,免费技术支持。
        3、推荐机会。

课程大纲
 
  • Oracle 11g: Programming with PL/SQL培训
    Oracle 11g: Programming with PL/SQL培训
    培训大纲:
    Oracle Database 11g: PL/SQL Fundamentals
    1. Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements
    Features and capabilities of SQL Developer, SQL*Plus, and JDeveloper
    Features and benefits of PL/SQL and the steps for building basic PL/SQL blocks
    Declaring and initializing PL/SQL variables
    Uses of different PL/SQL data types, the %TYPE attribute, and BIND variables
    Constructing executable statements using various PL/SQL block elements
    Evaluate a block of PL/SQL code with respect to scoping and nesting rules and write and test PL/SQL blocks
    2. Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops
    Performing basic data manipulation and transaction control in PL/SQL and determining the outcome of SQL statements
    Writing control structures, such as IF statements and CASE expressions, in a PL/SQL block
    Writing and identifying loop statements
    Create PL/SQL blocks that incorporate loops and conditional control structures
    3. Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL
    Creating user-defined PL/SQL records and records with the %ROWTYPE attribute
    Creating an INDEX BY table and table of records and the uses of nested tables and VARRAYs
    Define, create, and use INDEX BY tables and a PL/SQL record in a given scenario
    Declaring and controlling explicit cursors and writing FOR loops to fetch data from them
    Declaring and using cursors with parameters, locking rows, and referencing the current row in an explicit cursor
    4. Oracle Database 11g: Working with Exceptions, Subprograms, JDeveloper, and REF Cursors
    Trapping non-predefined exceptions in PL/SQL
    Trapping user-defined exceptions
    Create an exception handler in a given scenario
    Creating and invoking simple stored procedures and functions
    Scope and capabilities of JDeveloper for developing and deploying Java applications and Web services
    Using cursor variables to pass query result sets and fetching rows from them
    Oracle Database 11g: Program with PL/SQL
    1. Oracle Database 11g: Getting Started With PL/SQL
    Features and capabilities of SQL Developer, SQL*Plus, and JDeveloper
    Features and benefits of PL/SQL and the steps for building basic PL/SQL blocks
    Steps for declaring and initializing PL/SQL variables
    Uses of different PL/SQL data types, the %TYPE attribute, and BIND variables
    Constructing executable statements using various PL/SQL block elements
    Evaluate a block of PL/SQL code with respect to scoping and nesting rules and write and test PL/SQL blocks
    2. Oracle Database 11g: Using DML, DDL, Cursors, Loops, and Control Structures
    Performing basic data manipulation and transaction control in PL/SQL and determining the outcome of SQL statements
    Writing control structures, such as IF statements and CASE expressions, in a PL/SQL block
    Writing and identifying loop statements
    Create PL/SQL blocks that incorporate loops and conditional control structures
    3. Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors
    Creating user-defined PL/SQL records and records with the %ROWTYPE attribute
    Creating an INDEX BY table and table of records and the uses of nested tables and VARRAYs
    Define, create, and use INDEX BY tables and a PL/SQL record in a given scenario
    Declaring and controlling explicit cursors and for writing FOR loops to fetch data from them
    Declaring and using cursors with parameters, locking rows, and referencing the current row in an explicit cursor
    4. Oracle Database 11g: Using Exceptions, Subprograms, JDeveloper, and REF Cursors
    Trapping non-predefined exceptions in PL/SQL
    Trapping user-defined exceptions
    Create an exception handler in a given scenario
    Creating and invoking simple stored procedures and functions
    Scope and capabilities of JDeveloper for developing and deploying Java applications and Web services
    Using cursor variables to pass query result sets and fetching rows from them
    5. Oracle Database 11g: Subprograms, Packages, and Exception Handling
    Benefits of modularized and layered subprogram design
    Creating and calling procedures and passing parameters
    Handling exceptions in procedures and for dropping procedures
    Creating and invoking functions
    Using SQL Developer to debug PL/SQL subprograms
    Benefits and components of a package and the steps for creating one
    Create a package specification and package body in a given scenario and invoke the package''s constructs
    6. Oracle Database 11g: Packages, Dynamic SQL, and Coding Considerations
    Overloading subprograms, using forward declarations, writing package initialization blocks, and maintaining persistent package state
    Using the Oracle-supplied packages DBMS_OUTPUT, UTL_FILE, and UTL_MAIL
    Using Oracle-supplied packages to generate a simple Web page and schedule PL/SQL code for execution
    Constructing and executing SQL statements at run time using native dynamic SQL statements in PL/SQL
    Alter a package so that it contains overloaded subprograms, use an Oracle-supplied package, and execute dynamic SQL in a given scenario
    Designing packages so that code is easy to maintain, efficient, and readable, and so that PL/SQL applications perform better
    Binding whole arrays of values in a single operation and retrieving information about a row affected by a SQL operation
    7. Oracle Database 11g: Using Triggers and the PL/SQL Compiler
    Creating and using database triggers
    Enabling, disabling, testing, managing, and removing database triggers
    Creating and using compound, DDL, and event database triggers
    Create statement and row triggers, including a trigger for a business rule and a package with triggers that resolve a mutating table issue
    Benefits and capabilities of the PL/SQL compiler and its parameters
    Using the PL/SQL compiler initialization parameters, compiling a procedure, and managing compiler warnings
    8. Oracle Database 11g: PL/SQL Code and Dependency Management
    Selectively including PL/SQL source code by using conditional compilation, and for wrapping a PL/SQL unit
    Predicting how changing a database object affects procedures and functions by tracking procedural dependencies
    Managing remote dependencies and recompiling a PL/SQL program unit
    Use conditional compilation, wrap PL/SQL code, a
     
     

  •  
     



 
 



 



 


 


 


 
 



 
 



 


 


 


 
   


 



 
 



 


 













 

 

 

友情链接:Cadence培训 ICEPAK培训 EMC培训 电磁兼容培训 sas容培训 罗克韦尔PLC培训 欧姆龙PLC培训 PLC培训 三菱PLC培训 西门子PLC培训 dcs培训 横河dcs培训 艾默生培训 robot CAD培训 eplan培训 dcs培训 电路板设计培训 浙大dcs培训 PCB设计培训 adams培训 fluent培训系列课程 培训机构课程短期培训系列课程培训机构 长期课程列表实践课程高级课程学校培训机构周末班培训 南京 NS3培训 OpenGL培训 FPGA培训 PCIE培训 MTK培训 Cortex训 Arduino培训 单片机培训 EMC培训 信号完整性培训 电源设计培训 电机控制培训 LabVIEW培训 OPENCV培训 集成电路培训 UVM验证培训 VxWorks培训 CST培训 PLC培训 Python培训 ANSYS培训 VB语言培训 HFSS培训 SAS培训 Ansys培训 短期培训系列课程培训机构 长期课程列表实践课程高级课程学校培训机构周末班 曙海 教育 企业 学院 培训课程 系列班 长期课程列表实践课程高级课程学校培训机构周末班 短期培训系列课程培训机构 曙海教育企业学院培训课程 系列班