Database team training done by Alan. We had Alan, Brandon, Bryan, Danny, and Josh on the call. The topics discussed were: tables, layouts, relationships, joiner tables, one-to-many relationships, data diagrams, data types, triggers, stored procedures, functions, and views (snapshots in time or specific copies of table data). There was also some talks about automating actions, tight and loose connections and dependencies, multi-step processing, and other options.

We also spent quite a bit of time talking about how we have a lot of existing code in ColdFusion (server-side scripting language) and how we could move and/or transfer some of that power and control over to the actual database. This transfer of power and management could be code, logic, locks, and other database specific code and/or functions. As we keep going forward, we will most likely see more decoupling and loosening of the server-side scripting language (currently Adobe ColdFusion) from the underlying database code (SQL). The database may end up doing more work on its own vs having to be told what to do every time from the scripting language. Small transfer of power.

See attached for the recording.