SQL SERVER DBA

SQL SERVER DBA

Overview:
SQL Server Database Administrators are responsible for the design, implementation, support and maintenance of SQL Server Databases. The role of DBA'S architecting, building and scaling databases for future data growth and capacity. The work of SQL Server DBA is, if the server is replacement for an existing one, it's the DBA's job to get the data from the old server to the new one. Backup and recovery DBAs are responsible for developing, implementing, and periodically testing a backup and recovery plan for the databases they manage.

Training Objectives of SQL Server DBA
SQL Server Training makes you expert in SQL Server,and learn all features and capabilities of SQL Server. It helps manage and store information in an efficient manner. SQL Server training makes a note on table design with schemas, data operations, working with indexed data and can work with save-point transactions and grouping functions. SQL server DBA training sessions are practically oriented. The sessions will start with the basics of SQL Server such as how to retrieve and manipulate data and range through advanced topics such as how to create tables, logins, users, functions, and procedures.

Course Contents:

SQL Server Architecture
SQL Server Version’s and Editions
SQL server Installation and Configuration
System databases
Pages and extents
Sql server services
Sql server protocols
ACID properties
Recovery models
Security-Login and User, Principals, Securable, Managing Permissions
Authentication Modes
Server roles
Database roles
Isolation Levels and Concurrency
Locking and Blocking-Types of locks and Types of reads
Service accounts for SQL server
GUI Templates-object explorer, solution explorer, template explorer, registered servers
Command line tools-BCP,SQLCMD
Creating and Configuring Database
Altering Databases and Their Options-Using ALTER command, Controlling Access, Controlling DB state.
Linked servers
DAC-Dedicated Administrator Connection
CMS-Central Management Server
Data Compression and Backup Compression
Using ALTER Authorization Command
Schemas-Creating and working with schemas
Database snapshots
DBCC-And their parameters
Indexes-Types of Indexes, working and Maintaining indexes, resolving index fragmentation, fill factor
Update statistics
SQL Server Top New Features
DMV’s-Types of Dynamic Management Views and working with them.
PBM-Policy Based Management
Resource governor
Performance data collector
SQL Server profiler
Maintenance Plans
Databasemail
Types of Sql Server Backups and their important options.
Types of Restores and its related options
Orphan Users-Fixing orphan users
Log shipping
Database Mirroring
Replication-Types Replication
Basics of Windows Clustering
Overview of real time Third party Monitoring tools-Ex:-Idera DM,Lite speed.
Overview of real time Ticketing tool-Ex:-Altiris, Remedy.

About the Trainer

10 + Years of IT experience, provided training for over 1000+ professionals online Real-time IT experience which enables to provide dedicated quality training. Teaching is his passion vast experience in providing online training around the globe with good communication skills.