Cursuri de pregatire Oracle 11g - SQL language for administrators - workshops

ID de curs

3308

Durata

21 ore (usually 3 days including breaks)

Sinoptic

For who

The workshop is intended for beginners, starting to work with the Oracle database, future administrators and users of systems based on this database need able to use the SQL language for the extraction and modification of the information contained in the systems.

Exams and Certificates

The training plan coincides with the material required to pass the exam: 1Z0-051 Oracle Database 11g: SQL Fundamentals I, the first step to getting most certifications Oracle's Database

Purpose of training

The workshop aims to introduce participants to work with the Oracle database, making them familiar with the SQL language to the extent required for the efficient operation of the system and to take in the future obligations of database applications and Oracle databases.

The content of the training

  • The organization of the working environment
  • Introduction to relational databases
  • Extraction of the data using the SELECT statement
  • Modifying data using INSERT, UPDATE, DELETE
  • Overview of schema objects

Remarks

The workshops are based on 11g XE software

Schița de curs

Introduction to Oracle

  • Database Architecture
  • Relational model database
  • Users diagrams sessions
  • Tools

Introduction to the SELECT statement

  • Screening and selection (WHERE clause)
  • sorting
  • Data types, operators, and service NULL
  • Built-in scalar functions
  • Actions to date
  • National and regional settings in SQL

Regular expressions

The analysis of aggregated data

  • Grouping functions
  • DISTINCT clause
  • Clauses GROUP BY and HAVING

Retrieving data from multiple tables

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

Subqueries

  • Subqueries simple
  • Correlated subqueries
  • Operators EXISTS and NOT EXISTS
  • Other types of subqueries

Inquiries hierarchical and samples

  • Construction of the tree (CONNECT BY PRIOR clause and START WITH)
  • The SYS_CONNECT_BY_PATH
  • Data samples (SAMPLE clause)

Data manipulation (DML)

  • INSERT, UPDATE, DELETE
  • Operations on a large set of (INSERT FIRST INSERT ALL, MERGE)

Concurrent users work

  • Transactions
  • Locks
  • FLASHBACK

Overview of schema objects

  • Vistas
  • Sequences
  • Synonyms private and public
  • Indexes

Mărturii

★★★★★
★★★★★

Categorii înrudite

Cursuri înrudite

Reduceri pentru cursuri

Newsletter Oferte Cursuri

Respectăm confidențialitatea adresei dvs. de email. Nu vom transmite sau vinde adresa altor părți. Puteți să schimbați preferințele sau să vă dezabonați complet în orice moment.

Câțiva dintre clienții noștri

is growing fast!

We are looking to expand our presence in Romania!

As a Business Development Manager you will:

  • expand business in Romania
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!