MS SQL SERVER DEVELOPER TRAINING IN BANGALORE

2546 Reviews
4.8/5
1880 Learners

Overview

Duration of Training: 8 weekends 

Watch
INTRO VIDEO

Why Radical Technologies

  • Highly practical oriented training
  • 25000+ Man-hours of Real-time projects & scenarios
  • 10 to 20+ year Experienced corporate trainers With Real Time Experience.
  • Building up professionals by highly experienced professionals
  • 100 % quality assurance in training .
  • 10000+ Placement Records and 180+ MNC’s and Consultancies Tie up

Check Batch Schedulings

Course Curriculum

Pre-requisites

There are no formal prerequisites for this course; however, previous operating system administration experience will be very beneficial.

Course Content

Foundations of Querying               

Understanding the Foundations of T-SQL               

Understanding Logical Query Processing 

 

2. Getting Started with the SE LECT Statement               

Using the FROM and SELECT Clauses

The FROM Clause

The SELECT Clause

Delimiting Identifiers               

Working with Data Types and Built-in Functions

Choosing the Appropriate Data Type

Choosing a Data Type for Keys

Date and Time Functions

Character Functions

CASE Expression and Related Functions

 

3. Filtering and Sorting Data               

Filtering Data with Predicates

Predicates, Three-Valued Logic, and Search Arguments

Combining Predicates

Filtering Character Data

Filtering Date and Time Data               

Sorting Data

Understanding When Order Is Guaranteed

Using the ORDER BY Clause to Sort Data               

Filtering Data with TOP and OFFSET-FETCH

Filtering Data with TOP

Filtering Data with OFFSET-FETCH

 

4. Combining Sets               

Using Joins

Cross Joins

Inner Joins

Outer Joins

Multi-Join Queries               

Using Subqueries, Table Expressions, and the APPLY

Operator

Subqueries

Table Expressions

APPLY               

Using Set Operators

UNION and UNION ALL

INTERSECT

EXCEPT

 

5. Grouping and Windowing               

Writing Grouped Queries

Working with a Single Grouping Set

Working with Multiple Grouping Sets               

Pivoting and Unpivoting Data

Pivoting Data

Unpivoting Data               

Using Window Functions

Window Aggregate Functions

Window Ranking Functions

Window Offset Functions

 

6. Creating Tables and Enforcing Data Integrity               

Creating and Altering Tables

Introduction

Creating a Table

Altering a Table

Choosing Table Indexes               

Enforcing Data Integrity

Using Constraints

Primary Key Constraints

Unique Constraints

Foreign Key Constraints

Check Constraints

Default Constraints

 

7. Designing and Creating Views, Inline Functions and Synonyms               

Designing and Implementing Views and Inline Functions

Views

Inline Functions               

Using Synonyms

Creating a Synonym

Comparing Synonyms with Other Database Objects

 

8. Inserting, Updating, and Deleting Data               

Inserting Data

INSERT VALUES

INSERT SELECT

INSERT EXEC

SELECT INTO               

Updating Data

UPDATE Statement

UPDATE Based on Join

Nondeterministic UPDATE

UPDATE and Table Expressions

UPDATE Based on a Variable

UPDATE All-at-Once               

Deleting Data

Sample Data

DELETE Statement

TRUNCATE Statement

DELETE Based on a Join

DELETE Using Table Expressions

 

9. Other Data Modification Aspects               

Using the Sequence Object and IDENTITY Column Property.

Using the IDENTITY Column Property

Using the Sequence Object               

Merging Data

Using the MERGE Statement               

Using the OUTPUT Option

Working with the OUTPUT Clause

INSERT with OUTPUT

DELETE with OUTPUT

UPDATE with OUTPUT

MERGE with OUTPUT

Composable DML

 

10. Designing and Implementing T-SQL Routines               

Designing and Implementing Stored Procedures

Understanding Stored Procedures

Executing Stored Procedures

Branching Logic

Developing Stored Procedures               

Implementing Triggers

DML Triggers

AFTER Triggers

INSTEAD OF Triggers

DML Trigger Functions               

Implementing User-Defined Functions

Understanding User-Defined Functions

Scalar UDFs

Table-Valued UDFs

Limitations on UDFs

UDF Options

UDF Performance Considerations

 

11. Implementing Transactions, Error Handling and Dynamic SQL               

Managing Transactions and Concurrency

Understanding Transactions

Types of Transactions

Basic Locking

Transaction Isolation Levels               

Implementing Error Handling

Detecting and Raising Errors

Handling Errors After Detection               

Using Dynamic SQL

Dynamic SQL Overview

SQL Injection

Using sp_executesql

 

12. Implementing Indexes and Statistics               

Implementing Indexes

Heaps and Balanced Trees

Implementing Nonclustered Indexes

Implementing Indexed Views               

Using Search Arguments

Supporting Queries with Indexes

Search Arguments               

Understanding Statistics

Auto-Created Statistics

Manually Maintaining Statistics

 

13. Understanding Cursors, Sets, and Temporary Tables               

Evaluating the Use of Cursor/Iterative Solutions vs. Set-Based Solutions

The Meaning of “Set-Based”

Iterations for Operations That Must Be Done Per Row

Cursor vs. Set-Based Solutions for Data Manipulation Tasks               

Using Temporary Tables vs. Table Variables

Scope

DDL and Indexes

Physical Representation in tempdb

Transactions

Statistics

 

14. Querying and Managing XML Data               

Returning Results As XML with FOR XML

Introduction to XML

Producing XML from Relational Data

Shredding XML to Tables               

Querying XML Data with XQuery

XQuery Basics

Navigation

FLWOR Expressions               

Using the XML Data Type

When to Use the XML Data Type

XML Data Type Methods

Using the XML Data Type for Dynamic Schema

Training Options

Live Online Training

  • Highly practical oriented training
  • Installation of Software On your System
  • 24/7 Email and Phone Support
  • 100% Placement Assistance until you get placed
  • Global Certification Preparation
  • Trainer Student Interactive Portal
  • Assignments and Projects Guided by Mentors
  • And Many More Features

Course completion certificate and Global Certifications are part of our all Master Program

Live Classroom Training

  • Weekend / Weekdays / Morning / Evening Batches
  • 80:20 Practical and Theory Ratio
  • Real-life Case Studies
  • Easy Coverup if you missed any sessions
  • PSI | Kryterion | Redhat Test Centers
  • Life Time Video Classroom Access ( coming soon )
  • Resume Preparations and Mock Interviews
  • And Many More Features

Course completion certificate and Global Certifications are part of our all Master Program

Exam & Certification

Course Reviews

I had a wonderful experience in Radical technologies where i did training in Hadoop development under the guidance of Shanit Sir. He started from the very basic and covered and shared everything he knew in this field. He was brilliant and had a lot of experience in this field. We did hands on for every topic we covered, and that’s the most important thing because honestly theoretical knowledge cannot land you a job.
Rohit Agrawal Hadoop
I have recently completed Linux course under Anand Sir and can assuredly say that it is definitely the best Linux course in Pune. Since most of the Linux courses from other sources are strictly focused on clearing the certification, they will not provide an insight into real-world server administration, but that is not the case with Anand Sir’s course. Anand Sir being an experienced IT infrastructure professional has an excellent understanding of how a data center works and all these information is seamlessly integrated into his classes.
Manu Sunil Linux
I had undergone oracle DBA course under Chetan sir’s Guidance an it was a very good learning experience overall since they not only provide us with theoretical knowledge but also conduct lot of practical sessions which are really fruitful and also the way of teaching is very fine clear and crisp which is easier to understand , overall I had a great time for around 2 months , they really train you well.also make it a point to clear all your doubts and provide you with clear and in-depth concepts hence hope to join sometime again
Reema banerjee Oracle DBA
I have completed Oracle DBA 11g from Radical technology pune. Excellent trainer (chetna gupta ). The trainer kept the energy level up and kept us interested throughout. Very practical, hands on experience. Gave us real-time examples, excellent tips and hints. It was a great experience with Radical technologies.
Mrudul Bhokare Oracle DBA
Linux learning with Anand sir is truly different experience… I don’t have any idea about Linux and system but Anand sir taught with scratch…He has a great knowledge and the best trainer…he can solve all your queries related to Linux in very simple way and giving nice examples… 100 🌟 to Anand Sir.
Harsh Singh Parihar Linux
Prev
Next

Why we are the best Radical Technologies

Radical Technologies is truly progressing and offer best possible services. And recognition towards Radical Technologies is increasing steeply as the demand is growing rapidly.

Creative

0%

Innovative

0%

Student Friendly

0%

Practical Oriented

0%

Valued Certification

0%

Training FAQs

Similar Courses

ENQUIRE NOW
[]
1 Step 1
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right
FormCraft - WordPress form builder