SQL Server DBA

This instructor-led SQL Server DBA course provides students with the knowledge and skills to implement, manage, and maintain a Microsoft Windows Server network infrastructure. The SQL Server DBA course is intended for systems administrator and systems engineer candidates who are responsible for implementing, managing, and maintaining server networking technologies.

These tasks include implementing routing; implementing, managing, and maintaining Dynamic Host Configuration Protocol (DHCP), Domain Name System (DNS), and Windows Internet Name Service (WINS); securing Internet Protocol (IP) traffic with Internet Protocol security (IPSec) and certificates; implementing a network access infrastructure by configuring the connections for remote access clients; and managing and monitoring network access. This is the fourth course in the Systems Administrator and Systems Engineer track for Windows Server 2003, and it is the final course in the Systems Administrator track.

Who Should Attend:

The SQL Server DBA course is intended for individuals who are employed as or seeking employment as a systems administrator or systems engineer.

SQL Server DBA Faqs

Upon completion of this SQL Server DBA course, students will be able to:

  • Allocate IP addressing by using DHCP
  • Manage and monitor DHCP
  • Resolve names
  • Resolve host names by using DNS
  • Manage the integration of Active Directory and DNS
  • Manage and monitor DNS
  • Resolve network basic input/output system (NetBIOS) names by using WINS
  • Secure network traffic by using IPSec and certificates
  • Configure routing by using the Routing and Remote Access service
  • Configure network access
  • Manage and monitor network access

Prerequisites:

Before attending this SQL Server DBA course, students must have completed Implementing a Microsoft Windows Server 2003 Network Infrastructure: Network Hosts, or have equivalent knowledge and skills.

MS SQL Server DBA, Course Outline:

  • Allocating IP Addressing by Using Dynamic Host Configuration Protocol (DHCP)
  • Managing and Monitoring Dynamic Host Configuration Protocol (DHCP)
  • Resolving Names
  • Resolving Host Names by Using Domain Name System (DNS)
  • Integrating Domain Name System and Active Directory
  • Managing and Monitoring Domain Name System (DNS)
  • Resolving NetBIOS Names by Using Windows Internet Name Service (WINS)
  • Configuring Routing by Using Routing and Remote Access
  • Securing Network Traffic by Using IPSec and Certificates
  • Configuring Network Access
  • Managing and Monitoring Network Access

 

 

Testimonials

"The SQL Server DBA training is good thanks for the excellent work." – Soujanya (SQL Server DBA)