SQL Server Course

1) Introduction to SQL Server

  1. What is Data
  2. What is Database
  3. What is DBMS
  4. What is RDBMS
  5. What is SQL Server
  6. Installing SQL server Management Studio
  7. SQL Server Authentication mode
  8. SQL Server Windows Authentication mode

2) SQL Commands

i) Data Definition Language Commands (DDL)

  1. CREATE
  2. ALTER
  3. DROP
  4. TRUNCATE

ii) Data Manipulate Language Commands (DML)

  1. INSERT
  2. DELETE
  3. UPDATE
  4. LOCK

iii) Data Query Language Commands (DQL)

  1. SELECT

iv) Data Control Language Commands (DCL)

  1. GRANT
  2. INVOKE

v) Transaction Control Language Commands (TCL)

  1. COMMIT
  2. TRANSACTION
  3. ROLLBACK

3) Database

  1. SYSTEM DATABASES
  2. USER DEFINED DATABASES
  3. CREATE DATABASE

4) Tables

  1. SYSTEM DEFINED TABLE
  2. USER DEFINDED TABLE
  3. DEFINE SCHEMA

5) SQL Datatypes

  1. INT
  2. BIGINT
  3. SMALL INT
  4. CHAR
  5. VARCHAR
  6. NVARCHAR
  7. DATETIME
  8. DATE
  9. TIME
  10. XML
  11. DECIMAL
  12. NUMERIC

6) SQL Keys

  1. Primary Key
  2. Foreign Key
  3. Unique Key
  4. Super Key
  5. Natural Key
  6. Alternative Key
  7. Candidate Key
  8. Composite key
  9. Surrogate Key

 7) SQL Constraints

  1. Null
  2. Not Null
  3. Default
  4. Primary Key
  5. Unique Key
  6. Foreign key

8) SQL Joins

  1. LEFT JOIN / LEFT OUTER JOIN
  2. RIGHT JOIN / RIGHT OUTER JOIN
  3. FULL JOIN / FULL OUTER JOIN
  4. SELF JOIN
  5. INNER JOIN / JOIN
  6. CROSS JOIN

9) SQL Clause

  1. DISTINCT
  2. TOP
  3. WHERE
  4. ORDER BY
  5. IN
  6. NOT IN
  7. IS NULL
  8. IS NOT NULL
  9. EXISTS
  10. GROUP BY
  11. HAVING

10) SQL Operator

  1. AND
  2. OR
  3. <=
  4. >=
  5. <> 
  6. !=
  7. LIKE
  8. WILDCARD
  9. BETWEEN
  10. UNION
  11. UNION ALL
  12. EXCEPT
  13. INTERSECT

11) SQL Window Functions

  1. ROW_NUMBER ()
  2. RANK ()
  3. DENSE_RANK ()
  4. NTILE ()
  5. LAG ()
  6. LEAD ()
  7. FIRST_VALUE ()
  8. LAST_VALUE ()

12) SQL Datatime Functions

  1. DATEADD ()
  2. DATEDIFF ()
  3. DATEPART ()
  4. DATENAME ()
  5. GETDATE ()
  6. EOMONTH ()
  7. DAY
  8. MONTH
  9. YEAR

13) SQL String Functions

  1. LTRIM
  2. RTRIM
  3. RIGHT
  4. LEFT
  5. SUBSTRING
  6. CHARINDEX
  7. PATINDEX
  8. UPPER
  9. LOWER
  10. REPALCE
  11. STUFF
  12. REVERSE
  13. LEN
  14. REPLICATE
  15. CONCATE

14) SQL Aggergate Functions

  1. SUM
  2. COUNT
  3. MAX
  4. MIN
  5. AVG

15) SQL Conditional Statements

  1. IIF
  2. CASE
  3. WHILE
  4. IF
  5. BREAK
  6. CONTINUE

16) SQL Adavanced Functions

  1. ISNULL
  2. COALESCE
  3. ROLLUP
  4. CUBE
  5. PIVOT
  6. UNPIVOT
  7. SUB QUERIES
  8. CO RELATED SUB QUERIES
  9. DERIVED TABLES
  10. TABLE VARIABLES
  11. VARIABLES
  12. COMMON TABLE EXPRESIONS
  13. TEMP TABLES

17) Views in SQL

  1. SIMPLE VIEW
  2. COMPLEX VIEW
  3. ENCRYPTION AND SCHEMA BINDING

18) Stored Procedure in SQL

  1. STORED PROCEDURE WITHOUT PARAMETER
  2. STORED PROCEDURE INPUT PARAMETER
  3. STORED PROCEDURE OUTPUT PARAMETER
  4. STORED PROCEDURE RETURN VALUE
  5. DROP STORED PROCEDURE
  6. TRANSACTION, COMMIT, ROLLBACK
  7. TRY CATCH EXCEPTION HANDLING
  8. ENCRPT STORED PROCEDURE

19) Functions in SQL

  1. MULTI TABLE VALUED FUNCTION
  2. INLINE FUNCTION
  3. SCLAR FUNCTION

20) Merge in SQL

  1. MERGE

21) Dynamic in SQL

  1. DYNAMIC SQL

22) Indexes in SQL

  1. CREATE INDEX
  2. CLUSTER INDEX
  3. NON-CLUSTER INDEX
  4. FILTER INDEX
  5. COVERED INDEX
  6. COLUMN STORED INDEX
  7. DROP INDEX
  8. REBUILD INDEX

23) Triggers in SQL

  1. DDL TRIGGERS
  2. DML TRIGGERS

24) Cursors in SQL

  1. LIFE CYCLE OF CURSOR
  2. DECLARE CURSOR STATEMENT
  3. OPEN CURSOR STATEMENT
  4. FETCH CURSOR STATEMENT
  5. CLOSE CURSOR STATEMENT

Hi, fill the details our team will help you.

    Course





    Please fill the details our team will call you back.

      Course





      Azure

      Data Engineering Course

      New Batch

      17th-Feb-2025

      8:00 PM - 9:00 PM IST

      Please fill the details our team will call you back.