Course details
This instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.
COURSE OUTLINE
- Introduction to SQL Server 2012 and its Toolset
- Preparing Systems for SQL Server 2012
- Installing and Configuring SQL Server 2012
- Working with Databases
- Understanding SQL Server 2012 Recovery Models
- Backup of SQL Server 2012 Databases
- Restoring SQL Server 2012 Databases
- Importing and Exporting Data
- Authenticating and Authorizing Users
- Assigning Server and Database Roles
- Authorizing Users to Access Resources
- Auditing SQL Server Environments
- Automating SQL Server 2012 Management
- Configuring Security for SQL Server Agent
- Monitoring SQL Server 2012 with Alerts and Notifications
- Performing Ongoing Database Maintenance
- Tracing Access to SQL Server 2012
- Monitoring SQL Server 2012
- Managing Multiple Servers
- Troubleshooting Common SQL Server 2012 Administrative Issues
Course Location
About COMAT Training Services Pte Ltd
To be or not to be; this is the question which resides in us. All man of clay, our innate differences are subtle and few. The void spanning greatness hinges on existence of mean and will. COMAT holds an intrinsic belief that every inpidual has a potential to be realised. Betterment of society through advancement of its basic unit, empowerment through continuous learning – Upon these axioms were we founded, and today proudly uphold.
Love for the people around us, a desire for a better world, our passion is our profession. COMAT believes learning is a lifelong process and key to a meaningful existence. Spearheaded by a renowned team of highly experienced and motivated trainers, COMAT offers an extensive array of IT, safety and leadership & professional development courses, providing inpiduals with the means to excel.
While adhering to globally accepted quality standards, our intention goes beyond training and certification - COMAT provides a holistic experience, focusing on generation of inductive environments for stimulating philosophical thoughts. True learning lies in instillation of a sense of self-realisation, a will to become who they can be.
We pride ourselves on our innovations, our desire for continuous improvement, and the ability to perceive the needs and wants of each inpidual. Customized approaches for varying needs, we conjure solutions tailored to fit.
See all COMAT Training Services Pte Ltd courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Mastering SQL Programming StudyHubSGD 33Duration: Upto 11 Hours
- Administering a SQL Database Infrastructure Global EdulinkSGD 135
SGD 960Duration: Upto 22 Hours