SQL for a DK Banking System
For Business and QA Analysts (and Developers)
A 5-day SQL course with a DK Banking System focus. Learn how to quickly write queries to navigate and summarize banking system data. Gain a greater understanding of the nuances of building queries and managing databases in a WBDK environment.
Topics include
- SQL Server Management Studio tour
- DK Database concepts
- Parent-child relationships
- Navigating DK table relationships
- Foreign Keys
- Optimizing queries
- Inner, Outer, Left, Right joins
- Aggregate Functions
- Nested queries
- Using temporary tables
- Problem solving lab