Administering Microsoft SQL Server 2012 Databases New Horizons Computer Learning Center-Abu Dhabi
Price: AED 5,800
  • 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

    Updated on 15 August, 2016

    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 courses
    Are you from New Horizons Computer Learning Center-Abu Dhabi ? Claim your course!
    Courses you can instantly connect with... Do an online course on SQL Server starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or