SQL in practice ? ORACLE
Introduction to SQL, discussion of its syntax and basic properties.
Preparation course to start using the SQL language using SQL Developer.
The area of the training
- Introduction to SQL (DDL, DML, DCL)
- Retrieving data using a SELECT statement
- Data filtering and sorting (WHERE, ORDER BY)
- Insert, modify and delete data
- Basic built-in SQL functions (e.g. TO_CHAR, TO_DATE, UPPER)
- Creating objects (tables, views, indexes)
- Collective operators (UNION, UNION ALL, INTERSECT, MINUS)
- Table joins (various syntaxes)
- Subqueries (scalar, single-line, multi-line)
- Grouping functions (COUNT, SUM, MIN, MAX), HAVING, GROUPING, ROLLUP, CUBE clauses
- Bulk data insertion (multi-array conditional and unconditional inserts, MARGE)
- Regular expressions
- Hierarchical queries
T Testimonials