This Oracle Database: PL/SQL Fundamentals training will teach you the basics of PL/SQL, syntax, blocks and programming constructs. By enrolling in a Self-Study Course, you'll be able to learn at your own pace, when it's most convenient for you.Learn To:Identify the programming extensions that PL/SQL provides to SQL.Write PL/SQL code to interface with the database.Design PL/SQL anonymous blocks that execute efficiently.Use PL/SQL programming constructs and conditional control statements.Seamlessly integrate procedural constructs with SQL.Handle run-time errors.Create stored procedures and functions. Develop Your PL/SQL Fundamental SkillsThe Procedural Language extension to SQL (PL/SQL) is Oracle Corporation's standard data access language for relational databases. Invest in this course to develop core PL/SQL skills that will serve you well in your career.
Identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools
Identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures
Recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters
Recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables
Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements
Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops
Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL
Oracle Database 11g: Working with Exceptions, Subprograms, JDeveloper, and REF Cursors
Herhangi bir ön koşul yoktur.
Sınıf eğitimlerimizi İstanbul, Ankara ve Londra ofislerimizde düzenlemekteyiz. Kurumunuza özel eğitimleri ise, dilediğiniz tarih ve lokasyonda organize edebiliriz.