120 likes | 271 Views
"www.magnifictraining.com-""SQL DBA Online Training""contact us:info@magnifictraining.com or 919052666559,9052666558 By Real Time Experts from Hyderabad, Bangalore,India,USA,Canada,UK, Australia,South Africa."
E N D
Online | classroom| Corporate Training | certifications | placements| support CONTACT US: MAGNIFIC TRAINING INDIA +91-9052666559 USA : +1-678-693-3475 info@magnifictraining.com www.magnifictraining.com
Magnific technology is a leading training institute in the online world • We provide work based training, according to your specific educational and technical needs • We have one excellent centre fully operational training • We provide 24/7 access server to help our trainees practice exercises • Magnific name : SQL DBA 24*7 technical support • Faculty : real time experience • Magnific trainings : it is a brand and providing quality online and offline trainings to students in world wide • We are providing best online training for SQL DBA
Online SQL DBA Trainingcontents CONTENT 1: Architecture &Internals of SQL Server Engine CONTENT 2: Security, Automation & Monitoring
Architecture &Internals of SQL Server Introduction to SQL Server 2012 • Overview on RDBMS and Beyond Relational • Big picture of SQL Server 2012 • Components & Services of SQL Server 2012 • Roles of production DBA • System Databases • Master, Model, MSDB, Tempdb & Resource SQL Server 2012 Editions & Capacity Planning • Principal Editions [Enterprise, BI, Standard] • Specialized Editions [Web] • Breadth Editions [Developer, Express] • Hardware Requirements • OS and Software requirements
Online SQL DBA Training in India Pages & Extents • Pages • Extents [Uniform & Mixed] • Managing Extent Allocations • Tracking Free Space Files and File groups • Database Files • Primary data files • Secondary data files • Log files • Database File groups [Primary & User-defined]
Online SQL DBA Training in usa Thread and Task Architecture • Allocating threads to CPU • Affinity Mask • IO and Processor affinity mask • Configuring Affinity masks • Boost SQL Server priority • Hot Add CPU • Checkpoints
Online SQL DBA Training in uk Memory Architecture • 32-bit Vs 64-bit Architecture • Dynamic Memory Management • Effects of min and max server memory • Buffer Management • The Relational Engine • The Command Parser • The Query Optimizer • The Query Executor • Using AWE • Configuring Memory Settings • The Buffer Pool and the Data Cache • Checkpoints
Online SQL DBA Training in Australia T-Log Architecture • Transaction Log Logical Architecture • Transaction Log Physical Architecture • Recovery phases [Analysis, Redo & Undo] • Checkpoint Operation • Write-Ahead Transaction Log • Managing T-log • Truncating and shrinking the log file • Managing T-Log issues by using DBCC commands
Security, Automation & Monitoring Automating Administrative Tasks • About SQL server Agent • Creating Jobs, Alerts and Operators • Scheduling the Jobs • Working with Job activity Monitor • Resolving failure Jobs • Configuring Alert system in SQL server agent • Best practices on job maintenance
Online SQL DBA Training in Canada Monitoring SQL Server • The Goal of Monitoring • Choosing the Appropriate Monitoring Tools • Monitoring health status by using server Dashboard & DMV’s • Monitoring Job activities by job activity monitor • Monitoring SQL Server process by server activity monitor • Monitoring SQL Server Error Logs/Windows by log file viewer • Best Practices on Monitoring
Online SQL DBA Training in southafrica Security • Security Principles & Authentications • Server and Database Roles • User-defined server roles • Server and Database Principles • Server & Database Securable • Creating Logins and mapping Users to databases • Creating Schemas & credentials • Default Schema for Groups • Enabling contained databases • Creating users for contained databases • Connecting to contained databases from SSMS • Role permissions for CMS and SQL Server Agent • Granting to Object level Permissions • Best Practices on security