SQL Server course for Intermediate trainees by Enosis learning

Course Duration
; 1 Month
We cover the following topics:-
INTRODUCING SQL SERVER 2019
-What is SQL server
-SQL server editions
-Installing SQL server
-SQL server instances
-Internals of SQL server database
-MDF and LDF files
BASICS OF DATABASE DESIGN:
-Normalization
-Denormalization
-Introducing SQL server management studio
-Creating a database
-Data type
-Creating tables
-Alteration of table design
-Drop table
CONSTRAINT IN SQL SERVER:
-What is constraint
-Adding constraint to columns in tables
-Primary key constraint
JOIN IN SQL SERVER:
-Introduction to joins
-Types of joins
-Inner join
-Left outer join
-Right outer join
WRITING QUERIES:
-INSERT queries
-UPDATE queries
-DELETE queries
-TRUNCATE
-The select clause
-The from clause
-UNION
-SUB-QUERIES
-AND,OR operators
-Like operators
-Select into queries
T-SQL, STORED PROCEDURES, FUNCTIONS
-What is T-SQL
-Syntax conventions
-Identifires
-Operators
-Variables
-Case statements
TRIGGERS:
-Creating DML triggers
-Altering DML triggers
ADVANCED SQL SERVER
-Temporary tables
-Error handling
-Transactions.