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 Azure SQL 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.
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 @
Register for Free
demo @
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:
Office: +91 (0) 40 64577244 Mobile: +91 (0) 9666440801
Toll free (24x7): +91 (0) 90 1434 1434
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
Follow us
