After completion of this training you can become a MS SQL Developer. This is also required to become a Full Stack .Net Developer

Below are the topics covered in this training:

SQL Fundamentals:
Introduction to SQL: Understanding what SQL is and its role in database management.
Basic SQL Commands: SELECT, INSERT, UPDATE, DELETE statements for data manipulation.
Filtering and Sorting: Using WHERE and ORDER BY clauses.
Functions: Aggregate functions (SUM, AVG, COUNT), string functions, date functions.
Joining Data: Combining data from multiple tables using JOIN operations (INNER, LEFT, RIGHT, FULL).

Transact-SQL (T-SQL):
T-SQL Programming: Variables, control flow (IF/ELSE, WHILE loops), stored procedures, functions, triggers.
Error Handling: Implementing TRY...CATCH blocks.
Dynamic SQL: Constructing and executing SQL statements dynamically.

Database Design and Management:
Database Design Principles: Normalization, data modeling (ER diagrams).
Creating and Managing Databases: CREATE DATABASE, ALTER DATABASE, DROP DATABASE.
Table Management: CREATE TABLE, ALTER TABLE, DROP TABLE, constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK).
Indexing: Understanding and implementing indexes for performance optimization.