Showing posts with label performance tuning. Show all posts
Showing posts with label performance tuning. Show all posts

Friday, July 5, 2019

SSIS Online Training with ETL & DW (LIVE, Instructor Led)

SSIS Online Training with ETL & DW (LIVE, Instructor Led)


SSIS provides Data Extraction, Consolidation and Loading Options (ETL), SQL Server Coding enhancements, Data Warehousing and Customizations for SQL Server Developers, Administrators, BI Engineers and Data Analysts. In our LIVE Online Training, we deal with complete SSIS Design and Development including SCD, Profiling, Tuning and Fact Loads. All sessions are completely practical and realtime.


Pre-requisites:

Participant needs to have knowledge on SQL Server T-SQL Queries to join our Real-time Practical MSBI- SSIS Training Course.


Please visit for course details https://sqlschool.com/Ssis-Online-Training.html


Reach us:

contact@sqlschool.com

India: +91 (0)9666440801 USA: +1(510) 400-4845

Friday, June 28, 2019

Azure SQL Database DEV - LIVE Online Training

Azure SQL Database DEV - LIVE Online Training

Complete Real-time and Practical Azure SQL Database Training with Real-time Scenarios. This course includes complete practical approach to every detail of Azure SQL Database Development activities including On-premise to Azure Azure Database Migrations, Schema Migrations, Assessments, In-depth Query Tuning, Stretch Databases, Azure Shell, Power Shell, In - Memory Tables, Azure Search, Sharding, Application Connections and Azure CLI. This Azure SQL Database course also includes One Real-time Project on On-Premise to Azure Migration using DMA Tools.



Azure SQL DBA Online Training 

Practical implementation of Always-On Availability Groups [AOAG] in Windows Clusters as well as in LINUX Clusters. Additionally, this SQL DBA Training Course extents to Microsoft (Cloud) SQL Azure Migrations, Geo Replication, Azure DB Sync, Azure Database Tuning and Security Management. Study Material, MCSA SQL DBA Certification (70-764 & 70-765) with Real-time Projects for your Resume as also a part of this SQL DBA Training Course. Versions: SQL Server 2014, 2016, 2017 and 2019.



Please visit for Azure SQL Database Course: https://sqlschool.com/Azure-Training.html



Reach us [24x7]:

contact@sqlschool.com 

India: +91 (0)9666440801 USA +1 5104004845

Monday, August 7, 2017

Performance Tuning (Query Tuning)

SQL Server T-SQL Performance Tuning (Query Tuning)


This impeccable Query Tuning course is exclusively designed for SQL Developers, MSBI Developers and Database Consultants. Course includes Mid Level to Advanced Query Tuning Techniques including Memory Optimized Tables, Temporal Objects, LIVE Query Stats, Partitions, Stats, DTA, Index Plans, Execution Plans, DDM, SQL Buffer Space, In-Memory, Lookup Options, Query Store, Dynamic Objects, DOP, Query Priority Settings, more...!

Trainer : Mr Sai Phanindra T (11+ Yrs Exp)

Dur : 6 Days (1 Hr per day)
Course Fee : INR 4000/- (USD 60)

COURSE HIGHLIGHTS
 Daily Tasks Real-time Examples
 LIVE Execution Plans Perf. Baselines
 70-761 Certification 70-762 Certification


 

Thursday, March 30, 2017

SQL Server Performance Tuning at SQL School

SQL Server Performance Tuning at SQL School

This impeccable Query Tuning course is exclusively designed for SQL Developers, MSBI Developers and Database Consultants. Course includes Mid Level to Advanced Query Tuning Techniques including Memory Optimized Tables, Temporal Objects, LIVE Query Stats, Partitions, Stats, DTA, Index Plans, Execution Plans, DDM, SQL Buffer Space, In-Memory, Lookup Options, Query Store, Dynamic Objects, DOP, Query Priority Settings, more...!

SQL Server Performance Tuning Classes (Mid Level to Advanced Level). Registration applicable for previous students of SQL School.

Course details available at http://sqlschool.com/SQL-Performance-Tuning.html


Performance Tuning - LIVE Online Training Course

Completely Practical and Real-time. Total of 8 hours sessions.

Pre-requisites: Participant needs to complete our SQL Server T-SQL or MSBI (SSIS/SSAS/SSAS) courses. 

Training Type:1. LIVE Online Training
 2. Inhouse Classroom Training

Available Schedules : 6 30 AM / 11 AM / 6:30 PM (IST). Register Today


Contact:
     +91-9666440801 (India)
     +91-9542916779 (India)
     +91-(0)40 64577244 (India): 24x7
     +1-510-400-4845 (USA): 24x7