SQL for Data Science

Course Curriculum

Basic SQL Module

In this assignment you will learn basic queries using keywords SELECT, INSERT,UPDATE, DELETE & Group By of SQL.

Intermediate SQL Module

In This assignment you will learn about GROUP Functions (AVG, Count, Max), Inner Join and Union Operator.

In This assignment you will learn about Left Join, Having Clause, Sub queries etc. 

In this assignment you will learn about Right join , IN, Not IN Statements, Any and All functions etc.

In this assignment you will learn about Like Operator, Group Function (Sum, Min), Between, And, OR operator etc.

Advanced SQL Module

In this assignment you will learn about functions : Date(), Lcase(), ascii(), length(), Ucase(), Left(), Right(), Row_number(), rank(), CONCAT_WS() etc.

In this assignment you will learn about View, Case, char_length, Binary etc.

Additional Learning Cookies !

This is a revision of all the queries that you have learnt earlier and there will be some additional challenging queries also.

The link of Hacker Rank platform is given in the assignment itself where you will be running your queries.

Scroll to Top