CourseForMe

Oracle SQL Intermediate Training Course

NobleProgUS
NobleProgUS

Detailed information

Type:Courses
Method:Onsite
Duration:14 Hour
Total hours of lesson:7
Requirements:Basic knowledge in Oracle SQL
Students per class:6

Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to register, enrollment limit, availability and more.

Request information

Course program

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

Course location

Search similar to Other Database

Sponsored links