Exercises of SQL on a Post-Graduation in Digital Technologies for Management giving by PhD Ana Lucas.
The porpuse of the class Data Base Management on the Post Graduation is for the students being able to manipulate data bases with SQL in Apex Oracle.
- SELECT, FROM, JOINs
- WHERE
- INTERCEPT, EXCEPT, MINUS
- Predicates
- Subqueries
- EXITS, NOT EXISTS
- Aggregation Functions
- Grouping, ROLLUP, CUBE
- RANK, INLINE VIEWS
- INSERT, UPDATE, DELETE
- CREATE, ALTER, DROP
- COMMIT, ROLLBACK
- Index Creation
- Data Types