Course not currently available
Oracle SQL Language Training Course
Course
In Coventry ()
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
Reviews
Subjects
- Transactions
- Options
- Database Management
- Database
- SQL
- Database training
- Primary
- Syntax
- Perspective
- Technology
Course programme
- The structure of a relational database
- Connection types of tables
- The normalization and denormalization database
- Database Management System (RDBMS)
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
- Inserting rows (INSERT clause)
- Inserting via query
- Updating rows (UPDATE)
- Removing rows (DELETE)
- Create, change of ownership, remove tables (CREATE, ALTER, DROP) Creating tables by asking (CREATE TABLE .... AS SELECT ...)
- Options NULL and NOT NULL
- CONSTRAINT clause
- Condition PRIMARY KEY
- Condition UNIQUE
- Condition FOREIGN KEY
- DEFAULT clause
- The command COMMIT, ROLLBACK, SAVEPOINT
- Granting and revoking permissions (GRANT, REVOKE)
- Roles
- Creating Users
- sequences
- Synonyms
- The views (perspective)
Additional information
Oracle SQL Language Training Course