+91 9392510244
hr@avinyatechnolabs.com
Menu
Apply Now

MS SQL Server Development

  • Home
  • MS SQL Server Development
Courses Images
Faculty Name: Mr. Salauddin
Duration: 30 Days

Course Description

Our MS SQL Server Development course is designed for individuals who want to master the skills needed to develop and manage databases using Microsoft SQL Server. Whether you're a beginner looking to learn SQL Server from scratch or an experienced database developer seeking to enhance your skills, this course will provide you with a comprehensive understanding of SQL Server development concepts and techniques. From database design and querying to stored procedures and performance optimization, you'll gain the knowledge and hands-on experience needed to succeed in SQL Server development roles.

Courses Categories

MS Sql Server Development Syllabus

Introduction, Installation

Data, Databases and RDBMS Software; Database Types: OLTP, DWH, OLAP, HTAP; Microsoft SQL: Purpose, Real-time Usage Options; SQL Versus Microsoft T-SQL [MSSQL]; Microsoft SQL Server - Career Options; Real-time Projects & Job Responsibilities; Versions and Editions of SQL Server; SQL Server Pre-requisites: SQL Server 2022 & 2019: Installation; SSMS
  1. DDL (Data Definition Language)
  2. DML (Data Manipulation Language)
  3. DQL (Data Query Language)
  4. DCL (Data Control Language)
  5. TCL (Transaction Query Language)
  1. NOT NULL
  2. UNIQUE
  3. PRIMARY KEY
  4. CHECK
  5. DEFAULT
  6. FOREIGN KEY
  1. INNER JOIN
  2. LEFT JOIN
  3. RIGHT JOIN
  4. FULL JOIN
  5. CROSS JOIN
  6. SELF JOIN
  1. ALL
  2. AND
  3. ANY
  4. BETWEEN
  5. EXISTS
  6. IN
  7. LIKE
  8. NOT
  9. OR
  1. System Functions
  2. String Function
  3. Date Function
  4. CAST and CONVERT
  5. Aggregate
  6. Mathematical
  7. Scalar Function
  8. Multi-Statement Table Valued Function
  9. Inline Table Valued Function
  1. Correlated Subqueries
  2. Scalar Subqueries
  1. Recursive CTEs
  2. Non-Recursive CTE
  3. Nested CTE
  1. Local Temp Tables
  2. Global Temp Tables
  1. Local Variables
  2. Global Variables
  3. Table Variables
  1. Simple Stored Procedure
  2. Input Parameters
  3. Output Parameters
  4. Optional Parameters

Triggers

  1. FOR Triggers: - AFTER INSERT, UPDATE, DELETE
  2. Instead of Triggers: - BEFORE INSERT, UPDATE, DELETE
  1. Simple View
  2. Complex View
  3. Indexed Views (Materialized View)
  4. Schema binding View
  5. Check Option View
  1. Execute (@Result)
  2. sp_executesql (@Result)
  1. (ACID - properties), Error handling
  1. Pivot, unpivot
  1. Implicit Cursors
  2. Explicit Cursors
  1. First Normal Form (1NF)
  2. Second Normal Form (2NF)
  3. Third Normal Form (3NF)
  4. Boyce-Codd Normal Form (BCNF)
  1. Clustered Index
  2. Non-Clustered Index
  3. Column Store Index
  4. Covering Indexes
  1. SCOPE_IDENTITY
  2. IDENT_CURRENT
  3. @@IDENTITY
  4. DBCC CHECKIDENT
  1. Actual Execution Plan
  2. Estimation Execution Plan
  1. Import Export wizard and Data Migration