Formation Oracle SQL Language

Code formation

3057

Durée

14 heures (généralement 2 jours pauses comprises)

Pré requis

  • Computer skills
  • Knowledge of any operating system

Aperçu

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

Plan du cours

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)

Nos Clients témoignent

★★★★★
★★★★★

Catégories Similaires

Cours Similaires

Réduction spéciale

Newsletter offres spéciales

Nous respectons le caractère privé de votre adresse mail. Nous ne divulguerons ni ne vendrons votre adresse email à quiconque
Vous pouvez toujours modifier vos préférences ou vous désinscrire complètement.

Nos clients

is growing fast!

We are looking for a good mixture of IT and soft skills in Belgium!

As a NobleProg Trainer you will be responsible for:

  • delivering training and consultancy Worldwide
  • preparing training materials
  • creating new courses outlines
  • delivering consultancy
  • quality management

At the moment we are focusing on the following areas:

  • Statistic, Forecasting, Big Data Analysis, Data Mining, Evolution Alogrithm, Natural Language Processing, Machine Learning (recommender system, neural networks .etc...)
  • SOA, BPM, BPMN
  • Hibernate/Spring, Scala, Spark, jBPM, Drools
  • R, Python
  • Mobile Development (iOS, Android)
  • LAMP, Drupal, Mediawiki, Symfony, MEAN, jQuery
  • You need to have patience and ability to explain to non-technical people

To apply, please create your trainer-profile by going to the link below:

Apply now!

This site in other countries/regions