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