Home / Business services / Computer & telco
Report Abuse | Email this Ad    Bookmark and Share Share
Post# A487107

Microsoft SQL Server LIVE Online Training (New York)

Posted on: Thursday, 11 January, 2018  20:33
Updated On: Saturday, 13 January, 2018  07:11
Expires On: Saturday, 12 January, 2019  03:33
Reply to: contact@sqlschool.com
Business Name: Software training
ABN: 500038
Address: sr nagar
Suburb: hyd
State: ACT
Postcode: 500038
Contact No: 9666440801
Email: contact@sqlschool.com
Website: www.sqlschool.com
 

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:

Land Line : +91 (0) 40 64577244 Mobile: +91 (0) 9666440801

Toll free (24x7): +91 (0) 9014341434

USA: +1 (510) 400-4845

Office Address:

108/2RT, Street No 2, Road No 1, Landmark : Beside SR Nagar Bus Stop

SR Nagar, Hyderabad - 38, India.

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.

Bookmark and Share Share
6 hits