SQL DBA Training Sessions with Realtime Database Access

SQL School (Regd: SequelGate Innovative Technologies Pvt. Ltd.) is a premier training institute providing Realtime and Practical Trainings exclusively on SQL Server technologies. SQL School has been providing the best possible Online Trainings, Classroom Trainings and Video Trainings for more than SEVEN years. Our training courses include SQL Server Development, SQL Server Database Administration (SQL DBA), Microsoft Business Intelligence (MSBI) and Windows & SQL Azure. At SQL School, we provide Complete Realtime and Practical Trainings with Realtime Projects and Free Job Support services on Microsoft SQL Server 2008, R2 and SQL Server 2012.

SQL School (Regd: SequelGate Innovative Technologies Pvt. Ltd.)

 

SQL School is one of the pioneers IT Institutions providing specialized in SQL Server 2012 DBA Training. We have been providing Online Training, Classroom Training and Corporate Training for the last SEVEN years. All our sessions are completely Practical and Real-time.

SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAINING

  • SQL Server Basics
  • SQL Server Design Architecture
  • SQL Server 2008 R2 – Installation
  • SQL Server 2012 – Installation
  • SQL Server Service Accounts and Configurations
  • TCP/IP and Named Pipes Configurations
  • Authentication Modes and Authorization Techniques
  • Collation and File Stream Settings
  • SQL Server Database Design & Planning
  • SQL Database: FileGroups and Files
  • Log File Sizing and Placement
  • SQL Server Table Design & Pages
  • INSERT, UPDATE and DELETE
  • SELECT and Inner Queries
  • DELETE versus TRUNCATE
  • SELECT INTO and INSERT..SELECT statements
  • Table Compression Techniques
  • Data Integrity & Consistency
  • SQL Server Views and Schemas
  • Schema Binding and Encryptions
  • JOINS and Sub Queries
  • Nested Queries and Linking Tables
  • Uses of Indexes and Performance
  • Stored Procedures and User Defined Functions
  • DDL Triggers and DML Triggers
  • Cursors Usage and Limitations
  • Table Variables and Temporary Tables
  • T-SQL Transactions Concepts & Types
  • Locks and Memory Concepts & Locking Hints
  • Blocking Issues and Open Transactions
  • New Features in SQL Server 2012

 

  • Choosing the best Isolation Level
  • Lock Hints and Adminsitration
  • Blocking & Deadlocks Issues
  • Backup Strategies & Backup Types
  • Backup Options and Audits
  • Point-In-Time, Partial and Piecemeal Restores
  • Restore Audits and MSDB
  • Backup Jobs and Schedules
  • Replication Techniques and Types
  • Replication Monitor and Warnings
  • Peer – Peer Replication Topology and Limitations
  • Log Shipping Modes and Issues
  • Manual Failover Process and Syncup Issues
  • DB Mirroring and Encryption
  • Automatic Failover and EndPoint Security
  • SQL Server Security & Client Security
  • Database & Object Security
  • Security Issues and Audits
  • Data Level Encryptions and Data Security
  • Credentials, Proxies and Job Security
  • Import -Export Techniques
  • Tuning & Troubleshooting
  • Performance Tuning & Tips
  • Security Audits in DENALI
  • DBCC Commands and Management
  • Server Level Audits and Monitoring

 

  • Advanced SQL DB Administration Checklist
  • Solutions for Log Space Issues and Tempdb Issues
  • Solutions for Memory Issue and Network Issues
  • Solutions for Long Running Queries and Frequent Queries
  • DBCC and Dynamic Management Views
  • Profiler & Activity Monitor and Network Issues
  • Partitioning Techniques and Compression Techniques
  • Database Snapshots and Usage
  • Certificates, Signatures, Cryptography
  • SQL Server Keys and TDE Implementation
  • DB Engine Tuning Advisor and Client Statistics
  • Optimizing SSIS Packages
  • Database Maintenance Plans using SSIS
  • History Maintenance and Database Shrinking Operations
  • Backup Strategies, Healthcheck Commands for Routine Backups
  • Recovery Path and Failover Options
  • DB Mail & Alert System with Notifications
  • Upgrades, Migrations and Service Pack Installations
  • SQL Server Failover Cluster Configuration
  • Active Directory Configurations and Storage (SAN) Management
  • Active/Active and Active/Passive Cluster Configuration Issues
  • SQL Server Cluster Management Operations
  • MSDTC and Resource Governor Importance and Usage
  • Contained Databases and Always-On Availability Groups

 

 

*ALL OUR SESSIONS ARE COMPLETELY PRACTICAL*

 

Detailed Course Curriculum and Fee details available at http://sqlschool.com/SQLDBA-Online-Training.html

 

SQL School

contact@sqlschool.com

Office: (+91)   040 64577244 (India) |   Mobile: (+91)   09666440801 (India)

Office: (+1) 214 628 5666 (USA)

http://sqlschool.com

 

About sqlschool

SQL School (Regd: SequelGate Innovative Technologies Pvt. Ltd.) is one of fastest growing organization delivering Realtime Training and Realtime Projects exclusively on Microsoft SQL Server. Our Training services include SQL DBA Online Training, MSBI Online Training, SQL DBA Classroom Training, MSBI Classroom Training and Realtime Projects. SQL School, established in February, 2008 is now, one of the best institute offering Trainings on SQL Server, SQL Database Administration (DBA) and Business Intelligence (BI) technologies. We have been working with numerous consultancies in India, US, UK and Australia. We undertake Online Trainings and Corporate Trainings on SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012 (DENALI) versions. We make sure that all our sessions are very much interactive and well structured. We encourage every participant to come up with his / her own queries during & after the training sessions. We prefer practical approach rather than theoretical information to master the technical depth of the technology. We provide excellent Lab Handouts for practice, Realtime Case Studies and Projects on SQL Server Administration (SQL DBA) and Microsoft Business Intelligence (MS BI) Training courses. Free LIVE DEMOs would be provided prior to training registration. Specific DAY to DAY Course Plan will also be shared prior to training registration to ensure transparency of our Training services.