We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

MSSQL Implementation & DBASQL DBA CONTENT
  • Module 1
    • Starting with SQL Server
    • DBA Responsibilities
    • History of SQL Server -Versions
    • SQL Server 2005/2008/2008 R2/2012 Service Packs
    • Editions of SQL Server
    • Tools of SQL Server
    • Hardware/Software Requirements
    • Instances
    • Case studies in Real-time
  • Module 2
    • Installing and Configurations
    • Installing SQL Server 2005/2008/2012
    • Pre -Installations steps
    • Post-Installations steps
    • Installing Service packs
    • Configuring Various Services
    • Startup Parameters
    • Case studies in Real-time
  • Module 3
    • Working With Data Bases
    • Working With Data Bases
    • Database Architecture
    • Creating Databases
    • Adding Files and File groups
    • Case studies in Real-time
  • Module 4
    • Implementing Security
    • Security In SQL Server 2008/2012
    • Types of Authentications
    • Understanding Server Roles/ Data Base Roles
    • Working with Users
    • Resolving Orphan users
    • Case studies in Real-time
  • Module 5
    • Backup and Restoration
    • Backup Types
    • Why we need backups
    • Setting Recovery Model
    • Understandings T-log architecture
    • Truncating Log file
    • Backup System databases
    • Backup Devices
    • Performing Restoration
    • Case studies in Real-time
  • Module 6
    • Automating Administrative Tasks
    • Working With database mails
    • Configuring Linked Servers
    • Creating SQL Server Jobs
    • Maintenance Plans
    • Case studies in Real-time
  • Module 7
    • High Availability
    • Working with Log shipping
    • Features of Log shipping
    • Configuring Log shipping
    • Monitoring Log shipping
    • Jobs
    • Log shipping Tables and Stored Procedures
    • Working with Replication
    • Configuring Replication
    • Types of replications
    • Replication agents
    • Managing Replication
    • Monitoring Replication
    • Working with Mirroring
    • Requirements of Mirroring
    • Configuring
    • Monitoring
    • Servers Involved in Mirroring
    • Modes of Mirroring
    • Mirroring failover
    • Case studies in Real-time
  • Module 8
    • Advanced administrations Concepts
    • Maintenance Plans
    • Monitoring Tools
    • Trouble Shooting
    • Monitoring and Tuning SQL Server
    • SQL Server Architecture
    • Managing Data bases
    • SQL Server Up gradations
    • Using DBCC Commands
    • Case studies in Real-time
  • Module 9
    • Clustering SQL Server
    • Introduction to Cluster Environment
    • Overview Of windows clustering
    • Requirements
    • Installing and configuring
    • Applying Service packs and Hot fixes
    • Patching clustered Instances
    • Case studies in Real-time
  • Module 10
    • SQL Server 2012 DBA Concepts
    • Introduction to SQL server 2012
    • Always on (HA/DR) Features
    • Contained databases
    • New Updated DMVs
    • Case studies in Real-time
Reviews
Be the first to write a review about this course.
Write a Review

SV Soft Solutions is a premier IT Training and Placement Institute. We attempt best quality courses in areas of PeopleSoft, SAP, Oracle, Android, Microsoft, Servicenow, Datawarehousing, Hadoop, Amazon Web services and Tibco. Our online training institute is the best place for you to brush up your technical leading  and build a good career ahead in IT related technologies.  Our main assets are our Trainers who have minimum 8 years of experience in IT. Our training takes place with well prepared training materials. We provide excellent documentation and preparation materials for learners.

Online Learning Course Benefits

  • Industry Expert Trainer
  • Real time Scenario
  • Doubt session Support
  • Topic to Topic Assignments
  • Resume Preparation
  • Interview Q/A
  • Record Sessions
  • Detailed Study Material
  • 24/7 Support
Courses Offered: 


Data warehousing :

1)Informatica Online Training

2)Cognos Online Training

3)MicroStrategy Online Training

4)Qlikview Online Training

5)MSBI Online Training

6)Teradata Online Training

 

SAP Modules :

1)SAP HANA Online Training

2)SAP ABAP Online Training

3)SAP BASIS Online Training

4)SAP BO Online Training

5)SAP BODS Online Training

6)SAP BW Online Training ...

Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.