Developing SQL Databases : design and implement database objects, implement programmability objects, manage database concurrency, optimize database objects and sql infrastructure, design statistics maintenance tasks, analyze and troubleshoot query plans, design and implement elastic scale for azure sql database, define differences between extended events packages, targets, actions, and sessions, optimize performance of in memory tables, define results of concurrent queries based on isolation level, design trigger logic based on business requirements, implement table valued parameters, define table and foreign key constraints to enforce business rules, implement column store indexes, design and implement a relational database schema.