office@promanagement.ro

0721.391.236

021.317.09.29

full-oracle

Oracle Course – Introduction to SQL / PLSQL

500 € +VAT
, , ,
02-09-2020 Days: 3
8 Hours/Day Online
09:00 - 17:00

The price includes:

Official course support in electronic format and participation diploma.

  • Chapter 1

    General concepts Logical database storage structures.
    Database schema objects
    Physical database structures
    Oracle data dictionary and dynamic performance views.
    Transactions Oracle server architecture.
    Oracle Database Operation
    Oracle Products-Database Tools
    Identifying Major Components of an Oracle Instance
    Relational Approach
    Database Design

    No items in this section
  • Chapter 2

    Introducing the SQL language
    Writing a basic SQL command
    Relational principles and concepts Oracle
    Writing a basic SQL command
    Restricting and sorting data
    Functions that return values.
    Displaying data
    Grouping data using grouping functions
    Writing queries

    No items in this section
  • Chapter 3

    Creating interactive reports in SQL
    Data manipulation
    Creating and managing tables.
    Creating Views
    SQL Recap
    PL / SQL Overview
    Declaring Variables
    Writing Executable Commands
    Interacting with Oracle
    Writing Control Structures < br /> Working with composite data types
    Cursor description.
    Advanced slider concepts
    Exception handling

    No items in this section

Sign Up for this Course

If you would like to register more people with the same billing information or benefit from the group discount, please contact us by email at office@promanagement.ro