Энэхүү сургалтад сууснаар та Oracle Database 12c: PL/SQL дэлхийн түвшний мэдлэгийг олж авах юм.

Суралцагсдад тавигдах шаардлага: Мэдээлэл технологийн мэргэжилтнүүд

Сургалтын үргэлжлэх хугацаа: 5 өдөр /40 цаг/

Сургалтын төлбөр: 3,200,000₮

Шалгалт: 1Z0-144

Шалгалтын төлбөр: $245

Сургалтын хэл: Англи

Сургалтын дараа олж авах мэдлэг:

• Write queries against single and multiple tables, manipulate data in tables and create database objects.
• Use single row functions to customize output.
• Invoke conversion functions and conditional expressions.
• Use group functions to report aggregated data.
• Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
• Develop anonymous PL/SQL blocks, stored procedures and functions.
• Declare identifiers and trap exceptions.
• Use DML statements to manage data.
• Use DDL statements to manage database objects.
• Declare PL/SQL Variables.
• Conditionally control code flow (loops, control structures).
• Describe stored procedures and functions.
• Retrieve row and column data from tables.

Сургалтын агуулга:

• Run data manipulation statements (DML) to update data in the Oracle Database.
• Design PL/SQL anonymous block that execute efficiently.
• Describe the features and syntax of PL/SQL.
• Handle runtime errors.
• Describe stored procedures and functions.
• Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors).
• Use cursors to process rows.
• Identify the major structural components of the Oracle Database 11g.
• Retrieve row and column data from tables with the SELECT statement.
• Create reports of sorted and restricted data.
• Employ SQL functions to generate and retrieve customized data.
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax.
• Create reports of aggregated data.
• Run data definition language (DDL) statements to create and manage schema objects.

Сургалтаар заах сэдэв:

• Introduction
• Working with Oracle Cloud Exadata Express Cloud Service
• Retrieve Data using the SQL SELECT Statement, Restricted and Sorted Data
• Usage of Single-Row Functions to Customize Output
• Conversion Functions and Conditional Expressions
• Aggregated Data Using the Group Functions
• Display Data From Multiple Tables
• Usage of Subqueries to Solve Queries
• SET Operators
• Data Manipulation, DDL Statements to Create and Manage Tables
• Other Schema Objects
• Introduction to PL/SQL
• PL/SQL Identifiers
• Write Anonymous PL/SQL blocks
• SQL statements in PL/SQL block
• Control Structures
• Composite Data Types
• Explicit Cursors
• Exception Handling
• Stored Procedures and Functions