Trainings :      +91 889 8888 448    |    Certifications :      +91 868 8881 863
SQL
Server Database Design
SQL
Server Tables Design
Normal
Forms, Keys & Connstraints
Views,
JOINS and Sub Queries
Views
with Joins - Queries
Indexes
amd Query Tuning
Stored
Procedures & Query Tuning
User
Defined Functions (UDF) and Queries
Triggers
- Usage, Memory Limitation
Cursors,
Joins and Queries
Transaction
annd Stored Procedures
Locks,
Deadlocks & Live Locks
Backups -
Architecture and Management
Restores
- Architecture and Management
Jobs:
Architecture and Monitoring Options
Replication
- Architecture, HA & DR
Log
Shipping - Disaster Recovery(DR)
DB
Mirroring - High Availability & DR DB Mirroring
Architecture
& Use
Security
- logins, Users & Roles
Audits
For Database, Server & Queries
Data
Imports, Exports(SSIS) and DB Mall
SQL DBA
Checklist, SLA Process
Performance
Turning - Partitions & Indexes
Performannce
Turning - Full Text Indexes
Query
Turning - Index Management & DTA
Management
- Database Maintenance Plans
Alerts
and Troubleshooting + DAC
DB
Migrations, Service Packs, Upgrades
Introduction
to SQL Server Clusters
Active
Directory and MSDTC
SQL
Cluster Configuration
Cluster
Issues & Management
Always-On
Availability Groups (AAG)
IT Networks © 2019-20 | All Rights Reserved
Powered by Best Digital Marketing Courses in Bangalore