Course Outline

Introduction to the database Oracle

    Database architecture Database relational model Users, schemas, sessions Tools

Introduction to the SELECT statement

    Projection and selection (filtering) Sorting Data types, operators and NULL handling Built-in scalar functions Date operations

Aggregated data analysis

    Grouping functions DISTINCT clause GROUP BY and HAVING clauses

Retrieving data from multiple tables

    Inner and outer joins (INNER JOIN, OUTER JOIN) ANSI SQL syntax and other join methods (SELF JOIN, NATURAL JOIN) Collective operators (UNION, UNION ALL, INTERSECT, MINUS)

Subqueries

    Simple subqueries Correlated subqueries EXISTS and NOT EXISTS operators

Data Manipulation (DML)

    INSERT, UPDATE, DELETE statements

Concurrent work of users

    Transactions Locks Ensuring data consistency over time

Requirements

General IT knowledge

  14 Hours
 

Number of participants


Starts

Ends


Dates are subject to availability and take place between 9:30 am and 4:30 pm.
Open Training Courses require 5+ participants.

Testimonials (10)

Related Courses

Related Categories