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