Microsoft SQL Server Database Syllabus:

1. PREREQUISITES:

2. INTRODUCTION:DATABASE, RELATIONAL DATABASE MANAGEMENT -- SQL (STRUCTURED QUERY LANGUAGE) -- HISTORY -- INSTALLATION, ARCHITECTURE, CONNECTING TO SQL SERVER -- SSMS

3. ENTITY RELATION DIAGRAM

4. DATA TYPES AND OPERATORS: OVERVIEW -- WORKING DATA TYPES (EXACT NUMERIC, APPROXIMATE NUMERIC, DATE &TIME, CHARACTER STRINGS, UNICODE CHARACTER STRINGS, BINARY, MISC.) -- WORKING WITH OPERATORS (ARITHMETIC, COMPARISON, LOGICAL) -- WORKING WITH NULL, COALESCE -- DATA TYPE CONVERSION (DETAILED), TYPE CASTING (CONVERT & CAST)

5. SQL STATEMENT TYPES: DDL,DML,DCL,DQL,DTL,

6. DATABASE: LOGIN, CREATE, DROP, TRUNCATE, RENAME, BACKUP, RESTORE -- WORKING WITH DATABASES

7. OPERATIONS ON TABLE: CRUD(INSERT,RETRIEVE,UPDATE,DELETE), DATATYPES/DATA CONVERSION

8. ISNULL & COALESCE

9. KEYS AND CONSTRAINTS: TYPES (PRIMARY KEY, FOREIGN KEY, UNIQUE KEY, DEFAULT, CHECK, REFERENTIAL INTEGRITY…),IDENTITY COLUMN,BASIC DBCC COMMANDS

10. SQL QUERIES -- SELECT STATEMENT, WHERE CLAUSE -- OPERATIONS ON ROWS AND COLUMN 

11.SQL SUB QUERY & SQL CASE STATEMENT

12.AGGREGATE FUNCTIONS OVERVIEW:(MIN, MAX, SUM, AVG, COUNT) - OVER CLAUSE - EXCEPT OPERATOR

13.JOIN INTRODUCTION: CONCEPT OF SET THEORY,OPERATIONS, TYPES OF JOIN 

14.VIEWS: OVERVIEW,OPERATIONS, ADVANTAGES AND DISADVANTAGES/LIMITATIONS(UPDATABLE VIEWS,INDEXED VIEWS)

15.STORED PROCEDURES: OVERVIEW, USAGE, ADVANTAGES AND DISADVANTAGES --WORKING ON SPS WITH OUTPUT PARAM, WITHOUT OUTPUT PARAM,PASS PARAMETER, RETURN VALUE 

16.UNION VS UNIONALL

17.FUNCTIONS: INTRODCUTION,TYPES: SCALAR VALUED FUNCTION, TABLE VALUED FUNCTION,MATHEMATICAL FUNCTIONS - MULTI-STATEMENT TABLE VALUED FUNCTION RETURN VALUE,DIFFERENCE BETWEEN FUNCTION AND STORED PROCEDURE 

18.INDEXES AND TRIGGERS:INTRODUCTION, TYPE, ADVANTAGES, DISADVANTAGES OF INDEXES, INTRODUCTION AND TYPES OF TRIGGERS (DDL/DML….) -- WORKING WITH TRIGGERS AND INDEXES

19.TEMPORARY TABLES -- OVERVIEW, TYPES AND SCOPE -- WORKING WITH TEMP TABLES 16. UNION VS UNION ALL -- WHERE AND HAVING -- UNION INTERSECT AND EXCEPT

20.SQL STRING FUNCTIONS: LEFT, RIGHT, CHARINDEX, PATINDEX, SUBSTRING, REPLICATE, REPLACE, RANK, ROW_NUMBER, DENSE_RANK, ORDER BY, OVER ()

21.PIVOT AND UNPIVOT

22.ERROR HANDLING

23.TRANSACTIONS IN SQL SERVER