Administering SQL Server 2012 Databases Course
Administering SQL Server 2012 Databases Online Courses
2KO Zambia offers online Administering SQL 2012 courses in Zambia. We also offer full time SQL 2012 database courses in Lusaka for groups of four or more delegates. 2KO Zambia's SQL database course is offered to our international and local students. 2KO International delivers consulting services, in the IT and Business space, as well as being a training provider for IT certification and user level courses. Training can be any combination of bespoke, classroom and online learning, to ensure students have access to the best Administering SQL 2012 certification training in Zambia.
2KO Zambia's SQL 2012 course in Zambia was created specifically for those individuals (Database Professionals) who install, maintain and configure as their primary job function. Any participants setting up database systems and/or responsible for efficient system operation, regular database back ups stored effectively, and securing data from unauthorized access is also a candidate for this 2KO Zambia training course on SQL 2012.
Below is a partial list of
job functions associated to this 2KO Africa training course:
Audit SQL Server instances
Back up databases
Configure additional SQL Server components, Instances and Services
Deploying a SQL Server
Implementing strategies, columnstores and High-Availability and Disaster Recovery solutions
Importing/exporting
Install SQL Server and related services.
Maintenance
Management, configuration, permissions, alerts, logins and roles.
Optimization
Installation Planning
Restoring
Troubleshooting
The 2KO Africa SQL 2012 Administering
Databases course prepares students for Microsoft Exam 70-462
As the participant in the 2KO Africa SQL 2012 Administering course will learn:
Installation Planning
Installing SQL Server and related services
Implementation of a migration strategy
How to configure additional SQL Server components
Managing the SQL Server Agent
Database management and configuration
How to configure SQL Server instances
Implementing a SQL Server clustered instance
SQL Server instances management
How to properly Identify and resolve concurrency problems
The collection of and how to analyze troubleshooting data
Auditing SQL Server instances
Configure and maintain a back up strategy
Database restoration
Implementing and maintaining indexes
Importing and exporting data
Managing logins and server roles
Managing database permissions
Managing users and database roles
Troubleshooting security
Implementing AlwaysOn, database mirroring and replication
Microsoft 70-462: Administering SQL Server 2012 Databases
Module 1
Introduction to SQL Server 2012
SQL Server
SQL Server Tools
Management Studio Demo
Data Tools
Exam Scenarios
Module Review
Module 2
Installing SQL Server
SQL Architecture
Hardware Requirements
Software Requirements
Installation Process
Troubleshooting Installation
Upgrading and Unattended Installations
Configuration Demo
Exam Scenarios
Module Review
Module 3
Backup and Restore a Database
Database Architecture
Database Backup
Restoration Process
Restoring System Database
Backup and Recovery Demo
Exam Scenarios
Module Review
Module 4
Tracing Access to SQL Server
Auditing Options
Introduction to SQL Audit
Audit Objects and Implementation
Extended Events
Tracing Activity Demo
Exam Scenarios
Module Review
Module 5
Importing and Exporting Data
Introduction to Data Transfer
ETL Tools
Improving Data Transfer
Copying Database Methods
Transferring Data Demo
Exam Scenarios
Module Review
Module 6
SQL Server Security
Security and Authentication
Server and Database Roles
Permissions
Securing SQL Server Demo
Exam Scenarios
Module Review
Module 7
Automating SQL Server
SQL Server Agent
Database Mail
Operators, Alerts and Jobs
Database Configuration Demo
Exam Scenarios
Module Review
Module 8
Monitoring SQL Server
Dynamic Management Views and Functions
Profiler Trace
Database Tuning Advisor
Activity and Performance Monitor
Data Collection
Monitoring Demo
Exam Scenarios
Module Review
Module 9
Maintaining SQL Server
Checking Database Integrity
Indexing
Ongoing Maintenance
Managing and Maintaining Demo
Exam Scenarios
Module Review
Module 10
Troubleshooting SQL Server
Service Issues
Connectivity Issues
Locking Issues
Troubleshooting Demo
Exam Scenarios
Module Review
Program Review