❱ Home / Assam / Tinsukia / Education / Tuition, Training Centres
Report Abuse | Email this Ad   Bookmark and Share Share

Post#A724210

SQL Server Online Training @ SQL School (Tinsukia)

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(24X7):

Mobile: +91 (0) 9666-44-0801

Mobile: +91 (0) 9666-64-0801

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 »

It is NOT ok to contact this poster with commercial interests.

Views : 45

Posted on: Tuesday, 10 July, 2018  02:26
Updated On: Wednesday, 11 July, 2018  04:19
Expires On: Wednesday, 10 July, 2019  02:26
Reply to: contact@sqlschool.com