BECOME SQL CHAMPION | Udemy

TOTAL 3 SECTIONS WILL BE THERE :

1. BEGINNER LEVEL SQL CHAMPION.

2.INTERMEDIATE LEVEL SQL CHAMPION.

3. ADVANCED LEVELSQL CHMPION.

Below is the course content of SQL Champion :

SR NO TOPIC DESCRIPTION

• BASICS OF DATABASES
• CREATING TABLES
• CONSTRAINTS
• OPERATORS IN SQL
• NORMALIZATION IN SQL
• LIKE , IS NULL, IS NOT NULL, ORDER BY , DISTINCT AND FETCH – OFFSET
• DML STATEMENTS , INSERTS, UPDATES, CASE STATEMENTS – SIMPLE AND SEARCHED
• DELETE, DDL – CREATE , ALTER , DROP , TRUNCATE
• DIFFERENCE BETWEEN TRUNCATE AND DELETE
• SP_RENAME
• IDENTITY
• BUILT-IN FUNCTIONS IN SQL SERVER
• DATE/DATETIME FUNCTIONS
• STRING FUNCTIONS
• MATHEMATICAL FUNCTIONS AND CONVERSION FUNCTIONS
• SPECIAL FUNCTIONS AND AGGREGATE FUNCTIONS
• GROUP BY AND HAVING AND ROLLUP AND CUBE
• WINDOWS FUNCTIONS
• WINDOWS AGGREGATE FUNCTIONS
• WINDOWS ANALYTIC FUNCTIONS
• INTEGRITY CONSTRAINTS
• JOINS
• SET OPERATORS
• SUBQUERIES AND NESTED SUBQUERIES AND CORRELATED SUBQUERY
• CTEs , MULTIPLE CTEs, RECURSIVE CTEs
• TEMPORARY TABLES
• VIEWS
• INLINE – TABLE VALUED FUNCTIONS
• SYNONYMS AND SEQUENCES
• INDEXES
• PIVOT , UNPIVOT AND MERGE
• T-SQL VARIABLES
• CONDITIONAL STATEMENTS
• LOOPING
• CURSORS
• EXCEPTION HANDLING
• STORED PROCEDURES
• STORED FUNCTIONS – SCALAR, TABLE, MULTI
• TABLE VARIABLES
• TRIGGERS
• DYNAMIC SQL

  COMMON SQL DB INFO AND SECURITY

We will see each and every concepts practicall from scratch.

And will add videos on daily basis to complete above topics.

Let’s be the campion with me.

Complete SQL will be covered in this one course only , no need to register for any other course or purchase any other course.