Oracle SQL Intermediate Training Course

Description

• Type

  Course

• Methodology

  Online

Description

Audience
All who want to improve their basic skills in Oracle SQL and also systematize already gained knowledge.
Format of the course
25% lectures, 75% labs

About this course

Requirements

Basic knowledge in Oracle SQL

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

Send

We will only publish your name and question

Request information

We are verifying your question adjusts to our publishing rules. According to your answers, we noticed you might not be elegible to enroll into this course, possibly because of: qualification requirements, location or others. It is important you consult this with the Centre.

Thank you!

We are reviewing your question. We will publish it shortly.

Or do you prefer the center to contact you?

Request information

Reviews

Have you taken this course? Share your opinion

Subjects

• Basic Skills
• SQL

Course programme

Create complex queries to databases

• Use available operators
• Queries with multiple conditions

Creating tables and references

• DDL commands (create, alter, and drop)
• Create referential integrity
• Normalization of tables (up to 3 normal form)
• anomalies and ways to avoid them

Changes in the structure of existing tables

• ALTER clause

Manipulation of data

• DML commands (insert, update, delete)

Creating new users and granting permissions

• DCL commands (grant, revoke)

Linking Tables

• Internal and external joins

Data Aggregation

• Features of grouping functions
• Use the GROUP BY clause and HAVING
• Grouping multiple column

Subqueries

• multi-column
• correlated
• WITH clause

Additional information

14 hours (usually 2 days including breaks)

See related categories

• SQL courses
• Distance learning SQL courses
• Basic Skills courses
• Distance learning Basic Skills courses
• Basic food hygiene courses
• Basic life support courses
• Counselling skills courses
• Basic plumbing courses
• Knife skills courses
• Basic hair cutting courses
• Basic electrical courses
• Basic mechanics courses
• Basic accounting courses
• Supervisory skills courses
• Oracle sql courses
• Key skills level 2 maths english courses
• Office skills courses
• Key skills courses
• Java courses
• Distance learning Java courses
• Distance learning Course
• Nobleprog Limited courses