Sql Server Training

(3) 3 Ratings

Course Schedule

30

JUL

Mon - Sat

07:30 PM - 10:00 PM ( IST )

06

AUG

Mon - Fri

11:00 AM - 02:00 PM ( IST )

11

AUG

Sat - Sun

05:30 AM - 06:30 AM ( IST )


Total Learners

850 Learners


LMS Access

365 days

Course duration

30 days


Support

24/7 support

Can't find convenient schedule?

Our experts can help you find a batch that meets your needs

The Instructor for this course is from one of the Big5 Companies in the world.

Drop us a Query

I agree to the Training T&C

Modes of Training

Corporate Training

Live, Classroom Or Self Paced Training

Online Classroom

Attend our Instructor Led Online Virtual Classroom

Self Paced Training

Comprehensive Recorded Videos by Experts to learn at your own pace

Course Features

Live Instructor-led Classes

This isn't canned learning. Its dynamic, its interactive, its effective

Expert Educators

Only the best or they're out. We are constantly evaluating our trainers

24&7 Support

We never sleep. Need something answered at 3 am? No Problem

Flexible Schedule

You don't learn as per our calendar. We work according to yours

☰ Details

Course Curriculum

SQL Server Introduction & Installation

  • SQL Server 2012 Installation
  • Service Accounts & Use, Authentication Modes & Usage, Instance Configurations
  • SQL Server Features & Purpose
  • Using Management Studio (SSMS)
  • Configuration Tools & SQLCMD
  • Conventions & Collation 

SQL Server 2012 Database Design

  • 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 Tables & Data

  • 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.

Data Validations and Constraints Need for Data Integrity

  • 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 

SQL Optimization& Performance

  • Detailed understanding of SQL Server Management Studio.
  • Learning what is Pivot in Excel and SQL Server 
  • XL path
  • Differentiating between Char.
  • Varchar and NVarchar 
  • Working with Indexes.
  • Creation of Index   
  • Modifying data.
  • Creation of clustered indexes.        

Stored Procedures and Benefits

  • 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 

User Defined Functions and Usage

  • 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 

Cursors – Memory Limitations

  • Cursor declaration and Life cycle
  • STATIC
  • DYNAMIC
  • SCROLL Cursors
  • FORWARD_ONLY and LOCAL Cursors
  • KEYSET Cursors with Complex SPs 

User Defined Functions and Usage

  • 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 

Course Description

What you will learn in this SQL Server Training Course?

  1. Learn the SQL architecture, client/server relation and database types
  2. Deploy various functions and operators to design relational databases
  3. Modify data using T-SQL, Views and Stored Procedures
  4. Concepts of Trigger and creation of Triggers
  5. Use records for searching, sorting, indexing and grouping
  6. Learn about Database Administrators, types, SQL Server tools and Services
  7. Backup and restoration of databases

What are the Pre-requisites of this Course?

Participants are required to have basic knowledge of computers. Although it is not necessary, having knowledge of any programming language will be added advantage.

Who should Attend this SQL Server Training Course?

  • Software developers and IT professionals
  • SQL and database administrators
  • Project Managers
  • Business Analysts and Managers
  • Business Intelligence professionals
  • Big data and Hadoop professionals
  • Those aspiring for a career in SQL development.

FAQ

Do you have self paced training?

Yes, we offer self paced training

How do you provide training?

We offer three different modes of training. Instructor Led Live Training, Self Paced Training and Corporate Training

Do you offer any discounts?

Yes we offer discounts for group of 3 plus people.

Can I choose timings that suits my schedule?

Yes we are the only company where we work with students and offer flexible timings which fits your schedule

Who are the Instructors?

All our instructors are from MNC companies who have real time experience of more than 10 years.

Can I attend a demo session before joining?

Yes we offer a free demo session with the instructors. The trainer will answer all your queries and share the course agenda.

Course Reviews

Murthy

Had a Great Experience in Learning Sql Server Course Training. Trainer has good knowledge in sql server Concepts. Highly Recommended.

John

Nice and Excellent Training. Team is very Supportive and Trainer has a good Real-Time Experience.

Shilpa

Great Experience in Learning this Course. i have gained much knowledge in all the Topics. Thank you.