SQL is a must when it comes to exploring, visualising and analysing a data set. This is especially true in DataScience projects, where data plays a central role.
Beginner or advanced, through this course we will gradually build up your skills.
This course will cover :
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,CASE WHEN,OFFSET FETCH NEXT ROWS.
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.
Important points about this course :
This course covers all SQL Server versions, even SQL Server 2019.
This online course is 9h30 hours of demo and 30 minutes of theory. Theory is in the classroom, not in this course :)
I made sure that the videos are not too soporific, and that they don't exceed 10 minutes.
Taking this course will help you to stand out technically from your colleagues, or during a job interview.
This course will help you to pass the Microsoft certifications 70-461 and 70-761 concerning the Transact SQL (From SELECT query to advanced SQL. Exams for SQL Server 2012, 2014, 2016, 2017, 2019)
If you really want to become more proficient in TSQL, frankly you won't find anywhere else a course as in-depth as this one, I can guarantee it!