Directories for sql-examples, covering specific uses

It will (hopefully) grow over time, as more topics is discussed.

Topics covered so far :

Views

• Dump for the database used
• Instructions and sqls to create and use views

This will demostrate how and why you might use views, both for conveniance and security

Joins

• Dump for the database used
• Instructions and sqls to use different join-methods

Triggers

• Example on how to create and use them

Procedures

• Example on how to create and use them

This will demostrate how and why you need to use the correct join-method to get the result you expect/need

Example databases

• emp-schema
• hr_schema
  Credit goes to Andrei Ciobanu for creating a HR example schema