SQL advanced techniques, Convert datatypes, Create temporary tables, Declare and use variables, Sub queries, CASE statement, Numbering and ranking, Create your own functions, Creating views, Stored procedures, Loop with WHILE and IF, Dynamically build SQL statements…
