MS SQL Training in Kolkata & Best Microsoft SQL DBA Training Institute in Kolkata

MS SQL Course Content

SQL Overview

• Outlining SQL as the cornerstone of database activity
• Applying the ANSI/ISO standards
• Describing the fundamental building blocks: tables, columns, primary keys and foreign keys

Building the Database Schema

• Creating tables and columns
• Building tables with CREATE TABLE
• Modifying table structure with ALTER TABLE
• Adding columns to an existing table
• Removing tables with DROP TABLE

Protecting data integrity with constraints

• Guaranteeing uniqueness with primary key constraints
• Enforcing integrity with foreign key constraints
• Imposing business rules with check constraints
• Enabling and disabling constraints
• Removing constraints with ALTER TABLE

Improving performance with indexes

• Expediting data retrieval with indexes
• Recommending guidelines for index creation

Manipulating Data

• Modifying table contents
• Adding table rows with INSERT
• Changing row content with UPDATE
• Removing rows with DELETE

Applying transactions

• Atomic Consistent Isolated Durable (ACID) rules
• Controlling transactions with COMMIT and ROLLBACK

Writing Single Table Queries

• Retrieving data with SELECT
• Restricting rows with the WHERE filter
• Sorting the result with ORDER BY
• Handling NULL values in expressions
• Avoiding NULL value pitfalls in filter conditions

Querying Multiple Tables

• Applying the ANSI/ISO standard join syntax
• Matching related rows with INNER JOIN
• Including nonmatched rows with OUTER JOIN
• Creating a Cartesian product with CROSS JOIN

Combining results with set operators

• Stacking results with UNION
• Identifying matching rows with INTERSECT
• Utilizing EXCEPT to find nonmatching rows

Employing Functions in Data Retrieval

• Processing data with row functions
• Conditional formatting with the CASE expression
• Utilizing the CASE expression to simulate IF tests
• Dealing with NULL values

Performing analysis with aggregate functions

• Summarizing data using SUM, AVG and COUNT
• Finding the highest/lowest values with MAX and MIN
• Defining the summary level with GROUP BY
• Applying filter conditions with HAVING

Constructing Nested Queries

• Applying subqueries in filter conditions
• Correlated vs. noncorrelated subqueries
• Testing the existence of rows

Including subqueries in expressions

• Placing subqueries in the column list
• Creating complex expressions containing subqueries
• Handling subqueries that return no rows

Developing In-Line and Stored Views

• Breaking down complex problems
• Selecting data from a query result set
• Subqueries in the FROM clause
• Creating views in a database
• Building reusable code
• Updateable vs. non-updateable views

MS SQL training duration in Kolkata

Regular Classes( Morning, Day time & Evening)

• Duration : 3 weeks

Weekend Training Classes( Saturday, Sunday & Holidays)

• Duration : 7 Weeks

Fast Track Training Program( 3+ hours classes daily)

• Duration : within 3 weeks

MS SQL trainer Profile & Placement

Our MS SQL Trainers

• More than 6 Years of experience in MS SQL Technologies
• Has worked on 6 realtime MS SQL projects
• Working in a MNC company in Kolkata
• Trained 1242+ Students so far.
• Strong Theoretical & Practical Knowledge
• MS SQL certified Professionals

MS SQL (microsoft sql dba) Placement Training in Kolkata

• More than 1242+ students Trained
• 879 students Placed
• 452 Interviews Organized
• Placement Supported by InterviewDesk.com

MS SQL training Locations in Kolkata

Our Microsoft SQL DBA Training centers

• Ballygunge
• Bamangachi
• Bangur Avenue
• Barasat
• Barrackpore
• Belgharia
• Chandannagar
• Chittaranjan Avenue
• Dumdum
• Gangapur
• Garia
• Gariahat Road
• Gopalpur
• Habra
• Hoogly
• Howrah
• Ichapur
• Jadavpur
• Kalani
• Kanchrapara
• Khardaha
• Lake Town
• Madhyamgram
• Naktala
• Park Street
• Rajpur
• Salt Lake City
• Santoshpur
• Sector-1
• Sonapur
• Ultadanga

MS SQL training batch size (students per class) in Kolkata

Regular Batch ( Morning, Day time & Evening)

• Seats Available : 6 (maximum)

Weekend Training Batch( Saturday, Sunday & Holidays)

• Seats Available : 8 (maximum)

Fast Track batch

• Seats Available : 5 (maximum)

Upcmoing ms sql Training Classes in Kolkata

Below are start date of MS SQL training classes in Kolkata with course start date, class timings, morning / evening / weekend training sessions along with total seats and available seats. To rigister or enuqire, Just give a missed call to 8099902902 anytime.

Start Date	Course Timings	Seats & Availability	Registration Status
25-Mar-2019	2.00 PM till 5.00 PM Regular Class	Total :6 Available: 4	Booking Open
28-Mar-2019	2.00 PM till 5.00 PM Regular Class	Total :6 Available: 2	Booking Open
01-Apr-2019	7.00 PM till 8.30 PM Evening Class	Total :6 Available: 3	Booking Open
05-Apr-2019	9.00 AM till 12.00 PM Fasttrack Class	Total :4 Available: 3	Booking Open
07-Apr-2019	10.00 AM till 4.00 PM (Sat & Sunday Only) Weekend Class	Total :4 Available: 4	Booking Open

MS SQL related training courses

• MS SQL Server course
• PostgreSQL course