Complete SQL

Course Curriculum

What will you learn in this Course?

 In this assignment we have covered the basic operations on a database that are abbreviated as CRUD – Create, Read, Update, Delete.

Group By function is used to perform some operations on a group of records. Hence many questions related to this are included in the topic.

This assignment includes the fundamental join queries that are used to join two or tables in SQL.

 Sub queries are also an important topic in SQL, this assignment covers the same.

 Table Constraints is a very useful concept of SQL because it improves the interactivity within a table. Hence, a good amount of practice questions are covered in this assignment.

 Sports club schema is Database that contains information about a sports club. This practice set allows you to test yourself by solving many questions based on the given schema.

 A number of SQL Hackerank problems are included for you to practice the covered topics.

This practice set contains questions based on a company schema related to all SQL topics covered in the course.

This assignment is a level up of all the assignments till now as it covers advanced queries in SQL using the University Schema.

Cursors are used to perform a specific operation row by row. This assignment focuses on cursors and its implementation.

 Views assignment will explain you about views, it’s implementation, applications and will also provide you questions to solve.

 Transactions is a part of advance SQL and will help you to learn advance skills of SQL.

 This assignment covers the fundamental window functions in SQL along with its implementation.

 CTE is a form of a temporary table in SQL which is very useful while implementing big queries. Hence many examples are included in the assignment so that you get thorough with the topic

 This assignment includes playing with strings and its wide number of functions available in SQL. Also you will be learning about Regular Expressions

The given assignment contains date time Manipulation functions that are useful while dealing with date time columns.

This topic introduces you to forward engineering and reverse engineering in SQL and its practical implementation.

Practice Sets & Case Studies

 Sports club schema is Database that contains information about a sports club. This practice set allows you to test yourself by solving many questions based on the given schema.

 A number of SQL Hackerank problems are included for you to practice the covered topics.

This practice set contains questions based on a company schema related to all SQL topics covered in the course.

 This case study gives you questions to practice based on the DataMart schema which will include the steps like data cleaning and data exploration.

We have designed this case study in such a way that is covers all the topics in SQL and gives you a good amount of practice

 This case study helps you to solve multiple queries of intermediate to advanced level based on the given database.

 This case study gives you questions to practice based on the Balanced Tree database which will include the steps like data cleaning and exploration.

Gives you a complete hands on practice of SQL topics from intermediate to advance levels using the Data Bank schema.

Scroll to Top