SQL DBA Online Trainings at SQL School Training Institute: sql server DBA Courses online

Showing posts with label sql server DBA Courses online. Show all posts

Thursday, July 27, 2017

SQL Admin BEST PRACTICAL REALTIME ONLINE TRAINING

SQL School Training Institute is one of the Best Training Institute for SQL Server , SQL DBA and MSBI Training. We have been providing Microsoft SQL Server 2014 & 2016 DBA Online ,Classroom and Video Training for the last Nine years.All our Training Classes are Example Based and Real Time.

SQL Admin BEST PRACTICAL REALTIME ONLINE TRAINING

PRACTICAL SQL 2014 & 2016 DBA ONLINE TRAINING COURSE DETAILS :

Module 1: SQL Server Basics and T-SQL Programming (3 Weeks)

Module 2: Basic Database Administration (DBA) Activities (3 Weeks)

Module 3: Advanced Database Administration (DBA) Activities (3 Weeks)

All Concepts including SQL Server CLUSTERING to be discussed Practically.

We assure you Quality of Training. Study Material and Practice Material included in the course.

For SQL DBA Online free Demo, Please visit :

http://sqlschool.com/SQLDBA-Online-Training.html

Registration for Practical SQL Server 2014 DBA Online Training & Job Support:

http://sqlschool.com/Register.html

Contact us today for practical SQL Server 2014 & 2016 DBA Online Training & job support.

SQL School Training Institute

ISO 9001:2008 Certified Organization for Training

Authorized Microsoft Partner (ID# 4338151)

Regd: SequelGate Innovative Technologies Pvt. Ltd.

Address 1:

108/2RT, Street No 2, Road No 1, Landmark : Beside SR Nagar Bus Stop, SR Nagar, Hyderabad - 38, India.

Address 2:

Sai Anu Avenue, Street No 3, Pathrika Nagar, HI-TECH City, Hyderabad -81, India.

Website :

http://sqldbatraining.com/

Call us :

India

Office : (0) 40 64577244

Mobile :(+91) 9666440801

USA

Office : (510) 400-4845

Follow us :

https://www.facebook.com/sequelschool

https://www.linkedin.com/company/sql-school

https://twitter.com/sequelschool

Friday, May 29, 2015

PRACTICAL SQL DBA CLASSROOM TRAINING with PROJECT

SQL School is one of the pioneers IT Institutions providing specialized in SQL Server 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 DBA COURSE DETAILS FOR CLASSROOM TRAINING (contents at glance):

SQL Server Basics & T-SQL Programming

SQL Server 2008 & 2012 Installation
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity & Consistency
SQL Server Views and Schemas
JOINS and Sub Queries
Uses of Indexes and Performance
Stored Procedures and User Defined Functions
Dynamic SQL and TEMP Tables
DDL Triggers and DML Triggers
Memory Usage with Triggers
Cursors Usage and Limitations
T-SQL Transactions Concepts & Types
New Features in DENALI (SQL Server 2012)

Basic SQL Server Administration (SQL DBA)

Blocking & Deadlocks Issues
Backup Strategies & Backup Options
Point-In-Time, Partial and Piecemeal Restores
Replication Techniques and Monitoring
Peer – Peer Replication Topology and Limitations
Log Shipping Modes and Issues
DB Mirroring and Encryption
SQL Server Security & Database & Object Security
Security Issues and Audits
Data Level Encryptions and Data Security
Performance Tuning & Tips
Import - Export Techniques
Tuning & Troubleshooting
Security Audits in DENALI
DBCC Commands and Management

Advanced SQL Server Administration (SQL DBA)

Log Space Issues and Tempdb Issues
Profiler & Activity Monitor and Network Issues
Partitioning Techniques, DB Snapshots and Usage
Certificates, Signatures, Cryptography, Keys and TDE Implementation
DB Engine Tuning Advisor and Client Statistics
Database Maintenance Plans
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

For free Demo and further training details, please visit www.sqlschool.com or contact us.

SQL School Training Institute
contact@sqlschool.com
Office: (+91) 040 64577244
Mobile: (+91) 0 9666440801
Flat No: 302, Sai Manor Complex, X Roads, SR Nagar, Hyderabad, India.
http://sqlschool.com/

Saturday, May 23, 2015

PRACTICAL SQL Server 2012 & 2014 DBA CLASSROOM TRAINING

SQL DBA COURSE DETAILS FOR CLASSROOM TRAINING (contents at glance):

SQL Server Basics & T-SQL Programming

SQL Server 2008 & 2012 Installation
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity & Consistency
SQL Server Views and Schemas
JOINS and Sub Queries
Uses of Indexes and Performance
Stored Procedures and User Defined Functions
Dynamic SQL and TEMP Tables
DDL Triggers and DML Triggers
Memory Usage with Triggers
Cursors Usage and Limitations
T-SQL Transactions Concepts & Types
New Features in DENALI (SQL Server 2012)

Basic SQL Server Administration (SQL DBA)

Blocking & Deadlocks Issues
Backup Strategies & Backup Options
Point-In-Time, Partial and Piecemeal Restores
Replication Techniques and Monitoring
Peer – Peer Replication Topology and Limitations
Log Shipping Modes and Issues
DB Mirroring and Encryption
SQL Server Security & Database & Object Security
Security Issues and Audits
Data Level Encryptions and Data Security
Performance Tuning & Tips
Import - Export Techniques
Tuning & Troubleshooting
Security Audits in DENALI
DBCC Commands and Management

Advanced SQL Server Administration (SQL DBA)

Log Space Issues and Tempdb Issues
Profiler & Activity Monitor and Network Issues
Partitioning Techniques, DB Snapshots and Usage
Certificates, Signatures, Cryptography, Keys and TDE Implementation
DB Engine Tuning Advisor and Client Statistics
Database Maintenance Plans
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

Thursday, May 14, 2015

BEST PRACTICAL SQL DBA ONLINE PRACTICAL TRAINING

SQL School is one of the training organizations 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 & T-SQL Queries

SQL Server Design Architecture – 2008 R2 & 2012
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity & Consistency
SQL Server Views and Schemas
JOINS and Sub Queries
Uses of Indexes and Performance
Stored Procedures and User Defined Functions
Dynamic SQL and TEMP Tables
DDL Triggers and DML Triggers
Memory Usage with Triggers
Cursors Usage and Limitations
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
New Features in SQL Server 2012

Basic SQL Server Administration (DBA)

Blocking & Deadlocks Issues
Backup Strategies & Backup Options
Point-In-Time, Partial and Piecemeal Restores
Replication Techniques and Monitoring
Peer – Peer Replication Topology and Limitations
Log Shipping Modes and Issues
DB Mirroring and Encryption
SQL Server Security & Client Security
Database & Object Security
Security Issues and Audits
Data Level Encryptions and Data Security
Performance Tuning & Tips
Import -Export Techniques
Tuning & Troubleshooting
Security Audits in DENALI
DBCC Commands and Management
Server Level Audits

Advanced SQL Administration

Log Space Issues and Tempdb Issues
Profiler & Activity Monitor and Network Issues
Partitioning Techniques, DB Snapshots and Usage
Certificates, Signatures, Cryptography, Keys and TDE Implementation
DB Engine Tuning Advisor and Client Statistics
Optimizing SSIS Packages
Database Maintenance Plans
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 Sessions are Completely Practical and Realtime.

For free demo, please visit http://sqlschool.com/SQLDBA-Online-Training.html
SQL School Training Institute
contact@sqlschool.com
Office: (+91) 040 64577244
Mobile: (+91) 0 9666440801
Flat No: 302, Sai Manor Complex, X Roads, SR Nagar, Hyderabad, India.
http://sqlschool.com/

Thursday, April 16, 2015

BEST PRACTICAL SQL DBA REALTIME ONLINE TRAINING

SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAINING

SQL Server Basics & T-SQL Queries

SQL Server Design Architecture – 2008 R2 & 2012
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity & Consistency
SQL Server Views and Schemas
JOINS and Sub Queries
Uses of Indexes and Performance
Stored Procedures and User Defined Functions
Dynamic SQL and TEMP Tables
DDL Triggers and DML Triggers
Memory Usage with Triggers
Cursors Usage and Limitations
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
New Features in SQL Server 2012

Basic SQL Server Administration (DBA)

Blocking & Deadlocks Issues
Backup Strategies & Backup Options
Point-In-Time, Partial and Piecemeal Restores
Replication Techniques and Monitoring
Peer – Peer Replication Topology and Limitations
Log Shipping Modes and Issues
DB Mirroring and Encryption
SQL Server Security & Client Security
Database & Object Security
Security Issues and Audits
Data Level Encryptions and Data Security
Performance Tuning & Tips
Import -Export Techniques
Tuning & Troubleshooting
Security Audits in DENALI
DBCC Commands and Management
Server Level Audits

Advanced SQL Administration

Log Space Issues and Tempdb Issues
Profiler & Activity Monitor and Network Issues
Partitioning Techniques, DB Snapshots and Usage
Certificates, Signatures, Cryptography, Keys and TDE Implementation
DB Engine Tuning Advisor and Client Statistics
Optimizing SSIS Packages
Database Maintenance Plans
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 Sessions are Completely Practical and Realtime.

Thursday, April 9, 2015

BEST PRACTICAL SQL DBA REALTIME ONLINE TRAINING

SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAINING

SQL Server Basics & T-SQL Queries

SQL Server Design Architecture – 2008 R2 & 2012
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity & Consistency
SQL Server Views and Schemas
JOINS and Sub Queries
Uses of Indexes and Performance
Stored Procedures and User Defined Functions
Dynamic SQL and TEMP Tables
DDL Triggers and DML Triggers
Memory Usage with Triggers
Cursors Usage and Limitations
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
New Features in SQL Server 2012

Basic SQL Server Administration (DBA)

Blocking & Deadlocks Issues
Backup Strategies & Backup Options
Point-In-Time, Partial and Piecemeal Restores
Replication Techniques and Monitoring
Peer – Peer Replication Topology and Limitations
Log Shipping Modes and Issues
DB Mirroring and Encryption
SQL Server Security & Client Security
Database & Object Security
Security Issues and Audits
Data Level Encryptions and Data Security
Performance Tuning & Tips
Import -Export Techniques
Tuning & Troubleshooting
Security Audits in DENALI
DBCC Commands and Management
Server Level Audits

Advanced SQL Administration

Log Space Issues and Tempdb Issues
Profiler & Activity Monitor and Network Issues
Partitioning Techniques, DB Snapshots and Usage
Certificates, Signatures, Cryptography, Keys and TDE Implementation
DB Engine Tuning Advisor and Client Statistics
Optimizing SSIS Packages
Database Maintenance Plans
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 Sessions are Completely Practical and Realtime.

Tuesday, April 7, 2015

PRACTICAL SQL DBA ONLINE TRAINING BY REALTIME EXPERT

SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAINING

SQL Server Basics & T-SQL Queries

SQL Server Design Architecture – 2008 R2 & 2012
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity & Consistency
SQL Server Views and Schemas
JOINS and Sub Queries
Uses of Indexes and Performance
Stored Procedures and User Defined Functions
Dynamic SQL and TEMP Tables
DDL Triggers and DML Triggers
Memory Usage with Triggers
Cursors Usage and Limitations
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
New Features in SQL Server 2012

Basic SQL Server Administration (DBA)

Blocking & Deadlocks Issues
Backup Strategies & Backup Options
Point-In-Time, Partial and Piecemeal Restores
Replication Techniques and Monitoring
Peer – Peer Replication Topology and Limitations
Log Shipping Modes and Issues
DB Mirroring and Encryption
SQL Server Security & Client Security
Database & Object Security
Security Issues and Audits
Data Level Encryptions and Data Security
Performance Tuning & Tips
Import -Export Techniques
Tuning & Troubleshooting
Security Audits in DENALI
DBCC Commands and Management
Server Level Audits

Advanced SQL Administration

Log Space Issues and Tempdb Issues
Profiler & Activity Monitor and Network Issues
Partitioning Techniques, DB Snapshots and Usage
Certificates, Signatures, Cryptography, Keys and TDE Implementation
DB Engine Tuning Advisor and Client Statistics
Optimizing SSIS Packages
Database Maintenance Plans
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 Sessions are Completely Practical and Realtime.

Friday, April 3, 2015

PRACTICAL SQL Server 2012 DBA CLASSROOM TRAINING

SQL DBA COURSE DETAILS FOR CLASSROOM TRAINING (contents at glance):

SQL Server Basics & T-SQL Programming

SQL Server 2008 & 2012 Installation
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity & Consistency
SQL Server Views and Schemas
JOINS and Sub Queries
Uses of Indexes and Performance
Stored Procedures and User Defined Functions
Dynamic SQL and TEMP Tables
DDL Triggers and DML Triggers
Memory Usage with Triggers
Cursors Usage and Limitations
T-SQL Transactions Concepts & Types
New Features in DENALI (SQL Server 2012)

Basic SQL Server Administration (SQL DBA)

Blocking & Deadlocks Issues
Backup Strategies & Backup Options
Point-In-Time, Partial and Piecemeal Restores
Replication Techniques and Monitoring
Peer – Peer Replication Topology and Limitations
Log Shipping Modes and Issues
DB Mirroring and Encryption
SQL Server Security & Database & Object Security
Security Issues and Audits
Data Level Encryptions and Data Security
Performance Tuning & Tips
Import - Export Techniques
Tuning & Troubleshooting
Security Audits in DENALI
DBCC Commands and Management

Advanced SQL Server Administration (SQL DBA)

Log Space Issues and Tempdb Issues
Profiler & Activity Monitor and Network Issues
Partitioning Techniques, DB Snapshots and Usage
Certificates, Signatures, Cryptography, Keys and TDE Implementation
DB Engine Tuning Advisor and Client Statistics
Database Maintenance Plans
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

Thursday, April 2, 2015

PRACTICAL SQL Server 2012 & 2014 DBA ONLINE TRAINING

SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAINING

SQL Server Basics & T-SQL Queries

SQL Server Design Architecture – 2008 R2 & 2012
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity & Consistency
SQL Server Views and Schemas
JOINS and Sub Queries
Uses of Indexes and Performance
Stored Procedures and User Defined Functions
Dynamic SQL and TEMP Tables
DDL Triggers and DML Triggers
Memory Usage with Triggers
Cursors Usage and Limitations
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
New Features in SQL Server 2012

Basic SQL Server Administration (DBA)

Blocking & Deadlocks Issues
Backup Strategies & Backup Options
Point-In-Time, Partial and Piecemeal Restores
Replication Techniques and Monitoring
Peer – Peer Replication Topology and Limitations
Log Shipping Modes and Issues
DB Mirroring and Encryption
SQL Server Security & Client Security
Database & Object Security
Security Issues and Audits
Data Level Encryptions and Data Security
Performance Tuning & Tips
Import -Export Techniques
Tuning & Troubleshooting
Security Audits in DENALI
DBCC Commands and Management
Server Level Audits

Advanced SQL Administration

Log Space Issues and Tempdb Issues
Profiler & Activity Monitor and Network Issues
Partitioning Techniques, DB Snapshots and Usage
Certificates, Signatures, Cryptography, Keys and TDE Implementation
DB Engine Tuning Advisor and Client Statistics
Optimizing SSIS Packages
Database Maintenance Plans
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 Sessions are Completely Practical and Realtime.

Tuesday, March 10, 2015

LIVE CLASSROOM TRAINING ON SQL Server 2012 DBA COURSE

SQL DBA COURSE DETAILS FOR CLASSROOM TRAINING (contents at glance):

SQL Server Basics & T-SQL Programming

SQL Server 2008 & 2012 Installation
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity & Consistency
SQL Server Views and Schemas
JOINS and Sub Queries
Uses of Indexes and Performance
Stored Procedures and User Defined Functions
Dynamic SQL and TEMP Tables
DDL Triggers and DML Triggers
Memory Usage with Triggers
Cursors Usage and Limitations
T-SQL Transactions Concepts & Types
New Features in DENALI (SQL Server 2012)

Basic SQL Server Administration (SQL DBA)

Blocking & Deadlocks Issues
Backup Strategies & Backup Options
Point-In-Time, Partial and Piecemeal Restores
Replication Techniques and Monitoring
Peer – Peer Replication Topology and Limitations
Log Shipping Modes and Issues
DB Mirroring and Encryption
SQL Server Security & Database & Object Security
Security Issues and Audits
Data Level Encryptions and Data Security
Performance Tuning & Tips
Import - Export Techniques
Tuning & Troubleshooting
Security Audits in DENALI
DBCC Commands and Management

Advanced SQL Server Administration (SQL DBA)

Log Space Issues and Tempdb Issues
Profiler & Activity Monitor and Network Issues
Partitioning Techniques, DB Snapshots and Usage
Certificates, Signatures, Cryptography, Keys and TDE Implementation
DB Engine Tuning Advisor and Client Statistics
Database Maintenance Plans
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

Friday, February 27, 2015

LIVE ONLINE TRAINING ON SQL DBA PRODUCTION ACTIVITIES

SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAINING

SQL Server Basics & T-SQL Queries

SQL Server Design Architecture – 2008 R2 & 2012
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity & Consistency
SQL Server Views and Schemas
JOINS and Sub Queries
Uses of Indexes and Performance
Stored Procedures and User Defined Functions
Dynamic SQL and TEMP Tables
DDL Triggers and DML Triggers
Memory Usage with Triggers
Cursors Usage and Limitations
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
New Features in SQL Server 2012

Basic SQL Server Administration (DBA)

Blocking & Deadlocks Issues
Backup Strategies & Backup Options
Point-In-Time, Partial and Piecemeal Restores
Replication Techniques and Monitoring
Peer – Peer Replication Topology and Limitations
Log Shipping Modes and Issues
DB Mirroring and Encryption
SQL Server Security & Client Security
Database & Object Security
Security Issues and Audits
Data Level Encryptions and Data Security
Performance Tuning & Tips
Import -Export Techniques
Tuning & Troubleshooting
Security Audits in DENALI
DBCC Commands and Management
Server Level Audits

Advanced SQL Administration

Log Space Issues and Tempdb Issues
Profiler & Activity Monitor and Network Issues
Partitioning Techniques, DB Snapshots and Usage
Certificates, Signatures, Cryptography, Keys and TDE Implementation
DB Engine Tuning Advisor and Client Statistics
Optimizing SSIS Packages
Database Maintenance Plans
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 Sessions are Completely Practical and Realtime.

Thursday, February 26, 2015

BEST PRACTICAL SQL DBA ONLINE TRAINING with PROJECT

SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAINING

SQL Server Basics & T-SQL Queries

SQL Server Design Architecture – 2008 R2 & 2012
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity & Consistency
SQL Server Views and Schemas
JOINS and Sub Queries
Uses of Indexes and Performance
Stored Procedures and User Defined Functions
Dynamic SQL and TEMP Tables
DDL Triggers and DML Triggers
Memory Usage with Triggers
Cursors Usage and Limitations
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
New Features in SQL Server 2012

Basic SQL Server Administration (DBA)

Blocking & Deadlocks Issues
Backup Strategies & Backup Options
Point-In-Time, Partial and Piecemeal Restores
Replication Techniques and Monitoring
Peer – Peer Replication Topology and Limitations
Log Shipping Modes and Issues
DB Mirroring and Encryption
SQL Server Security & Client Security
Database & Object Security
Security Issues and Audits
Data Level Encryptions and Data Security
Performance Tuning & Tips
Import -Export Techniques
Tuning & Troubleshooting
Security Audits in DENALI
DBCC Commands and Management
Server Level Audits

Advanced SQL Administration

Log Space Issues and Tempdb Issues
Profiler & Activity Monitor and Network Issues
Partitioning Techniques, DB Snapshots and Usage
Certificates, Signatures, Cryptography, Keys and TDE Implementation
DB Engine Tuning Advisor and Client Statistics
Optimizing SSIS Packages
Database Maintenance Plans
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 Sessions are Completely Practical and Realtime.

Monday, February 23, 2015

SQL Server and SQL DBA Online Training from SQL School

SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAINING

SQL Server Basics & T-SQL Queries

SQL Server Design Architecture – 2008 R2 & 2012
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity & Consistency
SQL Server Views and Schemas
JOINS and Sub Queries
Uses of Indexes and Performance
Stored Procedures and User Defined Functions
Dynamic SQL and TEMP Tables
DDL Triggers and DML Triggers
Memory Usage with Triggers
Cursors Usage and Limitations
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
New Features in SQL Server 2012

Basic SQL Server Administration (DBA)

Blocking & Deadlocks Issues
Backup Strategies & Backup Options
Point-In-Time, Partial and Piecemeal Restores
Replication Techniques and Monitoring
Peer – Peer Replication Topology and Limitations
Log Shipping Modes and Issues
DB Mirroring and Encryption
SQL Server Security & Client Security
Database & Object Security
Security Issues and Audits
Data Level Encryptions and Data Security
Performance Tuning & Tips
Import -Export Techniques
Tuning & Troubleshooting
Security Audits in DENALI
DBCC Commands and Management
Server Level Audits

Advanced SQL Administration

Log Space Issues and Tempdb Issues
Profiler & Activity Monitor and Network Issues
Partitioning Techniques, DB Snapshots and Usage
Certificates, Signatures, Cryptography, Keys and TDE Implementation
DB Engine Tuning Advisor and Client Statistics
Optimizing SSIS Packages
Database Maintenance Plans
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 Sessions are Completely Practical and Realtime.

Monday, February 16, 2015

LIVE ONLINE TRAINING ON SQL DBA PRODUCTION ACTIVITIES

SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAINING

SQL Server Basics & T-SQL Queries

SQL Server Design Architecture – 2008 R2 & 2012
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity & Consistency
SQL Server Views and Schemas
JOINS and Sub Queries
Uses of Indexes and Performance
Stored Procedures and User Defined Functions
Dynamic SQL and TEMP Tables
DDL Triggers and DML Triggers
Memory Usage with Triggers
Cursors Usage and Limitations
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
New Features in SQL Server 2012

Basic SQL Server Administration (DBA)

Blocking & Deadlocks Issues
Backup Strategies & Backup Options
Point-In-Time, Partial and Piecemeal Restores
Replication Techniques and Monitoring
Peer – Peer Replication Topology and Limitations
Log Shipping Modes and Issues
DB Mirroring and Encryption
SQL Server Security & Client Security
Database & Object Security
Security Issues and Audits
Data Level Encryptions and Data Security
Performance Tuning & Tips
Import -Export Techniques
Tuning & Troubleshooting
Security Audits in DENALI
DBCC Commands and Management
Server Level Audits

Advanced SQL Administration

Log Space Issues and Tempdb Issues
Profiler & Activity Monitor and Network Issues
Partitioning Techniques, DB Snapshots and Usage
Certificates, Signatures, Cryptography, Keys and TDE Implementation
DB Engine Tuning Advisor and Client Statistics
Optimizing SSIS Packages
Database Maintenance Plans
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 Sessions are Completely Practical and Realtime.

Friday, February 13, 2015

THE BEST PRACTICAL TRAINING ON SQL Server 2014 DBA

SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAINING

SQL Server Basics & T-SQL Queries

SQL Server Design Architecture – 2008 R2 & 2012
SQL Server Database Design & Planning
SQL Server Table Design & Pages
Table Compression Techniques
Data Integrity & Consistency
SQL Server Views and Schemas
JOINS and Sub Queries
Uses of Indexes and Performance
Stored Procedures and User Defined Functions
Dynamic SQL and TEMP Tables
DDL Triggers and DML Triggers
Memory Usage with Triggers
Cursors Usage and Limitations
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
New Features in SQL Server 2012

Basic SQL Server Administration (DBA)

Blocking & Deadlocks Issues
Backup Strategies & Backup Options
Point-In-Time, Partial and Piecemeal Restores
Replication Techniques and Monitoring
Peer – Peer Replication Topology and Limitations
Log Shipping Modes and Issues
DB Mirroring and Encryption
SQL Server Security & Client Security
Database & Object Security
Security Issues and Audits
Data Level Encryptions and Data Security
Performance Tuning & Tips
Import -Export Techniques
Tuning & Troubleshooting
Security Audits in DENALI
DBCC Commands and Management
Server Level Audits

Advanced SQL Administration

Log Space Issues and Tempdb Issues
Profiler & Activity Monitor and Network Issues
Partitioning Techniques, DB Snapshots and Usage
Certificates, Signatures, Cryptography, Keys and TDE Implementation
DB Engine Tuning Advisor and Client Statistics
Optimizing SSIS Packages
Database Maintenance Plans
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