sql dba online training tutorials

1
SQL DBA ONLINE TRAINING

• Online classroom Corporate
• Training certifications placements
  support
• CONTACT US
• MAGNIFIC TRAINING
• INDIA 91-9052666559
• USA 1-678-693-3475
• info_at_magnifictraining.com
• www.magnifictraining.com

2
OUR MAGNIFIC IT COMPANY

• 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 247 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 DMVs
• 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-