Free Training & Career Tips... Subscribe to Get Weekly Career Tips
By Subscribing You are Agreeing to Terms and Conditions
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
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:
Or alternatively click on the button below to view our full Public Course Calendar of close to 100 events:
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