SQL Server DBA Training

SQL Server DBA Online Training


Microsoft SQL Server DBA Online Training :

Infrastructure configuration
 Installing virtual technology
 Installing windows operating system
 Installing virtual tools in virtual OS
 configure of share folder from host os to guest os
 Cloning of OS in virtual technology
Sql Server installation in Standalone module
 Sql server standalone configuration
 Pre requisite configuration
 Download sql server software
 unzip the sql server software
 Installing Server pack
 Installing .net framework
 Installing power shell
 Installing windows update
 Execute the setup
 New sql server standalone installation
 Configuration of setup role
 Configuration Default instance
 Multi authentication mode
 Finish the installation
 Start sql server management studio
 login to db server
 verify
Sql Server installation in Domain module
 Sql server Client server configuration
 Understanding the client server scenario
 Installing DCpromo on domain server
 Configure DNS component
 Adding client to domain
 Installing sql server with default instance
 Multi authentication mode
 Start sql server management studio
 login to db server
 verify
User Management and login credential : Microsoft SQL Server DBA Online Training
 Creation of windows & Domain user
 creation of login in database
 Map to particular database
 Assign privilege to user
 Creation of Sql server user
 creation of login and map in database
Remote Server setup
 Pre installation configuration
 .net framework , powershell , service pack etc.
 Install Client tools connectivity
 Verify TCP/IP network connectivity
 Login to database with windows authentication
 Login to database with sql server authentication
 Access db server remotely
 mstsc configuration
 verify
Database creation and physical file
 New database creation
 Understand physical files
 Main data file
 Next data file
 Log data file
 Moving database files
 System databases
 Master
 Model
 MSDB
 Tempdb
 User defined database
Error Logs
 Sql server logs
 Sql Agent logs
Service packs and Hot fixes
 Understanding different updates
 How to apply
 Verify
 Uninstall
Backup and Restoration in Microsoft SQL Server DBA Online Training
 Full database backup
 Differential backup
 Transaction Log backup
 Tail log backup
 Simple module
 Full module
 Recovery module
 Mirrored backup
 Stripped backup
 Backup compression
 Restoration process
Database mail and automation
 Configuring email
 Testing email setup
 Creating Operators
 Creating Jobs
 Alerts configuration
High Availability Implementation
Database level
Log Shipping
Database Mirroring
Replication
Clustering
 Clustering concept
 Install and configure SAN
 Configure DNS
 IP Address
 Create shared disk
 Add target
 iscsi initiator
 Disk management
 Add failover cluster feature
 Quorum
 Msdtc
 Failover cluster ware management
 Verify
Up gradation

HOMEWHY USOUR STRATEGY
PROJECT SUPPORTBLOGBECOME AN Instructor
CONTACT USWEB DESIGNINGOUR SERVICES
LEARNER SIGN UPTRAINER SIGN UPREFER A FRIENDSITEMAP
Copy rights © HyderabadSys.com