/data-base-management-ISEG

Exercises of SQL on a Post-Graduation in Digital Technologies for Management

Description

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.

Introduction of SQL

  • SELECT, FROM, JOINs
  • WHERE
  • INTERCEPT, EXCEPT, MINUS
  • Predicates
  • Subqueries
  • EXITS, NOT EXISTS
  • Aggregation Functions
  • Grouping, ROLLUP, CUBE
  • RANK, INLINE VIEWS

Data Manipulation

  • INSERT, UPDATE, DELETE

Data Definition

  • CREATE, ALTER, DROP
  • COMMIT, ROLLBACK
  • Index Creation
  • Data Types

NOTE: Both part I and II of the exercises are made relying on the AdventureWorksLT SCHEMA