Course Code: advsqltnw
Duration: 14 hours
Course Outline:

Useful Database Objects

  • Creating Databases, Tables, Views, Constraints
  • Principles of using indexes
  • How to create and maintain an index
  • Use of clustered tables
  • Use of partitioned tables
  • Use of metadata in the master database

Advanced Functions

  • Use of Rollup, Cube & related functions
  • Use of hierarchical queries
  • Use of analytical summary functions, e.g. moving averages, running totals
  • Use of ranking functions

Additional learning (suggested learning)

  • Aggregates: COUNT, SUM, MAX/Min, DISTINCT, GROUP BY, HAVING
  • JOIN & UNION statements
  • NULL handling
  • Subqueries: IN, EXISTS…
  • Views
  • Triggers
  • Data Modelling: Normal Forms, Primary & Foreign Keys
  • Transactions: COMMIT, ROLLBACK, Error handling