office@promanagement.ro

0721.391.236

021.317.09.29

full-oracle

Oracle Course – Developing SQL Queries for Oracle Database 11g

545 € +VAT
, , , ,
Organized on request Days: 3
8 Hours/Day Online
9:00 - 17:00

The course is accredited by ANC – Assistant Programmer – COR 351201

The diploma is recognized by the Ministry of Labor, Family and Social Protection and the Ministry of Education, Research and Innovation and certifies all professional skills of the occupation.

The price includes:

Electronic course support, ANC exam and ANC certificate.

This course will provide participants with the skills to:

  • Returns data (rows and columns) from tables using the SELECT command
  • Create reports with sorted and sorted data as needed
  • Displays data from multiple tables
  • Use DML (data manipulation language) to work on the data in the tables
  • Use DML (data manipulation language) to work on database objects

This course introduces students to the basics of SQL using Oracle Database 11g technology. Students will learn the concepts of relational databases and the powerful SQL language. The course structure will give students the ability to write queries to one or more tables, manipulate data in tables, and create objects in the database.

Students will also learn how to use single-row functions to customize the output of a query, condition the results of a query, and how to use group functions for reporting.
Participants in this course should be familiar with the use of a graphical interface (GUI) and be familiar with the concepts of data processing. The tools used will be: Oracle SQL Developer and the SQL * Plus command line utility.

Conditions of access and documents required for registration:

Enrollment in the training program is conditioned by the graduation of secondary education along with the followiing documents:

  • Copy of identity card.
  • Copy of the baccalaureate diploma.

Volume discount:

Negotiable volume discounts are granted. Request a special offer for your company!

Graduation certificate template:

  • 1. Introduction

    • What is a database? What is SQL Language?
    • Presentation of the architecture of an ORACLE database.
    • Physical and theoretical aspects of a relational database
    • Description of SQL Developer tools and the structure of the exercises
    • Description of the data set used by this course

    No items in this section
  • 2. Return data using the SELECT command

    • SELECT command capabilities
    • Generating a data report from the output of a SELECT command
    • Using mathematical expressions and NULL values in a SELECT
    • Using column aliases < br /> • Using the concatenation operator and the keyword DISTINCT
    • Displaying the structure of a table using the DESCRIBE command

    No items in this section
  • 3. Limiting and sorting the interrogated data

    • Writing queries containing the WHERE clause to limit returned data
    • Using logical and comparison operators
    • Describing precedent rules for logical and comparison operators
    • Using string data types characters in the WHERE clause
    • Write queries using the ORDER BY clause to sort the output of a query
    • Use substitution variables

    No items in this section
  • 4. Using the “Single-Row” functions to customize the output of a query

    • The difference between single-row functions and multiple-row functions
    • Manipulating strings using the character functions
    • Manipulating numbers using the functions: ROUND, TRUNK and MOD
    • Operations mathematics with the DATE data type
    • Manipulating the DATE type using the DATE type functions

    No items in this section
  • 5. Using conversion functions and conditional expressions

    • Description of implicit and explicit data conversion
    • Using the TO_CHAR, TO_NUMBER and TO_DATE functions for conversions
    • Multiple functions (nesting functions)
    • Using the NVL, NULLIF and COALESCE functions on the data
    • Use of conditional expressions such as IF - THEN - ELSE in a SELECT sentence

    No items in this section
  • 6. Reporting aggregated data using group functions

    • Using the aggregation functions in select sentences to create intelligible reports
    • Using the AVG, SUM, MIN and MAX functions
    • Manipulating NULL values in group functions
    • Creating queries that share data in groups using the GROUP BY clause
    • Create queries that exclude data groups using the HAVIN clause

    No items in this section
  • 7. Display data from multiple tables

    • Writing SELECT sentences to access data from multiple JOIN tables using SQL: 1999 standard
    • Displaying data that does not meet a JOIN condition using OUTER JOIN
    • Using a SELF JOIN
    • Creating CROSS JOIN

    No items in this section
  • 8. Use sub-queries to solve complex queries

    • Using sub-queries to solve a problem
    • Using group functions in a sub-query
    • Using sub-queries to return multiple lines
    • Using ANY and ALL in sub-queries that return multiple lines

    No items in this section
  • 9. Using SET operators

    • Description of set operators
    • Use of set operators to combine several queries into one
    • Use of UNION, UNION ALL, INTERSECT and MINUS operators
    • Use of the ORDER BY clause in work with crowds

    No items in this section
  • 10. Data Manipulation (DML)

    • Adding new rows to a table using the INSERT command
    • Changing data in a table using the UPDATE command
    • Using the DELETE and TRUNCATE commands
    • Saving or undoing changes using the COMMIT and ROLLBACK commands
    • Using the FOR UPDATE clause

    No items in this section
  • 11. Use data definition language (DDL) to create and manipulate tables and objects

    • Object categories in Oracle databases
    • Creating new tables using the CREATE TABBLE command
    • Description of data types
    • Description of constraints
    • Creating a new table using a sub -query
    • Altering the structure of a table
    • Deleting a table

    No items in this section
  • 12. Creating other types of objects

    • Creating, modifying and extracting data from a VIEW
    • Using the data handling language on a VIEW
    • Deleting a VIEW
    • Creating, using and modifying a sequence
    • Creating and deleting indexes
    • Creating and deleting synonyms

    No items in this section
  • 13. Manipulating objects using the data dictionary

    • The data dictionary
    • How to use the VIEWs in the data dictionary
    • The VIEWs USER_OBJECTS and ALL_OBJECTS
    • Information about tables and columns
    • Querying the data dictionary with on constraints Query the data dictionary on other objects. Ex: VIEWs, sequences, indexes, synonyms
    • Adding a comment to a table
    • Querying the data dictionary regarding the comments related to the tables

    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