25.8.20
This website uses cookies to ensure you get the best experience on our website. Learn more

Developing SQL Server Databases Proficient

EssentialTECH learning journeys take employees on a world tour of Data Engineering development opportunities that cover the concepts, languages, and tools necessary to progress from beginner through advanced proficiency. Along this journey, learners collect “passport stamps” indicating proficiency in a specific capability. This EssentialTECH Data Engineering Learning Journey passport stamp is awarded for the achievement of an above-average or a high proficiency-level Skill-IQ assessment scores in Developing SQL Server Database including: - Analyzing and troubleshooting query plans - Create triggers and user-defined functions - Creating stored procedures - Designing and implementing database objects - Designing and implementing indexes - Designing and implementing views - Ensuring data integrity with constraints - Implementing memory-optimized tables and native stored procedures - Implementing transactions - Managing isolation levels

Skills / Knowledge

  • SQL
  • query plans
  • user-defined functions
  • triggers
  • database objects
  • indexes
  • Ensuring data integrity with constraints
  • stored procedures
  • memory-optimized tables
  • native stored procedures
  • transactions
  • Managing isolation levels

Issued on

December 15, 2021

Expires on

Does not expire