Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Microsoft SQL Server Administration workshop

No Reviews Yet

C V Raman Nagar, Bangalore

Course ID: 13961

C V Raman Nagar, Bangalore

Loki, Vignesh, SelvaRaj
No Reviews Yet

Date and Time

Not decided yet.

Loki, Vignesh, SelvaRaj

MCA

About Loki, Vignesh, SelvaRaj

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
No reviews currently

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

No reviews currently

Discussions

Post your requirement and let us connect you with best possible matches for MS SQL Administration Training Post your requirement now
₹ 16,000 Enquire