Microsoft SQL Server – IDA Career

Microsoft SQL Server

System for managing relational databases is called Microsoft SQL Server. A database server that stores and retrieves data as requested by other software applications.

Course Content

MODULE 1: INTRODUCTION TO RDBMS AND MICROSOFT SQL SERVER

Introduction to RDBMS concepts
Normalization Technique
SQL Server Architecture
Introduction to Microsoft SQL Server
Introduction to SQL Server Management Studio
Installation of SQL server Management Studio

MODULE 2: CREATING TABLES, DATABASES AND IMPORTING AND EXPORTING DATA

Introduction of Language Statements (DDL, DML, DCL, TCL)
Creating table and DDL commands
Introduction of Import and Export Wizard

MODULE 3: SQL CONSTRAINTS AND DATA TYPES

SQL Data Types
SQL Constraints
SQL Indexing

MODULE 4: SELECT STATEMENT AND WORKING WITH SORTING AND FILTERING DATA

Select Statement
SQL Distinct keyword
SQL Where Clause
SQL wild card concept
SQL Group by and Having clause
SQL CASE statements

MODULE 5: WORKING WITH MULTIPLE TABLES USING JOIN CONCEPT

Introduction of Join
Inner Join
Outer Join
Left Join
Right Join
Self Join
Cross Join
Concept of Nested Join with Where Clause

MODULE 6: USING DML TO MODIFY DATA

SQL Update Statement
SQL Insert Statement
SQL Delete Statement
SQL Transaction control Language

MODULE 7: USING BUILT IN FUNCTIONS

SQL Number Functions
SQL Date Functions
SQL Text Functions
SQL Special Functions

MODULE 8: USING SUBQUERIES CONCEPTS AND TABLE EXPRESSIONS

SQL Scalar Subqueries
SQL Multivalued Sub Queries
SQL Table Values Sub Queries
SQL Common Table Expression

MODULE 9: USING SET OPERATORS AND WINDOWS RANKING, AND AGGREGATE FUNCTIONS

SQL UNION, UNION ALL, INTERSECT AND EXCEPT
SQL CROSS APPLY operator
SQL RANK function
SQL DENSE_RANK function
SQL ROW_NUMBER function
SQL Over Clause

MODULE 10: PROGRAMMING WITH T-SQL AND STORED PROCEDURE

SQL If condition
SQL While Loop
Creating Stored Procedure
Modifying Stored Procedure

MODULE 11: WORKING WITH USER DEFINED FUNCTIONS

Creating User Defined Function
Modifying User Defined Function
SQL Pivot and Unpivot Concept

MODULE 12: APPLYING ERROR HANDLING CONCEPT IN T SQL PROGRAMMING

Implementing T-SQL Error Handling
Redirecting Errors with Try/Catch
Using THROW to pass an error message back to a client
Applying Error Handling in Stored Procedure
Applying Error Handling in Stored Procedure

MODULE 13: CONCEPT OF CURSOR AND INDEX

Introduction of Cursor
Creating cursor
Modifying cursor
Detailed description about Index

MODULE 14: PERFORMANCE TUNING

Query optimization
Performance Tuning

Explore More

Flexibility in Planning and Teaching

Theoretical Knowledge

Practical Skills

Individual Work with a Mentor

Final Individual Project

The premier destination for individuals seeking to elevate their professional skills and excel in their careers.

Book Your Live Demo Now !

Copyright © 2023 WebridgeTech Pvt Ltd All rights reserved.

+91-8130121986

info@idacareer.com