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

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 Pune

Regular Classes( Morning, Day time & Evening)

• Duration : 6 weeks

Weekend Training Classes( Saturday, Sunday & Holidays)

• Duration : 7 Weeks

Fast Track Training Program( 4+ hours classes daily)

• Duration : within 4 weeks

MS SQL trainer Profile & Placement

Our MS SQL Trainers

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

MS SQL (microsoft sql dba) Placement Training in Pune

• More than 90+ students Trained
• 92 percent Placement Record
• 78 Interviews Organized
• Placement Supported by InterviewDesk.com

MS SQL training Locations in Pune

Our Microsoft SQL DBA Training centers

• Aundh
• Baner Road
• Camp
• Chinchwad
• Deccan Gymkhana
• Karve Road
• Kothrud
• NIBM ROAD
• Pimpri Colony
• Sadashiv Peth
• Shivaji Nagar
• Yerwada

MS SQL training batch size in Pune

Regular Batch ( Morning, Day time & Evening)

• Seats Available : 6 (maximum)

Weekend Training Batch( Saturday, Sunday & Holidays)

• Seats Available : 4 (maximum)

Fast Track batch

• Seats Available : 5 (maximum)

MS SQL related training courses

• MS SQL Server Training in Pune with placement support
• PostgreSQL Training in Pune with placement support