Description

SQL Server Architecture ,SQL Server Version’s and Editions ,SQL server Installation and Configuration

LeoSoft IT Course Services

Classes Flexible Timings

Course Materials Access: Lifetime

Session Recordings

Software Installation

24x7 Training Team Support

Course Certificate

Resume Preparation and Interview Assistance

Course Certification

Reviews

4 Sandeep S (Reviews)

I never seen any online training systems like Leosoft IT. The way they respond to our doubts is simply awesome.
 

4 Pavan Kumar (Reviews)

The training period in Leosoft IT was really helpful and I’m more than satisfied. The trainer had excellent knowledge regarding the topic.

5 Pooja B (Reviews)

Very happy with the training. Topics were well covered. All in all a good day place to be trained. Thanks Leosoft IT.

SQL Server DBA Online Training Concepts :
✔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,Securables,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,Controling DB state.
✔Linked servers
✔DAC-Dedicated Adminstrator Connection
✔CMS-Central Management Server
✔Data Compression and Backup Compression
✔Using ALTER Authorization Command
✔Schemas-Creating and working with schemas
✔Databasesnapshots
✔DBCC-And their parameters
✔Indexes-Types of Indexes,working and Maintaining indexes,resolving indexfragmentation,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 governer
✔Performance data collector
✔SQL Server profiler
✔Maintainence 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,Remedey.