Dear visitor, at this moment Javascript is DISABLED in your browser.  For this website to work correct Javascript needs to be enabled in your browser.
  How to continue?  Follow this link to see instructions on how to enable Javascript in your browser.

  Once Javascript is enabled you will no longer see this message appear in your browser and our website will be fully operational.

Microsoft SQL Server Online Trainers

**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 , 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


**Please find the schedule & Plans** @

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

**Register for Free demo** @

http://sqlschool.com/register.html

Contact us today for SQL Practical Online Training

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:

Mobile: +91 (0) 9666440801

USA: +1 (510) 400-4845

**Office Address:**

101, Road No 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



  • Price: Check with seller
  • Category: Computer - Internet
  • Published date: July 18, 2018
  • Country : United States
  • Region : Georgia
  • City : Alto
  • City area : SR Nagar
  • Address : Flat #101, Road # 1, Beside Metro Station Gate D, SR Nagar, Hyd - 38 India

Other Related Ads

Leave your comment (spam and offensive messages will be removed)
    CAPTCHA Image