MS SQL Server

Book Demo

MS SQL Server

SQL Server, developed by Microsoft, is a relational database management system (RDBMS) designed to store, retrieve, and manage data. It is widely used in enterprise environments for various database applications, from transactional processing to business intelligence. Here’s an overview of SQL Server:

Training Modes:

Online Training
Corporate Training
Video Training

Training Highlights:

  • Queries, Joins
  • Query Tuning
  • Excel Imports
  • Excel Pivots
  • Complex joins
  • Complex SPs
  • Tuning Tools
  • Dynamic SQL
  • Ctes, TVPs
  • In-Memory Tables
  • Azure SQL Concepts
  • Azure DB Migrations
  • Azure DB Tuning
  • Azure DB Deployments

SQL Server

Brochure Download
Register Now

Council for Inclusive Development

24x7 LIVE Online Server (Lab) with Real-time Databases. Course includes ONE Real-time Project.

REGISTER TODAY!

Technical FAQs & Mastery Modules

No Content

No Content

No Content

No Content

No Content

No Content

No Content

No Content

No Content

  1. File Management System And Its Drawbacks
  2. Intro to Database Management System (DBMS)
  3. Types of DBMS systems
  4. Network DBMS (NDBMS)
  5. Hierarchical DBMS (HDBMS)
  6. Relational DBMS (RDBMS)

  1. SQL Server Versions and History
  2. Connecting To Server
  3. Authentication Modes
  4. SQL Server Authentication Mode
  5. Windows Authentication Mode
  6. SQL Server Management Studio and Tools

  1. Database Creation using GUI
  2. Database Creation using T-SQL Scripts
  3. DB Design using Files and File groups
  4. Pages and Extents
  5. Data File and Log File and Its features

  1. Why Business Integrity
  2. Features of Business Integrity
  3. Null / Not Null
  4. Default
  5. Candidate Keys
  6. Primary Key
  7. Unique Key / Alternate Keys
  8. Foreign Key
  9. Check Constraints
  10. Identity

  1. Unicode Vs. Non-Unicode
  2. Char, Varchar and Varchar (Max)
  3. nChar, nVarchar and nVarchar (Max)
  4. Numerical Data Types
  5. Currency Data Types
  6. Binary Data Types
  7. GUID Data Type
  8. Timestamp Data Type
  9. Bit Data Type
  10. Spatial Data Type

  1. Types Of SQL Commands
  2. Data Definition Language (DDL)
  3. Data Manipulation Language (DML)
  4. Data Control Language (DCL)
  5. Transaction Control Language (TCL)

  1. Simple Queries
  2. Filter Rows using Where Clause
  3. Filter Columns using Select Clause
  4. Sorting Data
  5. Concatenate Strings and Columns
  6. Working with Columns and Constants
  7. Group by and Aggregations
  8. Having Clause
  9. Top (n) and Top (n) Percent
  10. Union and Union All
  11. Intersect and Except
  12. ISNULL()
  13. Derived Tables
  14. Cube and Rollup Operators

  1. Inner Join
  2. Outer Join (Left, Right, Full)
  3. Self Join
  4. Cross Join

  1. Single Row Sub Queries
  2. Nested Sub Queries
  3. Co-Related Sub Queries
  4. Exists and Not Exists Functions

  1. String Functions
  2. Data Conversion Functions
  3. Date and Time Functions
  4. Aggregate Functions
  5. Ranking Functions
  6. Common Table Expressions (CTE)

  1. Heap Vs Indexes
  2. Clustered Index
  3. Non-Clustered Index
  4. Filtered Index
  5. Covered Index
  6. Create , Alter and Drop Indexes
  7. Statistics
  8. Performance Tuning of Queries

  1. Purpose Of Views
  2. Creating , Altering and Dropping Views
  3. Updateable and Non-Updateable Views
  4. Encryption and Schema Binding, with Check Option Options in Views
  5. Indexed Views

  1. Declaring Variables
  2. Local and Global Variables
  3. Local and Global Temp Tables
  4. IF…. ELSE
  5. While Loop
  6. Return Statement
  7. Table Variable Vs. Temp Tables
  8. Exception Handling with Try… Catch Blocks

  1. Need for Stored Procedures
  2. Creating , Altering and Dropping Stored Procedures
  3. Optional Parameters
  4. Input and Output Parameters
  5. Nested Stored Procedures
  6. Re-Compiler Stored Procedures
  7. Advantages and Disadvantages Stored Procedures
  8. Writing Complex Stored Procedures
  9. Writing Stored Procedures with Cursors

  1. Need for Cursors
  2. Types Of Cursors
  3. Forward_Only and Scroll Cursors
  4. Static, Dynamic and Keyset Cursors
  5. Visibility of Cursors

  1. Need for UDFs
  2. Creating, Altering and Dropping
  3. Types Of User Defined Functions
  4. Scalar Functions
  5. Inline Table Valued Functions
  6. Multi Statement Table Valued Functions

  1. Purpose of Triggers
  2. Creating, Altering and Dropping Triggers
  3. Types of Triggers
  4. For or After Triggers
  5. Instead Of Triggers
  6. Magic Tables (Inserted, Deleted)
  7. Rollback in Triggers

  1. Introduction
  2. Begin Transaction
  3. Commit Transaction
  4. Rollback Transaction
  5. Save Transaction
  6. Role Of Log File In Transaction Management
  7. Implicit Transactions
  8. Explicit Transactions

No Content

SQL Server is a robust and versatile platform capable of handling a wide range of database applications, from simple queries to complex enterprise solutions.

Why Choose Sql Server

  • 100% Real-Time and Practical
  • Concept wise FAQs
  • TWO Real-time Case Studies, One Project
  • 24/7 LIVE Server Access
  • Realtime Project FAQs
  • Course Completion Certificate
  • Placement Assistance
  • Job Support
REGISTER NOW
Scroll to Top