Coimbatore Others | Providing all Others in Coimbatore (Kovai) India

SQL School Training Institute is an ISO Certified Organization and Microsoft Learning Partner offering real-time, practical trainings exclusively on SQL Server Technologies - SQL Server Development (SQL Dev), SQL Database Administration (SQL DBA), Microsoft Business Intelligence and Data Warehouse (MSBI / DWH) Training. We also provide trainings on Microsoft SQL Azure and Power BI courses.

We offer Instructor-Led LIVE Online Training, Classroom Training and On-demand Video Training with COMPLETE REAL-TIME and INTERACTIVE Practical Sessions. All our training courses include Real-time Projects, Certifications, Weekly Mock Interviews, Placement, and Assistance and free 24x7 LIVE Online Lab.

All our Training sessions are COMPLETELY PRACTICAL.

Microsoft SQL Server &T-SQL Developer:

• SQL Server Architecture

• SQL Server 2014 / 2016 / 2017 - Installation

• Service Accounts and Authentication

• SQL Server Database Design & Planning

• SQL Server Table Design & Pages

• Table Compression Techniques

• Data Integrity Concepts and Column Value Consistency

• PRIMARY KEY, UNIQUE and IDENTITY Constraints

• SQL Server Views and Schema binding of Views

• Updatable Views and ALTER consequences

• JOINS, Sub Queries and Nested Queries

• Nested and Linking Tables

• Query Execution Plans and QO Components

• Stored Procedures and OUTPUT Parameters

• Dynamic SQL and Usage

• User Defined Functions, Table Return Values and Parameters

• Table Valued Parameters and Variables

• DDL Triggers and DML Triggers

• Cursors Usage and Limitations

• T-SQL Transactions Concepts & Types

• Locks and Memory Concepts & Locking Hints

• Blocking Issues and Open Transactions

• New Features in SQL Server 2016 & 2017

TWO Real-time Case Studies (Medicare and Online Grocery Stop)

Real-time Project @ Banking Domain

Microsoft SQL Server Performance (Query) Tuning

• QUERY TUNING - CTE, JOIN OPTIONS, STATS

• Using CTEs for Memory Based Query Pre-Fetch

• PARTITIONS and FULL TEXT SEARCH
• Role of Statistics in Query Tuning Process – Options

• Data Compression Types - ROW Level, PAGE Level

• INDEXED QUERIES, MISSING INDEXES

•Full Text (FT) Indexes for Query Tuning

• PERF. MONITORING, LIVE EXECUTION PLANS

• DATABASE TUNING ADVISOR (DTA) TOOL, DOP

• PERFMON COUNTERS, DDM

•Database Catalogs (FTC) and Storage Locations

•SAMPLED and DETAILED Query Scans. Fill Factor

•DTA: Usage, Sequential / Parallel Query Tuning

•DTA Tool for Multi-Database Connections

•Dynamic Data Masking (DDM) – Performance

•Data Migration Assistant (DMA) Tool



Microsoft Azure SQL Developer (Cloud)

• AZURE CLOUD & AZURE SQL DATABASE
•Azure Sources - Types, Microsoft Market Place
•Azure SQL & Databases - Need, Importance
•Virtual Machines and Azure SQL Database in VMs
• AZURE SQL DATABASE DESIGN
• AZURE SQL DATABASE CONFIGURATION
•DTU : Data Transaction Units : Architecture, Pools
•SQL Database – Cloud Database as a Service
•Executing T-SQL Scripts in Azure
•Subscription Options and Database Sources

• DEVELOP AZURE SQL DATABASE

•Data Migration Assistant (DMA) Tool

• AZURE SQL DATABASE MIGRATIONS

• INTEGRATING with AZURE SQL DATABASE

• ADVANCED T-SQL QUERIES IN AZURE

• Azure SQL DATABASE - QUERY TUNING

For free SQL Server Video Demo, please visit:

http://www.sqlschool.com/TSQL-Video-Training.html

Register today @ http://sqlschool.com/register.html

SQL School Training Institute

ISO 9001:2008 Certified Organization for Training

Authorized Microsoft Partner (ID# 4338151)

Regd: Sequel Gate Innovative Technologies Pvt. Ltd.

Call us:

India:

Office: +91 (0) 40 64577244 Mobile: +91 (0) 9666440801

Toll free (24x7): +91 (0) 90 1434 1434

USA: +1 (510) 400-4845

Office:

101, Road #1, 1st Floor, UMA Residency, Opposite Sindhu Travels,

SR Nagar, Hyd - 38 Mobile: (0) 9666640801

Website: http://sqlschool.com/

Follow us:

https://www.facebook.com/sequelschool

https://www.linkedin.com/company/sql-school

https://twitter.com/sequelschool