Oracle SQL - The basic training
Understanding syntax, editing data and using joins - the training for the first steps
.svg)
Machine Learning Engineer
1. SQL - History
2. ZERO
3. Syntax of the SELECT statement
- SELECT FROM
- SELECT DISTINCT FROM
- WHERE and comparison operators
- Arithmetic and string operators
- AND, OR and NOT
- ORDER BY
- The DUAL table
- ROWNUM
4. SQL Functions
- Numeric, string, converter, date and time
- Comparison functions, LOBs and collections, hierarchical functions
- Data mining, XML and JSON
- Encoding & Decoding
- Environment - USER and SYS_CONTEXT
- DECODE and CASE
5. GROUP BY, group functions, and HAVING
6. Set Operations - UNION, UNION ALL, INTERSECT, and MINUS
7. DML (INSERT, UPDATE, and DELETE)
8. Transactions - COMMIT, ROLLBACK, SAVEPOINT, SET TRANSACTION, and Read Consistency
9. The Data Dictionary
10. Constraints - Primary, Unique, and Foreign Key Constraints
11. ROWIDs and Indexes - Index Types, Administration, and Reorganization
12. Joins
- old Oracle Join Syntax
- INNER, CROSS, OUTER and NATURAL Joins
- Self-Joins
13. Subqueries
- synchronous and asynchronous queries
- Inlay Views
- EXISTS and NOT EXISTS, ANY and ALL
- WITH
Requirements:
You don't need any programming skills, but they are helpful.
- Basic knowledge of Oracle SQL
- Syntax of simple statements
- Understanding joins and subqueries
- Knowledge of analytical functions, hierarchical queries and regular expression in SQL
Participants will gain theoretical knowledge, which will be reinforced through numerous practical exercises.
This workshop is aimed at prospective Oracle database administrators, administrators administrators, Oracle developers or architects, generally anyone who comes into contact with SQL.
.svg)
