All about select & join & project & dividedly in SQL Server?

Question

I mean I want to learn about these relational algebra in SQL server comprehensively so I need a few websites related to them.