SQL is now one of the most sought-after skill by many IT companies. As the amount of Data generated by the rapidly increasing population of the earth increases, we need more and more people who are proficient in accessing, handling, and managing data.
Here is how you can learn SQL fast and easy. Below is the list of topics you need to learn and master-
SQL BASICS
- SQL Basic (SELECT, FROM, INSERT, UPDATE, DELETE)-Simplified
- SQL INSERT with examples – SIMPLIFIED
- SQL functions – Basics with EXAMPLES
- SQL JOINS- SIMPLIFIED WITH EXAMPLES
- SQL GROUP BY- NEED and USES
- SQL ORDER BY- HOW AND WHERE TO USE? – SIMPLIFIED
- SQL- Primary Keys And Foreign Keys
- SQL- UNION AND UNION ALL-Examples
- SQL Unique Constraints- Unique VS Primary key
- SQL-NOT NULL Constraints And Default Values
- SQL FLOOR AND CEILING FUNCTIONS
- SQL Date Functions – DATEPART, DATEADD, DATEDIFF
SQL ADVANCE TOPICS
- SQL LIKE Operator in Queries
- SQL Case Expression-Examples
- SQL Views – Simplified for Understanding
- SQL Stored Procedures – Simplified with Examples
- SQL SubQueries Basic- What are they? How to use them ?
- SQL Common Table Expression (CTE) – CLEAR And PRECISE
- Window function in SQL – Simplified
- SQL LEAD And LAG Functions – Simple Examples
- SQL ROW_NUMBER and RANK – Use cases
- SQL TOP keyword – Examples
Thanks For Reading!
Source: Microsoft T-SQL Reference
