BECOME SQL CHAMPION - FROM ZERO TO HERO
COURSE CONTENT
SR NO TOPIC DESCRIPTION SECTIONS
1 BASICS OF DATABASES BEGINNER
2 CREATING TABLES BEGINNER
3 CONSTRAINTS BEGINNER
4 OPERATORS IN SQL BEGINNER
5 NORMALIZATION IN SQL BEGINNER
6 LIKE , IS NULL, IS NOT NULL, ORDER BY , DISTINCT AND FETCH - OFFSET BEGINNER
7 DML STATEMENTS , INSERTS, UPDATES, CASE STATEMENTS - SIMPLE AND SEARCHED BEGINNER
8 DELETE, DDL - CREATE , ALTER , DROP , TRUNCATE BEGINNER
9 DIFFERENCE BETWEEN TRUNCATE AND DELETE BEGINNER
10 SP_RENAME BEGINNER
11 IDENTITY BEGINNER
12 BUILT-IN FUNCTIONS IN SQL SERVER INTERMEDIATE
13 DATE/DATETIME FUNCTIONS INTERMEDIATE
14 STRING FUNCTIONS INTERMEDIATE
15 MATHEMATICAL FUNCTIONS AND CONVERSION FUNCTIONS INTERMEDIATE
16 SPECIAL FUNCTIONS AND AGGREGATE FUNCTIONS INTERMEDIATE
17 GROUP BY AND HAVING AND ROLLUP AND CUBE INTERMEDIATE
18 WINDOWS FUNCTIONS INTERMEDIATE
19 WINDOWS AGGREGATE FUNCTIONS INTERMEDIATE
20 WINDOWS ANALYTIC FUNCTIONS INTERMEDIATE
21 INTEGRITY CONSTRAINTS INTERMEDIATE
22 JOINS ADVANCED
23 SET OPERATORS ADVANCED
24 SUBQUERIES AND NESTED SUBQUERIES AND CORRELATED SUBQUERY ADVANCED
25 CTEs , MULTIPLE CTEs, RECURSIVE CTEs ADVANCED
26 TEMPORARY TABLES ADVANCED
27 VIEWS ADVANCED
28 INLINE - TABLE VALUED FUNCTIONS ADVANCED
29 SYNONYMS AND SEQUENCES ADVANCED
30 INDEXES ADVANCED
31 PIVOT , UNPIVOT AND MERGE ADVANCED
32 T-SQL VARIABLES ADVANCED
33 CONDITIONAL STATEMENTS ADVANCED
34 LOOPING ADVANCED
35 CURSORS ADVANCED
36 EXCEPTION HANDLING ADVANCED
37 STORED PROCEDURES ADVANCED
38 STORED FUNCTIONS - SCALAR, TABLE, MULTI ADVANCED
39 TABLE VARIABLES ADVANCED
40 TRIGGERS ADVANCED
41 DYNAMIC SQL ADVANCED
42 COMMON SQL DB INFO AND SECURITY ADVANCED