Microsoft SQL Server 2012 Training Course

Introduction: Microsoft SQL Server 2012 Training Course

Over a course of 3 days, delegates will acquire knowledge and skills to manage a Microsoft SQL Server database. The focus of the course is on showing delegates how to use features and tools of SQL Server products, when maintaining a database.
Upon completion of the course, delegates will be able to: describe, explain and understand SQL Server structures, databases, and implementations; create server backups and restore SQL databases; work with configuration of data collection and DVMs; Employ SQL Server proxy accounts, credentials and agent security.

Microsoft SQL Server 2012 Training Course

Microsoft SQL Server 2012 Training Course

Outline: Microsoft SQL Server 2012 Training Course

Johannesburg (Sandton), Cape Town, Durban, Port Elizabeth, Pretoria – South Africa

Key outcomes of the course include:

• Introduction of SQL Toolset and Server 2012
• File groups and files
• Database work
• Restoration of SQL Server 2012
• Installation and configuration of SQL Server 2012
• Import and Export of Data
11. Authorizing Users to Access Resources
This module covers permissions and the assignment of permissions.
Lessons:
Authorizing User Access to Objects
Authorizing Users to Execute Code
Configuring Permissions at the Schema Level

12. Auditing SQL Server Environments
This module covers SQL Server Audit.
Lessons:
Options for Auditing Data Access in SQL
Implementing SQL Server Audit
Managing SQL Server Audit

13. Automating SQL Server 2012 Management
This module covers SQL Server Agent, jobs and job history.
Lessons:
Automating SQL Server Management
Working with SQL Server Agent
Managing SQL Server Agent Jobs

14. Configuring Security for SQL Server Agent
This module covers SQL Server agent security, proxy accounts and credentials.
Lessons:
Understanding SQL Server Agent Security
Configuring Credentials
Configuring Proxy Accounts

15. Monitoring SQL Server 2012 with Alerts and Notifications
This module covers the configuration of database mail, alerts and notifications.
Lessons:
Configuration of Database Mail
Monitoring SQL Server Errors
Configuring Operators, Alerts and Notifications

16. Performing Ongoing Database Maintenance
This module covers database maintenance plans.
Lessons:
Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance

17. Tracing Access to SQL Server 2012
This module covers SQL Profiler and SQL Trace stored procedures.
Lessons:
Capturing Activity using SQL Server Profiler
Improving Performance with the Database Engine Tuning Advisor
Working with Tracing Options

18. Monitoring SQL Server 2012
This module introduces DMVs and the configuration of data collection.
Lessons:
Monitoring Activity
Capturing and Managing Performance Data
Analyzing Collected Performance Data

19. Managing Multiple Servers
This module covers Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.
Lessons:
Working with Multiple Servers
Virtualizing SQL Server
Deploying and Upgrading Data-Tier Applications

20. Troubleshooting Common SQL Server 2012 Administrative Issues
This module covers common issues that require troubleshooting and gives guidance on where to start looking for solutions.
Lessons:
SQL Server Troubleshooting Methodology
Resolving Service-related Issues
Resolving Concurrency Issues
Resolving Login and Connectivity Issues
 

 

Course duration and fees: Microsoft SQL Server 2012 Training Course

Our two day training course is designed so that the knowledge acquired is applied practically, so that the business environment can be enhanced.

Please consult schedule for course costs or contact BOTI for a quote.

 

Recommended Prior Experience and Knowledge: Microsoft SQL Server 2012 Training Course

The course (Microsoft SQL Server 2012 Training Course) is designed for the following attendees:

The course is aimed at individuals who maintain and administer SQL Server databases, as well as individuals who develop applications that deliver content from SQL Server databases.
 

For the Microsoft SQL Server 2012 Training Course it is advisable that you have the following experience/knowledge:
Experience with database design; Working knowledge of Transact-SQL and relational databases; basic knowledge of the MS operating system and functionality.
 

 

Book or Obtain Instant Quote

In addition to the related public courses, we offer the above course across the country: Anytime, Anywhere. Click on the link to get an instant proposal or book your course NOW:

Book or Obtain Instant Quote

Or alternatively click on the button below to view our full Public Course Calendar of close to 100 events:

2018 Public Course Calendar

 

Please Phone Us Now To Speak to One of Our Friendly Consultants

Tel:011-882-8853

OR

FOR CELL PHONES CLICK TO CALL

Please Fill in the Form – We Will Get Back to You Within 15 minutes

Please Email Us Now  – We Will Get Back to You Within 15 minutes

 [email protected]

Course Enquiry

    Knowing your course will help us prepare for our consultation and phone call.

    The more people you send on our courses, the cheaper the unit cost.


    YesNo

    Input this code: captcha

    Accredited Courses

    Additional Courses

      Software & IT Courses

      Top Rated