SQL Advance Certificate for Aleksandra Kaczmarska-Lacheta

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