Normalizations:

• First Normal Form (1NF).
• Second Normal Form (2NF).
• Third Normal Form (3NF).
• Boyce Codd's Normal Form (BCNF).
• Fourth Normal Form (4NF).
• Fifth Normal Form (5NF).

Introduction to Microsoft SQL Server:

• What is MS SQL Server?
• What is the MS SQL Server database?
• Editions of MS SQL Server database.
• Features, Components and Tools of MS SQL Server.
• Starting to Stopping SQL Server Instances/Services.
• MS SQL Server - Environment Setup.
• Types of System Database in SQL.

MSQL Server Management Studio:

• MS SQL Server - Environment Setup.
• Types of System Database in SQL.

Introduction to SQL :

• Basics of SQL. Types of SQL Statements.
• DDL, DML, DQL, DCL and TCL.
• Create Database using Management Studio.
• Data types in SQL Server.
• Exploring DDL Statements on table using Management Studio.

DDL and DML Statements:

• Why write statements in frontends?
• Create, Alter, Drop and Insert table
• Update, Delete and Truncate statement

Working with Queries(DQL):

• Understanding Select Statements
• Utilization of Top, Distinct, Null etc… Keywords
• Using String and Arithmetic Expressions.
• Exploring Where Clause with Operators.
• Using Advanced Operators.
• Sorting data using Order By clause.
• Working with basic of Sub-Queries.

Aggregate Functions and Clause:

• Using functions in queries.
• Using predefined functions.
• Count, Sum, Min, Max, Avg.
• Group BY and Having Clause.
• Using Group By with Rollup and Cube.

Joins and Set Operations:

• Introduction to Joins.
• Inner Join.
• Outer Join.
• Self-Join.
• Cross Join.
• Co-related Sub Queries.
• Set Operations using Union, Union All, Intersect and Except.

Implementation of Data Integrity:

• Entity Integrity.
• Domain Integrity.
• Referential Integrity.
• Types of constraints.

Working with Constraints:

• Primary Key.
• Unique.
• Not NULL.
• Foreign Key.

Implementation Views:

• Introduction and Advantages of Views.
• Creating, Altering and Dropping Views.
• Advance Options while Creating a View.
• SQL Server Catalogue Views.

Data Control Language (DCL):

• Creating Users and Roles.
• Granting and Revoking of Roles and Privileges.
• Managing using Management Studio.

Stored Procedures and Functions:

• Introduction to stored procedures.
• Benefits of stored procedures.
• Creating, Executing, Modifying/ Altering, Dropping.
• Input-Output and Optional Parameters.
• System defined stored procedures and functions.
• User defined functions.

Final Assessment

Working with Indexes:

• Introduction Clustered and Non Clustered Index.
• Creating and Dropping Indexes.

Writing Transact-SQL (T-SQL):

• What is T-SQL?
• Scripts and Batches Declaring Variables.
• Using Statements.
• Working with Temp tables.
• Error Handling
• Using System Functions/Global Variables

Implementing Triggers:

• Introduction to triggers.
• Constraints v/s Triggers.
• Creating, Altering, Dropping triggers.
• For/Alter/Instead of triggers.
• Using Rollback Transactions

Working with Cursors:

• Creating Cursors.
• Cursors v/s Select.
• Types of cursors.
• Locks on cursors.
• Advantages of cursors.

Transaction Control Language (TCL):

• Introduction Transactions process.
• Types of transactions (Implicit, Explicit).
• Working with Locks, Types of locks.

Advance Features:

• Pivot Table.
• Common Table Expression.
• Ranking Functions Using BLOB data type.
• Using XML data type.

Final Assessment

Backup and Restore:

• Generating SQL Script.
• Executing SQL Script.
• Generating Change Script.
• Taking database backup.
• Restoring database using backup.
• Attaching and Detaching of database.

SQL Server Integration Service (SSIS):

• What is SSIS
• What is Data Integration
• Why SSIS
• How SSIS Works
• Requirements For SQL Server Integration Service
• What is The SSIS Package
• SSIS Tasks
• Example of Data Flow Task
• Example of Execute SQL Task

SQL Server Reporting Services (SSRS):

• What is SSRS?
• What is Data visualization?
• Why do we need visualization?
• Why SRS?
• SSRS Architecture
• Reporting Lifecycle
• Requirements for Reporting Services
• Reports in SSRS

Final Assessment

Live Project:

• Opportunity to work on Live Project.

Internship (Live Project):

• Internship under IT Companies.
• Get Full-Time Internship Certificate from IT Companies.

• Upon completion of Course Student will get Final Course Completion Certificate & together with Internship Certificate.

• Data Scientist/Data Analyst
• Business Analysts
• Business Intelligence Developer
• Backend Database Programmer

• Software Developer/Engineer
• Database Architect
• Database Administrator
• Database Admin