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 Microsoft SQL Server Administration workshop

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 Infugena

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

course photo

Microsoft SQL Server Administration workshop

C V Raman Nagar, Bangalore

16,000

No Reviews Yet
1 Interested

About the Course


f you are seriously interested in either starting out on the path to becoming a SQL Server Database Administrator or perhaps wish to make a lateral move from an alternative IT discipline this is the right time,.

Topics Covered

Setting up SQL Server 2012
• Selecting installation options
• Installing a named instance
Leveraging essential tools
• SQL Server Management Studio
• Configuration Manager
• Transact-SQL
• sqlcmd
• PowerShell
• Dedicated Administrator Connection
Constructing and Managing Databases
Inspecting storage structures
• Relating servers, databases and files
• Creating databases and transaction logs
Designing file groups
• Maximizing storage utilization
• Placing tables on file groups
Upgrading and moving databases
• Choosing between upgrade and migration
• Detaching and attaching databases
Controlling database space
• Permitting automatic database growth
• Adding database files to expand databases
Handling Server and Database Security
Implementing server security
• Comparing authentication modes
• Defining logins
• Creating user-defined server roles
• Enforcing password policy
Granting database access
• Contrasting users and logins
• Adding users
• Defining new roles
• Delegating privileges with predefined roles
• Repairing mismapped logins
Granting and Revoking Permissions
Managing database-scoped privileges
• Permitting object creation
• Giving blanket permissions
Defining object-level permissions
• Limiting object access
• Meeting complex permission requirements with roles
Backup and Recovery
Backing up databases
Defining jobs to handle routine tasks
• Creating alerts and operators
• Initiating multi-step jobs
• Associating alerts with jobs
Database Maintenance and Monitoring
Handling fragmentation and database corruption
• Identifying and curing fragmentation
• Repairing database corruption
Building database maintenance plans
• Scheduling plan execution
• Notifying operators of success or failure
Resolving contention problems
• Identifying blocked processes
• Killing blockers

Who should attend

Who wants to get into the evergreen SQL DBA role in his/her career

Pre-requisites

Understand the concepts and knowledge of RDBMS

What you need to bring

Laptop

Key Takeaways

You ill become a SQL DBA. No Dog Pony shows, but only hands On
Reviews
There are no Reviews yet. Be the First to Review
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


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer


Seasoned Hands-On Entrepreneurial, strategic - thinking Software and Systems Executives with a 9 + years record of successfully designing, building and completing innovative business & technology solutions with an acute focus on user experience.

Exemplary leadership, problem solving, team building, communication and project management skills.

Discernment to learn from experience, mentor others along the way and faithfulness to daily plan and execute work. Progressive experience in complex IT technologies and client-relationship management
Seats Left-

Students Interested 1

Course Id: 13961