You can only master SQL by practicing. Check out the following links learn more about SQL in depth

https://msdn.microsoft.com/en-us/sqlserver/bb671058.aspx

https://www.mssqltips.com/[/url]

http://www.sqlserverlogexplorer.com/[/url]