MS SQL Server
Microsoft SQL Server is a leading relational database management system (RDBMS) renowned for its robust performance, scalability, and extensive feature set. It offers a comprehensive suite of tools for managing, querying, and analyzing data, making it a popular choice for enterprises of all sizes. SQL Server supports various data types, including structured, semi-structured, and unstructured data, catering to diverse business requirements. Its advanced security features, such as row-level security, encryption, and dynamic data masking, ensure data protection and compliance with regulatory standards. SQL Server integrates seamlessly with other Microsoft technologies, such as .NET Framework, Azure cloud services, and Power BI, enabling smooth development, deployment, and integration of applications.
| Time Slot | ||
|---|---|---|
| 9.00 AM to 1.00PM | 2.00 PM to 6.00PM | 6.00 PM to 9.00PM |
SQL Server Syllabus
SQL Server DataBase
Module Objectives:
-
Build database using Data Definition Language Statements Perform basic CRUD operations using Data Manipulation Language statements like Insert, Update and Delete Write and call Stored Procedures and Functions stored in database.
- Write and manage database triggers, cursors and Index.
Overview:
Microsoft SQL Server is one the most popular Relational Database Management System (RDBMS) used in Microsoft universe. It can be used for data storage as well as for data retrieval for applications which can be either on desktop or Web/Browse.
Platform
-
Linux (Fedora / Mandriva / Ubuntu) or Windows Host system
- Firefox, Chrome
Detailed Course Contents:
- Introduction to Basic Database Concepts
- E-R Modeling and Diagram
- Normalization
- Introduction to SQL Server
- Introduction to SQL
- DDL and DML Statements
- Working with Queries (DQL)
- Aggregate Functions
- Joins and Set Operations
- Implementation of Data integrity
- Working with Constraints
- Implementing Views
- Data Control language (DCL)
- Working with Indexes
- Writing Transact-SQL (T-SQL)
- Working with Stored Procedures and Functions
- Implementing Triggers
- Working with Cursors
- Transaction Control Language (TCL)
- Backup and Restore
- Advance Features