SQL DBA Online Training with Reatlime Project and Placement
Online Webinar by
SQL School
Inquire Now
Online
/ Webinar
Details
SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAININGS
SQL Server Basics & T-SQL Queries
[email protected]
Office: (+91) 040 64577244
Mobile: (+91) 0 9666440801
Flat No: 302, Sai Manor Complex, X Roads, SR Nagar, Hyderabad, India.
http://sqlschool.com/
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
- 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
- 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
For free demo, please visit http://sqlschool.com/SQLDBA-Online-Training.html
SQL School Training Institute[email protected]
Office: (+91) 040 64577244
Mobile: (+91) 0 9666440801
Flat No: 302, Sai Manor Complex, X Roads, SR Nagar, Hyderabad, India.
http://sqlschool.com/
Outline
Our Training Highlights
- COMPLETELY PRACTICAL
- HIGHLY INTERACTIVE
- Case Studies
- Realtime Projects
- Resume Preparation
- Sample Resumes
- Production Databases
- Interview Guidance
- Certification Guidance
- FREE Job Support
Complete Practical and Indepth technical courses fully loaded with Lab, Vitrual support and 24x7 LIVE Server access.
Speaker/s
Mr. Sai Phanindra T
8+ years of Experience in SQLServer and BI
Realtime, Highly Interactive and practical
Profile @ http://www.linkedin.com/in/saiphanindra
8+ years of Experience in SQLServer and BI
Realtime, Highly Interactive and practical
Profile @ http://www.linkedin.com/in/saiphanindra
Special Offer
- Group Discounts
- Referral Discounts
- Free Videos
- Free Event
- Certification Vouchers
- 24x7 LIVE Server
- Online Lab
- Certification Guidance
- Interview Guidance
- Placement Services
Ref: www.sqlschool.com
Reviews
Be the first to write a review about this course.
Write a Review
SQL School Training institute have been providing interactive Online and Inhouse Training Services for the last 8 years. We at SQL School, are completely dedicated to offer complete realtime and practical trainings with Job Orientation and Placement Support.
SQL School is an ISO Certified Pvt. Ltd. Organization with 30+ employee count completely dedicated to Microsoft and realted technology offerings.
Courses Offered:
Complete Practical and Indepth technical courses fully loaded with Lab, Vitrual support and 24x7 LIVE Server access.
For Free demo and more details, please mail us to: [email protected]
or Log on to www.sqlschool.com/courses.html
Complete Practical and Indepth technical courses fully loaded with Lab, Vitrual support and 24x7 LIVE Server access. ...
SQL School is an ISO Certified Pvt. Ltd. Organization with 30+ employee count completely dedicated to Microsoft and realted technology offerings.
Courses Offered:
- SQL Server Developer Training
- SQL Server DBA (SQL DBA) Training
- Microsoft Business Intelligence (MSBI) Training
- SQL Server Integration Services (SSIS) Training
- SQL Server Analysis Services (SSAS) Training
- SQL Server Reporting Services (SSRS) Training
- Data Modelling and DB Design
- Datawarehouse Design and ETL with SSIS/SSAS
- Crystal Reports and PowerView Integration to SSRS
- Data Mining and Data Model Training
Complete Practical and Indepth technical courses fully loaded with Lab, Vitrual support and 24x7 LIVE Server access.
For Free demo and more details, please mail us to: [email protected]
or Log on to www.sqlschool.com/courses.html
Complete Practical and Indepth technical courses fully loaded with Lab, Vitrual support and 24x7 LIVE Server access. ...