SQL Server DBA Online Training
Introduction to SQL Server DBA SQL provide high quality database support which exceed performance expectations. SQL Database Administrator perform the task of monitoring of database server. SQL DBA manages the hundreds of SQL Server instances, SAN storage and security. MindMajix provides technical and practical training on SQL DBA where the trainee enhance complete knowledge on database theory, database design, RDMS, distributing computing architectures, storage, recovery etc.
Course Curriculum SQL Server Fundamentals & T-SQL Module Unit 1: SQL Server Introduction & Installation Topics - Topics- SQL Server Installation, Services & Authentication, SQL Server Components& Firewall, SSMS, Configuration Tools & SMO, Protocols & Server Aliases, Linked Servers & Types
Unit 2: SQL Server Tables & Data Topics- Table Design and T-SQL Data Types, INSERT & SELECT Options, Aliasing, Schemas Tables & File Group Usage, DELETE versus TRUNCATE
Unit 3: Basic Queries and JOIN Queries Topics - EXISTS, APPLY, WHERE, ORDER BY, GROUPING, HAVING, Sub Queries & Nested Queries, Bulk Operations – Local & Remote
Unit 4: Triggers and Cursors – Memory Limitations Topics - DML Triggers & Performance, INSERTED and DELETED tables, STATIC and DYNAMIC cursors, SCROLL & FORWARD_ONLY, LOCAL and GLOBAL cursors, KEYSET Cursors and Usage, Embedding Cursors in SPs
Basic SQL DBA Module Unit 5: Transaction Locks and Deadlocks Topics - Significance of LOCKS and Usage, Types of Locks and Lock Hints?, Isolation Levels Types & Usage, Choosing best Isolation Level, TempDB Issues with Isolation Levels, Recovery Models and Options, Choosing Best Recovery Model, Real-time Data Deployment Issues
Unit 6: SQL Server Jobs & Alerts Topics - Creating Jobs using UI, Creating Jobs using T-SQL Scripts, Understanding Job Steps and Schedules, Backup Schedules & Jobs using Scripts, Job Failures and History View, Enabling and Disabling Jobs, Job Activity Monitor and Agent Status, Alert System and DB MailConfiguration
Unit 7: Server Audits and DB Monitors Topics - Types of Audits and SQL Tools, Server level Audits and Error Logs, Activity Monitors and IO Usage Reports, SQL Profiler, Deadlock Graphs and Filters, DMVs for Query Audits, Tempdb Audits, DMFs for Index, Session and Log Audits, DMFs, DMVs for Queries, Tempdb Audits, Important Queries for DBCC, Important DMVs and DMFs Security Audits and Profiling
Advanced SQL DBA Module Unit 8: Database Maintenance Plans (SSIS) Topics - Database Maintenance Plan Strategies, Wizard Based DMPs and Schedules, Control Flow Tasks, Precedence Usage, Index Rebuilds and Reorganization, Deciding Fill Factor and PAD_INDEX Options, Managing MSDB and TEMPDB, Using NOTIFY OPERATOR task in DMP Using UPDATE STATISTICS and Agent, Maintenance Issues in Real-time
Unit 9: Server Updates and Upgrades Topics - Establish Downtime, Sample Notifications, PRIOR Maintenance activities, Precautions, Applying Patch/hot fix and Service Packs, Verifying Updates and SmokeTest Options, Understanding Upgrade Advisor Issues, Server Upgrades and Smoke Tests, Rollback Service Packs and Precautions, System Database Rebuilds
Unit 10: SQL Cluster Issues and Troubleshooting Topics - SQL Cluster Node Installation, QUORUM Check and DTC Settings, Connection Issues and Drains, SQL Cluster Configurations and Heartbeat, Security Issues with Solutions, Storage Issues with Solutions, Always-On (AAG) Groups and HA, Practical Considerations For HA
Our SQL Server DBA Online Training batches starts every day. You can attend a DEMO for free
We Provide Online Training On TIBCO BW Tableau QlikView TIBCO Spotfire SAS BI SAP Hybris Selenium Oracle DBA Oracle SOA Oracle Financials IOS Development Android Data Modeling- Erwin Performance Testing SFDC SAP UI5 SAP Hana
We offers You
1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions
Thank you Your feedback is highly important to improve our course material.
For Free Demo Please Contact INDIA: +91-9246333245, US: +1-2013780518, Email id: info@mindmajix.com http://bit.ly/1wFgewd