TamilNadu / Madurai Classifieds / Education / Educational Institutions

Warning: Avoid Scams and Fraud. Unless you are sure about the other party do not get involved in financial transactions
Microsoft SQL Server Classroom Trainers @ SQL School Training Institute (hyderabad)

Reply to: (Use contact form below)
(Please mention TamilnaduClassic.com when contacting)
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.

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


SQL Server/T-SQL & Performance Tuning & SQL Azure details:

http://sqlschool.com/TSQL-Classroom-Training.html

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

Contact us:

SQL School Training Institute

ISO 9001:2008 Certified Organization for Training

Authorized Microsoft Partner (ID# 4338151)

Regd: Sequel gate Innovative Technologies Pvt. Ltd.

India:

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

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

USA: +1 (510) 400-4845

OFFICE 1:
101, Road No 1, 1st Floor, UMA Residency, Opposite Sindhu Travels,
SR Nagar, Hyd - 38 Mobile: (0) 9666640801

OFFICE 2 :
Sai Anu Avenue, Street #3, Patrika Nagar, HITEC City, Hyd - 81 India: 0091 (0)9666640801

Website:

http://sqlschool.com/

Follow us:

https://www.facebook.com/sequelschool

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

https://twitter.com/sequelschool
Madurai Classifieds - Microsoft_SQL_Server_Classroom_Trainers_SQL_School_Training_Institute


Contact this User: 
 
Your email: *
Message: *
Attachment:
The following file types are not allowed: exe, com, bat, vbs, js, jar, scr, pif
Maximum file size: 200KB
 


Posted on: Tuesday, 20 March, 2018  06:52
Expires On: Thursday, 28 June, 2018  01:22

Your most reliable resource for Jobs, Cars, plots, ads, Houses, Flats, Builders, Madurai Real Estate, Services...

TamilNadu Classifieds - The Number 1 Madurai Classified Ads Portal for Madurai Educational Institutions Education