Course Design By
Nasscom & Wipro
Become a competent SQL Server developer. Enroll now to learn under a skilled SQL developer.
In collaboration with
20 Hrs.
Duration
Online/Offline
Format
LMS
Life Time Access
we train you to get hired.
SQL Server 2019 Installation
Service Accounts & Use, Authentication Modes & Usage, Instance Configurations
SQL Server Features & Purpose
Using Management Studio (SSMS)
Configuration Tools & SQLCMD
Conventions & Collation
SQL Database Architecture
Database Creation Using GUI
Database Creation Using T-SQL Scripts
DB Design Using Files And File Groups
File Locations And Size Parameters
Log Files And Placement
Database Structure Modifications
SQL Server Database Tables
Table Creation Using T-SQL Scripts
Naming Conventions For Columns
Single Row And Multi-Row Inserts
Table Aliases
Column Aliases & Usage
Table Creation Using Schemas
Basic INSERT
UPDATE
DELETE
SELECT Queries And Schemas
Use Of WHERE, IN And BETWEEN
Variants Of SELECT Statement
ORDER BY
GROUPING
HAVING
ROWCOUNT And CUBE Functions
Table Creation Using Constraints
NULL And IDENTITY Properties
UNIQUE KEY Constraint And NOT NULL
PRIMARY KEY Constraint & Usage
CHECK And DEFAULT Constraints
Naming Composite Primary Keys
Disabling Constraints & Other Options
Benefits Of Views In SQL Database
Views On Tables And Views
SCHEMA BINDING And ENCRYPTION
Issues With Views And ALTER TABLE
Common System Views And Metadata
Common Dynamic Management Views
Working With JOINS Inside Views
Need For Indexes & Usage
Indexing Table & View Columns
Index SCAN And SEEK
INCLUDED Indexes & Usage
Materializing Views (storage Level)
Composite Indexed Columns & Keys
Indexes And Table Constraints
Primary Keys & Non-Clustered Indexes
Why To Use Stored Procedures
Types Of Stored Procedures
Use Of Variables And Parameters
SCHEMABINDING And ENCRYPTION
INPUT And OUTPUT Parameters
System Level Stored Procedures
Dynamic SQL And Parameterization
Scalar Valued Functions
Types Of Table Valued Functions
SCHEMABINDING And ENCRYPTION
System Functions And Usage
Date Functions
Time Functions
String And Operational Functions
ROW_COUNT
GROUPING Functions
Why To Use Triggers
DML Triggers And Performance Impact
INSERTED And DELETED Memory Tables
Data Audit Operations & Sampling
Database Triggers And Server Triggers
Bulk Operations With Triggers
Cursor Declaration And Life Cycle
STATIC
DYNAMIC
SCROLL Cursors
FORWARD_ONLY And LOCAL Cursors
KEYSET Cursors With Complex SPs
ACID Properties And Scope
EXPLICIT Transaction Types
IMPLICIT Transactions And Options
AUTOCOMMIT Transaction And Usage
SAVEPOINT And Query Blocking
Complex SPs With Transactions
Linked Server And DTC Operations
Tips To Clear An Interview
Common Interview Questions And Answers
“SQL For Microsoft SQL Server” Interview Questions And Answers
Resume Building Guide
Attempt For The Related Global Certification Exam
Start Applying For Jobs
+ More Lessons
Course Design By
Nasscom & Wipro
Course Offered By
Croma Campus
Stories
success
inspiration
career upgrad
career upgrad
career upgrad
career upgrad
11-Oct-2025*
13-Oct-2025*
08-Oct-2025*
11-Oct-2025*
13-Oct-2025*
08-Oct-2025*
You will get certificate after
completion of program
You will get certificate after
completion of program
You will get certificate after
completion of program
in Collaboration with
Empowering Learning Through Real Experiences and Innovation
we train you to get hired.
Phone (For Voice Call):
+91-971 152 6942WhatsApp (For Call & Chat):
+91-971 152 6942Get a peek through the entire curriculum designed that ensures Placement Guidance
Course Design By
Course Offered By
Ready to streamline Your Process? Submit Your batch request today!
The Oracle/SQL training at Croma is highly interactive and practical. The best thing is that you don’t have to worry even you miss one or more LIVE sessions. You will get the recording of each class in LMS (Learning Management System) and use these recordings for future references too when you nee Read more...
Thank you Croma Campus for breaking down the subject in small and easy components. It made everything easy to understand. I appreciate your patience and style of teaching. I was worried in getting into Database testing training but the trainer helped me go through it. Each part of the training was e Read more...
In the current business market, there is a huge requirement for professional SQL Server DBA which is expected to increase due to the increased adoption of database Management.
Yes, the training is extremely beneficial for working professionals to enhance their knowledge and skills.
Yes, you will receive a course completion certificate from Croma Campus at the end.
Our instructors are experienced industry professionals who will impart high-quality knowledge.
No pre-requisites required.
FOR QUERIES, FEEDBACK OR ASSISTANCE
Best of support with us
An OTP on your submit Mobile No has been shared.please check and submit OTP
We’re the best training provider with rigorous industry-relevant programs designed and delivered in collaboration with world-class faculty, industry & Infrastructure.
Share some of your details and we will be in touch with you for demo details, and know about Batches Available with us!
By registering here, I agree to Croma Campus Terms & Conditions and Privacy Policy
Enter your email and phone number
For Voice Call
+91-971 152 6942For Whatsapp Call & Chat
+91-9711526942Talk to Career Counsellor
Stay ahead in your career with real-time salary updates.
By registering here, I agree to Croma Campus Terms & Conditions and Privacy Policy
We’re the experts in web design and development for the start up next door and the fortune 500.
What Benefit You will get from this Program
By registering here, I agree to Croma Campus1 Terms & Conditions and Privacy Policy
Share some of your details and we will be in touch with you for demo details, and know about Batches Available with us!