Oracle Data Analyst Online Training

Oracle Data Analyst Online Training

Oracle Data Analyst Online Training
Oracle Data Analyst Online Training

Oracle Data Analyst Online Training Course Content :

Introduction to the Oracle database

  • 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
  • The GROUP BY clause and HAVING.
  • Summary (clauses ROLLUP, CUBE, GROUPING)

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)

Analytic Functions

  • Generating summaries
  • Definition window
  • Statistical Functions
  • New features in Oracle 11g

Inquiries Pivot (PIVOT, UNPIVOT)

Tables and referential integrity

  • Managing tables (CREATE, ALTER, DROP, RENAME)
  • Referential integrity (constraints)

Data manipulation (DML)

  • INSTRUCTIONS INSERT, UPDATE, DELETE
  • Operacja na dużych zbiorach (INSERT FIRST, ALL INSERT, MERGE)

Concurrent users work

  • Transactions
  • Locks
  • FLASHBACK

Brief overview of schema objects

  • vistas
  • sequences
  • indexes

Drop your query

What my Client's Say?

 

  • Prabhu is an excellent instructor, very patient and thorough. I have tried another training class and EXPLORE IT far exceeds other trainers and their methods ~ Hassan Malik

  • An extremely helpful and informative course. Training materials were well organized and provided good case studies. Instructor was extremely professional and pleasant to learn from.~ Bhavani Sudarshnam

  • The training was clear and detailed. I like Parker's style of teaching as the recurrent training is a thorough review of the HR. Every opportunity for the student to ask questions was provided. ~ Yiting Chen

  • Jane Anderson conducted the class in a very professional manner. Examples were very relevant and I feel that I gained a lot from the updated materials this year.~ Somesh Taneja

  • Prem was a great instructor. Thanks Prem for making the training easy to understand. A lot of information was covered. He made the approach easy to follow.~ Komali Sambakula

  • She wants to make sure that her students walk away from her course with a good working knowledge. She is an excellent trainer and cares that all of her students learn the material.~ Kiran Jain

  • Krishna is very thorough and professional. He made the code very understandable. I was very impressed with his teaching methods and presentation of the regulations. EXPLORE IT is the best! ~ Rajesh Isukapalli

  • Mr. Chris Brown was very affirmative with the course, on time and fluent. This is my second recourse with him. I hope to take his course as long as I am shipping at my current job. ~ Awais Rahim