SQL DBA real time online training ,interview support from USA

FOR FREE DEMO contact :
Email :
Phone/WhatsApp : +91-8106721223
USA Number : +1-650-993-1007
Gtalk :
WebSite: http://www.ibasetraining.com


SQL Introduction & Installation
 SQL Server Installation
 Services & Authentication
 Configurations Checker Tool
 Management Studio(SSMS) Tool
 Configuration Tools & SMO
 Protocols & Server Aliases
 SQL Server Database Design
 SQL Database Design
 Files & File Group Options
 Data File Recommendations
 Log File Recommendations
 Database Options & Sizing
 SQL Server Tables Design
 Table Design and Types
 T-SQL Data Types & Use
 INSERT & SELECT Options
 Tables & Filegroup Usage
 INSERT and UPDATE Queries
 Data Validations & Constraints
 Constraints and Keys
 Normalization and BCNF
 UNIQUE KEY and NOT NULL
 PRIMARY KEYS & Usage
 CHECK, DEFAULT, REFERENCES
 Composite Keys & Types
 SET Options & Sub Queries
JOINS and Sub Queries
 WHERE, IN and SWITH Options
 EXISTS, APPLY, BETWEEN
 ORDER BY, GROUPING, HAVING
 Sub Queries
 Nested Queries & Usage
 Views with Nested Joins
 Views as Virtual Objects
 Views as Physical Objects
 SCHEMABINDING, ENCRYPTION
 Issues with ALTER TABLE
 System Views & Joins
 Views with Joins and Views
 Indexes and Query Tuning
 Architecture of Table Indexes
 Clustered & NonClustered
 Execution Plans and Rules
 Indexes & Performance
 Unique Indexes and Uses
 Working with Indexed Views
 Stored Procedures & Benefits
 Stored Procedures & Use
 Variables and Parameters
 SCHEMABINDING, ENCRYPTION
 System Stored Procedures
 Dynamic SQL and Temp Tables

Functions(UDF) and Usage
 Functions Use & Types
 Scalar Valued Functions
 Table Valued Functions
 SCHEMABINDING, ENCRYPTION
 System Functions and Events
 Date, Time, String Functions
 Triggers and Cursors
 Why to use Triggers?
 DML Triggers & Performance
 INSERTED and DELETED tables
 Database and Server Triggers
 Cursor declaration Options
 STATIC and DYNAMIC cursors
 SCROLL & FORWARD_ONLY
 LOCAL and GLOBAL cursors
 Transaction Concepts
 Transaction Types & Use
 Blocking – DML Operations
 Blocking – DDL Operations
 COMMIT & ROLLBACK Options
 Transaction Locks & Deadlocks
 LOCKS – Significance & Use
 Lock Types
 Isolation Levels & Usage
 Choosing Isolation Levels

Database Backups Strategies
 Backups Usage and Formats
 Database & Partial Backups
 FORMAT, INIT, CHECKSUM
 Backup with T-SQL & UI
 MSDB History Tables Audits
 Compressed Backups & Expiry
 Database Restores & Recovery
 Need for Restores and Types
 Backup Verifications
 Restore and Recovery Path
 DB, File Group, File Restores
 PARTIAL & Piecemeal Restores
 SQL Jobs
 Backup Schedules & Jobs
 Job Step Creation & Options
 Alert System
 Replication Configurations
 Replication for DR Process
 Snapshot and Transactional
 Merge Replication & Recovery
 Peer-Peer Initialization
 Replication – PUSH & PULL

Log Shipping & DB Recovery
 Disaster Recovery Solutions
 Log Shipping Modes
 NORECOVERY and STANDBY
 LS Jobs, Schedules & Alerts
 LS Monitor Reports
 Database Mirroring
 COPY_ONLY & INIT Backups
 DB Mirroring Configuration
 Security and Data Encryption
 Levels of SQL Security
 Server Logins & DB Users
 Server Roles and Mappings
 Schema Level Security
 Database Roles and Security
 SQL Server Audits
 SQL Audits and SQL Tools
 Server Audits and Error Logs
 Realtime Implementations
 DBA Challenges in Realtime
 Partitions and Query Tuning
 Table Partitions and Tuning
 Partition Functions & Schemes
 Index Management
 Index Fragmentation & Issues
 Alerts and Troubleshooting
 LOG SPACE Issues & Solutions
 TEMPDB Issues & Solutions
 MEMORY Issues & Solutions

Windows Cluster Configuration
 Windows Licensing
 SQL Licensing
 SQL Cluster Configuration
 SQL Cluster Introduction
 Verifying Configurations
 Add Nodes to SQL Cluster
 Cluster Issues & Solutions
 Introduction

For course content please follow the link :http://ibasetraining.com/sql-dba-hands-on-online-training-job-support-from-india/