The creation and definition of a database and a table.
Let's start playing with data with SELECT,UPDATE,INSERT and DELETE
Discover the column aliases and tackle the specificity and secrets of LIKE.
Do you know the usefulness of the TOP ?
Learn how to remove duplicates with the DISTINCT and discover the Comparison operators = != and so on
Copying a table with the SELECT INTO.
Let's talk about the IN, NOT IN, IS and IS NOT operators, and Sort your data with ORDER BY.
Discover aggregate functions with MIN MAX and AVG and the two operators AND,OR.
Let's discover the specificity of COUNT and SUM and how to SELECT a range of data with the BETWEEN
Group several results with the GROUP BY
A long chapter of one hour and 30 minutes on joins with INNER JOIN,LEFT/RIGHT JOIN FULL OUTER JOIN and so on..
Let's discover the specificity of UNION and UNION ALL,and the LEFT and RIGHT function.
Have you heard of the CHOOSE, TRIM/LTRIM/RTIM ?
Let's go even further with Transact SQL with the IIF,CASEWHEN,OFFSETFETCHNEXTROWS.
Let's look at the conversion functions through CAST and CONVERT, TRY_CAST and TRY_CONVERT.
Let's approach the DATE type functions with DATEADD,DATEDIFF,GETDATE (), EOMONTH ...
Let's deepen our knowledge of TSQL even more With IF/ELSE, STRING SPLIT,STUFF,MERGE…
The creation and definition of a view and Stored Procedure.
The creation and definition of a function, schéma and trigger.
A very long chapter on RANKING functions such as ROW_NUMBER, OVER and PARTITION BY, ROWS /RANGE UNBOUNDED PRECEDING, FIRST and LAST VALUES, LAG and LEAD,ROW_NUMBER, DENSE _RANK, RANK, NTILE.
We will discover a one hour course on CTE (common table expression). So powerful and so little known (I still don't understand by the way) and the derived table.
Do you know the difference between Temporary tables, Variable tables and Global tables?
We will do a little performance by discovering the term SARGABLE.
