loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for SQL Server DBA Training

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Thirunavukkarasu

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

SQL Server DBA Training

SQL Server DBA Training

Mahadevapura, Bangalore

9,500

1 Reviews
4 Interested

About the Course


Trainied by working professionals.
Training in SQL server 2008/2008 R/2012.
Trained to get Microsoft International certification.

Topics Covered

SQL SERVER 2005/2008 Administration
An Overview of SQL Server 2005/2008
Available Features and Tools
New Capabilities
SQL Services
Product Licensing
Product Editions


Configuring and Installing
Preparing for Installation
Creating Users for Service Accounts
Choosing Appropriate File Locations
Choosing Instance Names
Installing SQL Server 2008
Choosing Appropriate Features
Specifying Service User Accounts
Choosing Licensing Mode
Choosing Appropriate Collation
Installing Multiple Instances
Upgrading to SQL Server 2008
Service Packs and hot fix
Configuring the Surface Area of SQL Server


Using SQL Server 2005/2008 Management Tools
SQL Server Management Studio
SQL Server Configuration Manager
SQL Server Books Online
SQLCMD


Databases/File Groups
System Databases
Creating and Populating Databases
Describing Data File Structure
Describing Log File Structure and Function
CAPACITY PLANNING
Creating File groups
Configuring File stream Storage
Creating and Using Database Snapshots
Moving a Database to Another SQL Server


Backups and Restore Choosing Appropriate Database
Recovery Model Option
Describing Automatic Recovery
Choosing an Appropriate Backup Strategy
Determining Backup File Contents
Designing a Database Recovery Plan
Using Backup Compression
Use of File groups in a Backup Strategy
Restoring the Master Database
Rebuilding System Databases
Configure Data Compression


Automating Tasks Creating Maintenance Plans
Job Creation and Execution
Creating Schedules for Jobs
Configuring and Using Database Mail


Importing and Exporting Data Using the Import/Export Wizard
Using Integration Services to Import Data


Security SQL Server Security Architecture
Defining Principals and Securables
Using the Security Hierarchy
Creating Logins and Users
Applying Password Policies to SQL Logins
Creating Roles
Granting Permissions
Using SQLCMD to Test Permissions
Creating and Using Certificates
Setting Execution Context
Encrypting Data
Encrypting Databases


SQL SERVER Architecture SQL Server Database Engine Architecture
High Availability
Four Nines
SLA
High Availability Factors


Mirroring
Endpoints creation
Configuring Mirroring
Mirroring Modes


Log Shipping
Setup the Log Shipping
Disaster Recovery Examples
Troubleshooting
Out of Sync


Replication
What is SQL Replication?
SQL Server Replication Concepts
Types of Replication
SQL Server Roles
Pieces of SQL Replication Model
Players of SQL Replication Model
Creating Replication Admin Account
Creating Agent Accounts
Adding Replication Accounts to Database
Creating Publication
Creating Push Subscription

Who should attend

Freshers/Working Professionals.

Pre-requisites

Basic knowledge in windows OS

What you need to bring

Laptop

Key Takeaways

Manage to work as SQL DBA in production environment.
Handle end user request for S3/s4 level issues.
Reviews

Recommendations & reviews from previous Customers:

Ramsubbu

"Training was wonderful & I get real time exposture from his training. I will recommend him if any one need to learn SQL DBA for better cost in Bangalore. "

attended SQL Server DBA Training


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


Recommendations & reviews from previous Customers:

Ramsubbu

"Training was wonderful & I get real time exposture from his training. I will recommend him if any one need to learn SQL DBA for better cost in Bangalore. "

attended SQL Server DBA Training


Date and Time

Not decided yet.

About the Trainer

Thirunavukkarasu

MCP, MCITP, MCTS, ITIL V3, PMP & BE. CSE


Over 5 Years of experience in SQL Server Administration & SQL DBA Trainer. I worked with various client across the globe
Seats Left-

Students Interested 4

Course Id: 16602