Showing posts with label DBA. Show all posts
Showing posts with label DBA. Show all posts

Thursday, November 9, 2017

Best Training On SQL DBA Weekend Training Course SQL School Training Institute

Best Training On SQL DBA Weekend Training Course SQL School Training Institute


This course is carefully designed for starters as well as for working professionals. Course includes SQL Server Architecture in detail, Understanding Query Design, Query Performance Tuning, Upgrades, Migrations, Troubleshooting, Disaster Recovery (DR) and High Availability (HA) Solutions including SQL Clustering with Always-On (AAG). This SQL DBA Course also includes One Real-time Project, Resume and Placement Support.

COURSE HIGHLIGHTS

  •  Daily Tasks & Lab
  •  Real-time Examples
  •  Always-On and HA/DR
  •  Performance Tuning
  •  AZURE Cloud @ DBA
  •  MCSA Certification

This SQL DBA Course includes MCSA Certification also.

Please find the Course details



Register for  free demo:


 

Thursday, August 17, 2017

EXCELLENT PROJECT ORIENTED CLASSROOM TRAINING ON SQL Server 2014 & 2016 DBA



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


EXCELLENT PROJECT ORIENTED CLASSROOM TRAINING ON SQL Server 2014 & 2016 DBA

PRACTICAL SQL 2014 & 2016 DBA CLASSROOM TRAINING COURSE DETAILS :

Module 1: SQL Server Basics and T-SQL Programming

Module 2: Basic Database Administration (DBA) Activities

Module 3: Advanced Database Administration (DBA) Activities

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.

ALL OUR SESSIONS ARE COMPLETELY PRACTICAL

For  SQL DBA Classroom free Demo, Please visit :


Schedules for PRACTICAL SQL Server 2014 & 2016 DBA CLASSROOM TRAINING & JOB SUPPORT :


Contact us today for Practical SQL Server 2014 & 2016 DBA Classroom 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.

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

Office 2:
Sai Anu Avenue, Street No 3, Patrika Nagar, HI-TECH City, Hyderabad -81, India. 

Call us :
India
 Office : (0) 40 64577244
 Mobile :(+91) 9666440801
USA
 Office : (510) 400-4845

Website :

Follow us :





Friday, May 26, 2017

SQL DBA Online Training (LIVE, Instructor-Led) With Real Time Project

SQL School Training Institute is one of the best Training Organizations providing specialized in SQL Server 2014 and 2016 DBA Training. We have been providing Practical SQL 2014 and 2016 DBA Online Training ,Classroom Training and Video Training for the last nine years .

All our sessions are completely Practical and Real-time.

PRACTICAL SQL 2014  & 2016 DBA ONLINE TRAINING COURSE DETAILS :

SQL Server Basics & T-SQL Queries

• SQL Server Design Architecture – 2014 & 2016

• SQL Server Database Design & Planning

• SQL Server Table Design & Pages

• Table Compression Techniques

• Data Integrity & Consistency

• SQL Server Views and Schemes

• 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 2014 & 2016

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 Encryption 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 Temp-db Issues

• Pro-filer & Activity Monitor and Network Issues

• Partitioning Techniques, DB Snapshots and Usage

• Certificates, Signatures, Cryptography, Keys and TDE
  Implementation

• DB Engine Tuning Adviser and Client Statistics

• Optimizing SSIS Packages

• Database Maintenance Plans

• DB Mail & Alert System with Notifications

• Upgrades, Migrations and Service Pack Installations

• SQL Server Fail over 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

Duration: 7 weeks, every day for 1.5 hours and all sessions are completely practical. One Real-time Project included in the course, with 24x7 LIVE Server (Online Lab) for practice.

For free SQL-DBA ONLINE Demo, please visit :

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

Register for Practical SQL 2014 & 2016 DBA Online Training :

http://sqlschool.com/register.html

Contact us today for practical SQL 2014 & 2016 DBA Online Training

SQL School Training Institute

 ISO 9001:2008 Certified Organization for Training

Authorized Microsoft Partner (ID# 4338151)

Regd: Sequel Gate 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.

Call us :

India:

Office : +91 (0) 40 64577244
Mobile : +91 (0) 9666440801

USA:
Office: +1 (510) 400-4845

Website:

http://sqlschool.com/

Follow us:

https://www.facebook.com/sequelschool

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

https://twitter.com/sequelschool



Tuesday, November 15, 2016

Real-time Practical SQL DBA LIVE Online Training

SQL School Training Institute is an ISO Certified Organization and Microsoft Learning Partner offering real-time, practical trainings exclusively on SQL Server Technologies including SQL Server Development (SQL Dev), SQL Database Administration (SQL DBA), Microsoft Business Intelligence and Datawarehousing (MSBI / DWH) Training. Versions: SQL Server 2016, SQL Server 2014. Register Today for free demo
We offer Instructor-Led LIVE Online Training, Classroom Training and On-demand Video Training with COMPLETE REAL-TIME and INTERACTIVE Practical Sessions. All our training courses include Real-time Projects, Certifications, Weekly Mock Interviews, Placement Assistance and free 24x7LIVE Online Lab.

SQL DBA Online Training (LIVE, Instructor-Led)

Real-time Practical SQL DBA LIVE Online Training designed to work with all major SQL Database Administration activities including DB Design, Normalized Views, Stored Procedures, Indexes, Joins, DB Maintenance, Query Tuning, HA/DR, AAG and SQL Cluster Issues. Study Material, 24x7 Online Lab, Certification, Job Support with One Realtime Project included in the course. Versions: SQL Server 2012, SQL Server 2014 & 2016.

SQL DBA Online Training - Highlights

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Certification & Interview Guidance
  • Detailed SQL Server Architecture, DB Design
  • Query Tuning, Stored Procedures, Linked Servers
  • In-Memory, DAC and Contained Databases
  • Routine DBA Activities, Emergency DBA Activities
  • High Availability, Disaster Recovery, Always-On
Please register free demo @ http://www.sqlschool.com/register.html

SQL School (SequelGate (I) Technologies Pvt. Ltd.)

OFFICE 1:

#108/2RT, Road No: 1, Beside Bus Stop, 
SR Nagar, Ameerpet, Hyderabad - 38 (India). Map

OFFICE 2:

Sai Anu Avenue, Street Number 3, Patrika Nagar, 
Patrika Nagar, HITEC City, Hyderabad - 81 (India). Map

India: 0091 (0)9666440801 USA: 001 (510) 400-4845

Thursday, November 10, 2016

SQL DBA Live Online Training with Project

SQL DBA Video Training

On demand Training Videos with your comfortable timings and convenient environment. Our SQL DBA Video Training Service (Course Code: VC02) offers complete practical and realtime knowledge transfer services for aspiring SQL Database Administrators. Study and Practice Material along with Realtime Project, Free LIVE Server for Online Lab included in this course. Register for SQL DBA Video Training
 SQL Database Administration (SQL DBA) Course
This course is carefully designed for starters as well as for working professionals. Course includes SQL Server Architecture in detail, Understanding Query Design, Query Performance Tuning, Upgrades, Migrations, Troubleshooting, Disaster Recovery (DR) and High Availability (HA) Solutions including SQL Clustering with Always-On (AAG). This SQL DBA Course also includes One Real-time Project, Resume and Placement Support.

Please register free demo @  http://sqlschool.com/register.html

SQL DBA Classroom Training - Highlights

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Certification & Interview Guidance
         Detailed SQL Server Architecture, DB Design
  • Query Tuning, Stored Procedures, Linked Servers
  • In-Memory, DAC and Contained Databases
  • Routine DBA Activities, Emergency DBA Activites
  • High Availability, Disaster Recovery, Always-On

SQL School (SequelGate (I) Technologies Pvt. Ltd.)

OFFICE 1:

#108/2RT, Road No: 1, Beside Bus Stop,
SR Nagar, Ameerpet, Hyderabad - 38 (India). Map

OFFICE 2:

Sai Anu Avenue, Street Number 3, Patrika Nagar,
HITEC City, Hyderabad - 81 (India). Map

India: 0091 (0)9666440801 USA: 001 (510) 400-4845

Saturday, November 5, 2016

PROJECT ORIENTED LIVE ONLINE TRAINING ON SQL Server 2016 & 2014 DBA


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 2016 & 2014 DBA Online ,Classroom and Video Training for the last Nine years.All our Training Classes are Example Based and Real Time.



PROJECT ORIENTED LIVE ONLINE TRAINING ON SQL Server 2016 & 2014 DBA

PRACTICAL SQL 2016 & 2014 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 2016 DBA Online Training & Job Support:

http://sqlschool.com/Register.html

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

Email: contact@sqlschool.com

SQL School Training Institute   
   
ISO 9001:2008 Certified Organization for Training

Authorized Microsoft Partner (ID# 4338151)

Regd: SequelGate Innovative Technologies Pvt. Ltd.

Address 1:

SQL School Training Institute
108, Lane No: 2, Road No: 1, Beside Bus Stop, SR Nagar,
Sanjeeva Reddy Nagar Office Area, Sanjeeva Reddy Nagar, Hyderabad, Telangana 500038.

Address 2:

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

Website :

http://sqlschool.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

Wednesday, November 12, 2014

PRACTICAL SQL Server 2012 DBA CLASSROOM TRAINING

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/

Monday, November 10, 2014

Which is the best way to learn SQL Server?

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, November 1, 2014

Where to learn SQL Server and SQL DBA?

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/

Wednesday, October 15, 2014

BEST PRACTICAL SQL DBA ONLINE 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/

Monday, September 29, 2014

PROJECT ORIENTED LIVE ONLINE TRAINING ON SQL Server 2012 DBA

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/