iBase Training

Official Website

SQL DBA Online Training Course Content by corporate experts

 

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

 

 

Student Registration

Name

Email Id

Country Code

Mobile No

Course Name

City