"Microsoft SQL Server Administration workshop" is no longer available

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


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


Understand the concepts and knowledge of RDBMS

What you need to bring


Key Takeaways

You ill become a SQL DBA. No Dog Pony shows, but only hands On


No reviews currently


Post your requirement and let us connect you with best possible matches for MS SQL Administration Training Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more