Supercharge Your T-sql Skills With Variables!
Enroll to my courses in Udemy for become SQL Champion course and learn SQL From Basics to Advanced.
https://www.udemy.com/user/harshit-bh...
COURSE CONTENT BELOW :
SR NO TOPIC DESCRIPTION
1 BASICS OF DATABASES
2 CREATING TABLES
3 CONSTRAINTS
4 OPERATORS IN SQL
5 NORMALIZATION IN SQL
6 LIKE , IS NULL, IS NOT NULL, ORDER BY , DISTINCT AND FETCH - OFFSET
7 DML STATEMENTS , INSERTS, UPDATES, CASE STATEMENTS - SIMPLE AND SEARCHED
8 DELETE, DDL - CREATE , ALTER , DROP , TRUNCATE
9 DIFFERENCE BETWEEN TRUNCATE AND DELETE
10 SP_RENAME
11 IDENTITY
12 INTEGRITY CONSTRAINTS
13 BUILT-IN FUNCTIONS IN SQL SERVER
14 DATE/DATETIME FUNCTIONS
15 STRING FUNCTIONS
16 MATHEMATICAL FUNCTIONS AND CONVERSION FUNCTIONS
17 SPECIAL FUNCTIONS AND AGGREGATE FUNCTIONS
18 GROUP BY AND HAVING AND ROLLUP AND CUBE
19 WINDOWS FUNCTIONS
20 WINDOWS AGGREGATE FUNCTIONS
21 WINDOWS ANALYTIC FUNCTIONS
22 JOINS
23 SET OPERATORS
24 SUBQUERIES AND NESTED SUBQUERIES AND CORRELATED SUBQUERY,EXISTS , NOT EXISTS , DERIVED TABLES
25 CTEs , MULTIPLE CTEs, RECURSIVE CTEs
26 TEMPORARY TABLES
27 VIEWS
28 INLINE - TABLE VALUED FUNCTIONS
29 SYNONYMS AND SEQUENCES
30 INDEXES
31 PIVOT , UNPIVOT AND MERGE
32 T-SQL VARIABLES
33 CONDITIONAL STATEMENTS
34 LOOPING
35 CURSORS
36 EXCEPTION HANDLING
37 STORED PROCEDURES
38 STORED FUNCTIONS - SCALAR, TABLE, MULTI
39 TABLE VARIABLES
40 TRIGGERS
41 DYNAMIC SQL
42 COMMON SQL DB INFO AND SECURITY