- Duration: 5 Days
- Timings: 8:00 AM - 4:00 PM
Course details
Course Overview
Students will gain 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.
Who is this course for?
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
Course Outline
Lesson 1: Introduction to SQL Server 2012 and its Toolset
Lesson 2: Preparing Systems for SQL Server 2012
Lesson 3: Installing and Configuring SQL Server 2012
Lesson 4: Working with Databases
Lesson 5: Understanding SQL Server 2012 Recovery Models
Lesson 6: Backup of SQL Server 2012 Databases
Lesson 7: Restoring SQL Server 2012 Databases
Lesson 8: Importing and Exporting Data
Lesson 9: Authenticating and Authorizing Users
Lesson 10: Assigning Server and Database Roles
Lesson 11: Authorizing Users to Access Resources
Lesson 12: Auditing SQL Server Environments
Lesson 13: Automating SQL Server 2012 Management
Lesson 14: Configuring Security for SQL Server Agent
Lesson 15: Monitoring SQL Server 2012 with Alerts and Notifications
Lesson 16: Performing Ongoing Database Maintenance
Lesson 17: Tracing Access to SQL Server 2012
Lesson 18: Monitoring SQL Server 2012
Lesson 19: Managing Multiple Servers
Lesson 20: Troubleshooting Common SQL Server 2012 Administrative Issues
Course Location
About New Horizons Computer Learning Center-Abu Dhabi
As changes in technology have accelerated, it’s become even more essential for people to master technology to be productive, invaluable employees who optimize, program and invent solutions—and even grow companies of their own. For 30 years, New Horizons has provided more than 30 million students with industry-leading technical training that delivers the most relevant and intuitive computer courses and certifications. We’re now the world’s largest independent IT training company, and we continue to lead:
- 300 computer training centers in 70 countries (and counting)
- Largest Guaranteed-to-Run course schedule in the world
- Ranked in the top 5% of the industry for training quality and customer satisfaction
- Official training partner for technology leaders such as Microsoft, Cisco, CompTIA and VMware
- Microsoft’s largest training provider, delivering more than 40% of all authorized Microsoft training worldwide
- World’s largest Cisco-authorized training partner
New Horizons is an authorized partner to the top technology providers. For students that means training with the highest quality source materials and the latest products and technologies. For businesses it means getting the highest return on their training investment.
Invest in courses and certifications that advance careers:
The largest Guaranteed-to-Run course schedule in the world includes an extensive array of vendor-authorized IT training and all the in-demand Microsoft, Cisco, CompTIA and VMware certifications.
Learn in your own way:
All of New Horizons’ award-winning learning methods deliver the same comprehensive content—in online and traditional classroom settings, at your worksite, and self-paced with one-on-one support.
Continuously upgrade the people who drive your business:
We’ll create innovative training solutions that work for your business and we’ll account for the results—whether your company is small, mid-sized or a global enterprise. New Horizons training yields a 4:1 benefit-to-cost ratio, based on manager surveys of the improved performance and productivity immediately following our training.
See all New Horizons Computer Learning Center-Abu Dhabi coursesSQL Server Related Questions
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- MCSA Windows Server 2016 (70-740) Lead AcademyAED 95
AED 1,432Duration: Upto 6 Hours - Developing Microsoft SQL Server 2012 Databases Global EdulinkAED 375
AED 2,596Duration: Upto 19 Hours