Course not currently available

Oracle SQL Language Training Course

Course

In York ()

£ 2,150 VAT inc.

Description

  • Type

    Course

The course answers questions
How to build a query?
What possibilities have SQL?
What is a relational database?
What is the structure and SQL commands

About this course

Computer skills
Knowledge of any operating system

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

We will only publish your name and question

Reviews

Subjects

  • Transactions
  • Options
  • Database Management
  • Database
  • SQL
  • Database training
  • Primary
  • Syntax
  • Perspective
  • Oracle SQL

Course programme

Relational database models
  • The structure of a relational database
  • Connection types of tables
  • The normalization and denormalization database
  • Database Management System (RDBMS)
Relational Operators

Characteristics of declarative SQL language SQL Syntax Division language DQL, DML, DDL, DCL Language DQL (Data Query Language)

  • SELECT queries
  • Aliases columns, tables
  • Service date (DATE types, display functions, formatting)
  • Group Features
  • Combining internal and external tables
  • UNION operator
  • Nested Subqueries (the WHERE clause, the table name, column name)
  • Correlated subqueries
Data Modification Language
  • Inserting rows (INSERT clause)
  • Inserting via query
  • Updating rows (UPDATE)
  • Removing rows (DELETE)
Data Definition Language
  • Create, change of ownership, remove tables (CREATE, ALTER, DROP) Creating tables by asking (CREATE TABLE .... AS SELECT ...)
CONSTRAINTS
  • Options NULL and NOT NULL
  • CONSTRAINT clause
  • Condition PRIMARY KEY
  • Condition UNIQUE
  • Condition FOREIGN KEY
  • DEFAULT clause
Transactions
  • The command COMMIT, ROLLBACK, SAVEPOINT
Language DCL
  • Granting and revoking permissions (GRANT, REVOKE)
  • Roles
  • Creating Users
  • sequences
  • Synonyms
  • The views (perspective)

Additional information

14 hours (usually 2 days including breaks)

Oracle SQL Language Training Course

£ 2,150 VAT inc.