Learning Outcomes

In this free course, you will learn how to:

• List some user-defined types
• Identify how to implement CLR code modules
• Describe how to update a connected database
• Explain how to create a new object with TSQL
• Recall the basic database project settings of SQL
• Describe how the APPLY and MERGE statements work
• List the different common join operators in SQL
• Explain how to manipulate a hierarchy
• Analyze spatial data types in SQL
• Compare and contrast between sparse columns and column sets