Session Description

For Database Administrators (DBA). Topics focused on introducing a database administrators to intermediate concepts of writing SQL queries.  Specific concepts will include subqueries, views, variables, window functions, cursors, stored procedures, and more. 

Session Content

• Subqueries and how they can be utilized in place of complex joins and other purposes
• Creating and utilizing Views for various tasks
• Utilizing variables to iterate and for making queries more adaptable
• Various concepts of using window functions
• Cursors
• Stored Procedures
  • Executing existing procedures
  • Create new procedures from scratch
  • Using parameters
• Using rollup for sub/grand-totaling counts
• Using a “JOIN” statement across separate databases

Related Documentation

SQL queries used in this session is attached.