0   reviews on Udemy

Advanced SQL for data scientists (9 hours of practice)

Learn SQL in this 10-hour course for data scientists on SQL Server 2019 !
Course from Udemy
 3 students enrolled
 en
Set up your environment by installing Management Studio and SQL Server.
Creating, deleting and modifying a database
Create, delete and modify a table.
Learning how to select data with the SELECT,Updating data with the UPDATE,Deleting data with DELETE and INSERT
Rename columns with aliases and Select a certain number of lines with the TOP
The usefulness of square brackets and comments on SQL
The IN, NOT IN, IS and IS NOT operators and Comparison operators = !=
Sort the data with the ORDER BY and Aggregate functions: MIN, MAV and AVG
Remove duplicates with the DISTINCT and Copying a table via SELECT INTO
AND and OR,BETWEEN operators and the HAVING.
Let's combine the data with GROUP BY and the PRINT command.
A long chapter on SQL joins (INNER JOIN, LEFT and RIGHT JOIN, FULL OUTER JOIN,and so on).
Let's discover the specificities of UNION and UNION ALL,and the LEFT and RIGHT function.
Let's go even further with Transact SQL with the CHOOSE,IIF,CASE WHEN,SUBSTRING, OFFSET FETCH NEXT ROWS.
Have you heard of the CHOOSE, TRIM/LTRIM/RTIM or COALLESCE function?
Let's look at the conversion functions through CAST and CONVERT, TRY_CAST and TRY_CONVERT, as well as TRY_PARSE and PARSE.
Discover the score functions (ROW_NUMBER,OVER PARTITION BY, LAG and LEAD,ROWS /RANGE UNBOUNDED PRECEDING, FIRST_VALUES and LAST_VALUES)
Create, modify and delete a view and a stored procedure
Tackle the little-known CTE (Common table expression)
And more than 50 practical exercises !

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! 

Advanced SQL for data scientists (9 hours of practice)
$ 69.99
per course
Also check at

FAQs About "Advanced SQL for data scientists (9 hours of practice)"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

SOCIAL NETWORK