About Training
DESCRIPTION
Duration: 20 hours
Target Audience: Professionals who want to develop programs that use the language for SQL relational databases.
Requirements: Database Basics.
Course objectives
• Know the SQL language sub-divisions – DML, DDL and DCL
• Understanding on competition of transactions
• Know the Oracle SQL functions
◦ Mathematics, treatment strings, conversion
◦ Operations with dates, numbers and strings
◦ NVL, DECODE, CASE, TO_CHAR, TO_DATE, TO_NUMBER, etc.
Course content
| Introduction to SQL | Manipulating Objects |
| Data Query statement – SELECT Data Handling Instructions – DML INSERT and INSERT with SELECT UPDATE DELETE MERGE Data Control Instructions – DCL GRANT REVOKE AUDIT and NOAUDIT |
Creating, changing, and deleting Tables Indexes Views Synonyms |
| Using the Data Dictionary | Using Functions |
| Querying User tables User Contents User Visions User Synonym |
Character Handling Functions Data Handling Functions Numbers Handling Functions (Mathematics) |
| Working with Joins | Working with Subqueries |
| JOINS standard syntax Oracle Syntax JOINS ANSI-92 NATURAL, INNER, LEFT, RIGHT and OUTER JOIN |
Subquery in the WHERE, EXISTS clause Virtual tables (subquery in FROM) Subquery in the SELECT clause |
| Using Aggregate Functions | Working with Record Groups Operators |
| Character Handling Functions Data Handling Functions Numbers Handling Functions (Mathematics) |
UNION, UNION ALL, MINUS, INTERSECT |
20H
Hire
