sql dba online training classes - PowerPoint PPT Presentation

About This Presentation
Title:

sql dba online training classes

Description:

"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." – PowerPoint PPT presentation

Number of Views:169

less

Transcript and Presenter's Notes

Title: sql dba online training classes


1
  • 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
  • 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-
Write a Comment
User Comments (0)
About PowerShow.com