1 / 12

sql dba online training

"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."

Download Presentation

sql dba online training

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. 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

  2. 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

  3. Online SQL DBA Trainingcontents CONTENT 1: Architecture &Internals of SQL Server Engine CONTENT 2: Security, Automation & Monitoring

  4. 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

  5. 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]

  6. 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

  7. 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

  8. 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

  9. 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

  10. 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

  11. 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

  12. Contact US:-

More Related