First about the introduction, and the basics of the MS SQL server, about the functions, store procedure. Differ bt func and store procedure. Joins, Left right full union union all.