This sql server course can be taken by any beginner who wants to build career in Information Technology. The subscriber needs to have working knowledge of Windows Operating System.
Module 1:- Introduction to Basic Database Concepts. Module 2:- E-R Modeling and Diagram.
Module 3:- Normalization. Module 4:- Introduction to SQL Server.
Module 5:- Introduction to SQL. Module 6:- DDL and DML Statements.
Module 7:- Working with Queries (DQL). Module 8:- Aggregate Functions.
Module 9:- Joins and Set Operations. Module 10:- Implementation of Data integrity.
Module 11:- Working with Constraints. Module 12:- Implementing Views.
Module 13:- Data Control language (DCL). Module 14:- Working with Indexes.
Module 15:- Writing Transact-SQL (T-SQL). Module 16:- Working with Stored Procedures and Functions.
Module 17:- Implementing Triggers. Module 18:- Working with Cursors.
Module 19:- Transaction Control Language (TCL). Module 20:- Backup and Restore. Module 21:- Advance Features
In this module we will learn about ranking functions and about how to use xml datatype.