UrbanPro
true

SQL Server Training in Pune

LIVE
12 reviews
1 Hour

Course offered by Enosis Learning

133 reviews

Enosis Learning is Providing Training on Sql Server 2012 with practical exposure.

Topics Covered

Introducing SQL Server

  • What is SQL Server
  • Architecture of SQL Server
  • SQL Server Editions
  • Installing SQL Server
  • Sql Server Instances
  • Internals of Sql Server Database
  • MDF & LDF Files

 

Basics of Database Design

  • Normalization
  • Denormalization
  • Introducing SQL Server Management Studio
  • Creating a Database
  • Data Types
  • Designing Table Model
  • Creating Tables
  • Alteration of Table Design
  • Drop Table

 

Constraint in SQL SERVER

  • What is Constraint
  • Adding constraints to columns in Tables
  • Primary Key Constraints
  • Unique Constraints
  • Check Constraints
  • Default
  • Alter Constraints
  • Drop Constraints

 

Writing  Queries

 

  • INSERT queries
  • UPDATE queries
  • DELETE queries
  • TRUNCATE
  • The SELECT Clause
  • The FROM Clause
  • The WHERE Clause
  • Mathematical Operator
  • Conditional Operators
  • AND , OR Operators
  • Like Operators
  • The ORDER BY Clause
  • Aggregate Functions
  • String Functions
  • Date Functions
  • Using GROUP BY and HAVING
  • Using TOP N and TOP N PERCENT
  • OFFSET & FETCH
  • SELECT INTO queries
  • SUB-QUERIES
  • UNION
  • CTE
  • CUBE & ROLLUP
  • RANK

 

Relational Database

  • Introduction to RDBMS
  • Why Relational Model
  • Advantages of Relational Model
  • Master Table & Child Tables
  • Introduction to Foreign Key
  • Creating Relations between tables

 

 

JOINS IN SQL SERVER

 

  • Introduction to Joins
  • Types of Joins
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Self Join
  • Writing Joins queries

 

 

T-SQL

  • What is T-SQL?
  • Syntax Conventions
  • Executing SQL Statements
  • Identifiers
  • Operators
  • Variables
  • Using T-SQL to Build and Alter Objects
  • If – else statements
  • Case statements
  • Looping statements
  • Identity statements

 

Stored Procedures, Functions

 

  • Introduction to Stored Procedures
  • Writing Stored Procedures
  • Alteration of Processing
  • Using/Calling Procedures
  • Using Input & Output Parameters
  • Introduction to Functions
  • Writing Functions
  • Types of functions
  • Scalar Functions
  • Table Value Functions

 

Triggers

  • Introduction to Triggers
  • Creating DML Triggers
  • Altering DML Triggers
  • Types of Trigger
  • Instead of Triggers
  • After Triggers
  • Using the Inserted and Deleted Tables
  • Auditing Data using Triggers

 

Views

  • Introduction to Views
  • Creating Views
  • Alteration of Views
  • Types of Views

 

Indexes

  • Introduction to Indexes
  • Types of Indexes
  • Creating Indexes
  • Best Practices of Indexes Creation

 

 

 

Cursors

  • Introduction to Cursors
  • Types of Cursors
  • Creating Cursors

 

 

 

Advanced SQL-SERVER

  • Temporary Tables
  • Table Variables
  • Error Handling
  • Transactions
  • Authentication Modes in SQL SERVER
  • Creating Users
  • Backup
  • Types of Backups
  • Restore
  • Shrinking
  • Email configuration in SQL SERVER.
  • Creating Operators
  • Automating Tasks using Jobs
  • Fragmentation
  • Query Optimization Techniques
  • Execution Plan of SQL SERVER
  • Query Lifecycle
  • Execution Lifecycle of a query
  • Statistics

Who should attend

AnyBody

Pre-requisites

Graduate

What you need to bring

Dedicated Time""""

Key Takeaways

Knowledge Materials Code Demo Databases

Gallery (14)

+7 more

About the Trainer

4.7 Avg Rating

133 Reviews

138 Students

15 Courses

Enosis Learning

Computer Experts

Trainer are having experience of 10+ Years

Reviews (12)

4 out of 5 12 reviews

Enosis Learning https://www.urbanpro.com/assets/new-ui/institute-100X100.png Visharant Wadi
4.60512
Enosis Learning
S

SQL Server Training in Pune

"Part of sql training and its completely helpful Trainers are good. Nice Environment, provide installment facility for payment. "

Enosis Learning
B

SQL Server Training in Pune

"Enosis is very good training center as well as classes in sql server and excellent in backend support with all .net framework .in enosis prajakta mam is very cleaver teacher in sql. "

Enosis Learning
S

SQL Server Training in Pune

"Good supportive staff.easy way teaching. Prajakta ma'am was there to teach us. Very friendly and easy to ask help. "

Enosis Learning
P

SQL Server Training in Pune

"Excellent faculty with good technical knowledge. I have good exp over here. Overall nice faculty."

View All
Have you attended any class with Enosis Learning?

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

4 out of 5 12 reviews

Enosis Learning https://www.urbanpro.com/assets/new-ui/institute-100X100.png Visharant Wadi
4.60512
Enosis Learning
S

SQL Server Training in Pune

"Part of sql training and its completely helpful Trainers are good. Nice Environment, provide installment facility for payment. "

Enosis Learning
B

SQL Server Training in Pune

"Enosis is very good training center as well as classes in sql server and excellent in backend support with all .net framework .in enosis prajakta mam is very cleaver teacher in sql. "

Enosis Learning
S

SQL Server Training in Pune

"Good supportive staff.easy way teaching. Prajakta ma'am was there to teach us. Very friendly and easy to ask help. "

Enosis Learning
P

SQL Server Training in Pune

"Excellent faculty with good technical knowledge. I have good exp over here. Overall nice faculty."

Enosis Learning
M

SQL Server Training in Pune

"Good teaching staff, i have joined class from 3 month, i have a great experience teacher solved my all doubt. "

Enosis Learning
R

SQL Server Training in Pune

"Very Helpful Faculty, They have concentrated on practical rather than theory, Excellent and Deep Knowledge has been provided by Prajakta Mam. "

Enosis Learning
M

SQL Server Training in Pune

"Prajkta mam is the trainer who give all conceptional clarification, go for it. All the courses which are going on are better. All trainers are trained good. Best institute. Asp.net is other course that the aruna mam and dilip sir teaches with all clarification of concepts. "

Enosis Learning
P

SQL Server Training in Pune

"I have learnt SQL and .net from enosis the training was awesome. I have cleared all my doubts and concepts."

Enosis Learning
P

SQL Server Training in Pune

"Best teaching staff and supportive staff. All notes are provided by the class only. This institute provides courses of java,mvc,dot net etc.All the faculty members are experienced. "

Reply by Enosis

Thank You So Much For Your Valuable Review !

Enosis Learning
S

SQL Server Training in Pune

"Currentely i am enrolled in sql server course. Nice study material provided. Teaching faculty is also very good. Individual attention provided to students . Pc provided to students. Looking forward for more. "

Reply by Enosis

Thank You So Much For Your Valuable Review !

Enosis Learning
M

SQL Server Training in Pune

"All the teachers are very supportive. This institute is good for .net also. Teaching is also nice. "

Reply by Enosis

Thank You So Much For Your Valuable Review !

Enosis Learning
P

SQL Server Training in Pune

"It was nice and helpful to learn all concepts of SQL server software from Dilip Parghi Sir. Allowing students to do practice every day is the plus point of Enosis Learning. Thank you. "

Have you attended any class with Enosis Learning?

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

SQL Server Training in Pune by Enosis Learning

enosis learning picture
LIVE
(12 reviews)

Class
starts in

00

Days

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

SQL Server Training in Pune by Enosis Learning

enosis learning picture
LIVE
(12 reviews)

Class
starts in

00

Days

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more