In this course, we will solve 50+ complex interview questions using SQL and will cover the following topics:
1. Introduction to Database, SQL, and basic functions : Select, Case, Logical Functions, Mathematical Functions, Distinct, Top, Null
2. Formats & Functions : Number, String & Date
3. Data Filtering, Grouping and Sorting : Where, Having, Like, Group, Order, Sort
4. Joins : Inner, Left, Right, Outer Joins, Merge, Union, Subquery
5. Advanced Functions : Rank, Partition