Terms you'll need to understand:
Deterministic Nondeterministic Stored procedure User-defined function Parameter Techniques you'll need to master:
Coding SQL Server objects Handling transactions Using parameters within procedures Implementing error handling Utilization of various trigger types