Hudson Courses Limited

      "Microsoft 70-462: Administering SQL Server 2012 Databases "

      Hudson Courses Limited

      zzgl. MwSt.
      Originalpreis in GBP:
      £ 229

      Wichtige informationen

      Tipologie Kurs
      Methodologie Online
      Dauer 12 Months
      Beginn nach Wahl
      • Kurs
      • Online
      • Dauer:
        12 Months
      • Beginn:
        nach Wahl

      "This training course 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 training course on SQL 2012.

      Below is a partial list of job functions associated to this training course:

      Audit SQL Server instances
      Back up databases
      Configure additional SQL Server components, Instances and Services
      Deploying a SQL Server
      Implementing strategies, column stores and High-Availability and Disaster Recovery solutions
      Install SQL Server and related services.
      Management, configuration, permissions, alerts, logins and roles.
      Installation Planning

      Einrichtungen (1)
      Wo und wann
      Beginn Lage
      nach Wahl
      Beginn nach Wahl

      Was lernen Sie in diesem Kurs?

      Database training


      "Syllabus: 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 Dem0 Exam Scenarios Module Review Module 4 Tracing Access to SQL Server Auditing Option 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"