Save for later

Database Infrastructure Fundamentals

As you continue through the SQL Server Database Administration series, get the foundational information, concepts, and background knowledge that you need to be a successful database administrator. Although your job may not require that you deploy a server or configure TCP/IP settings, you need to understand the basic underlying infrastructure that your database systems are running on. With the increasing move to cloud computing, it becomes even more important, as a database administrator, to know how computer resources, storage, networking, and security are configured and will affect your systems.

Start with an overview of compute resources and how SQL Server works with operating systems. Explore hardware, from CPU to drives, strengths and weaknesses of different types of storage, and memory options. Learn about networking terminology and the various types of networks—peer-to-peer, client-server, LAN, WAN, and more—and find out how they work. Then get important security details. Hear about users, groups, roles—who you are and what you can do. Plus, look at permissions, encryption, and public key cryptography. With these critical insights, demos, and best practices, add key skills and concepts to your database administrator expertise.

Get Details and Enroll Now

OpenCourser is an affiliate partner of edX and may earn a commission when you buy through our links.

Get a Reminder

Send to:
Rating Not enough ratings
Length 4 weeks
Effort 2 - 3 hours per week
Starts Jul 10 (149 weeks ago)
Cost $99
From Microsoft via edX
Instructors Geoff Allix, Cari Mason, Phil Stollery
Download Videos On all desktop and mobile devices
Language English
Subjects Programming Data Science
Tags Computer Science Data Analysis & Statistics

Get a Reminder

Send to:

Similar Courses

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Database Administrator, MySQL $70k

System Administrator / Database Administrator $74k

System Administrator/Database Administrator $76k

Database Administrator 1 2 3 $80k

IT-Database Administrator $101k

Database Administrator / System Administrator $105k

Database administrator and System administrator $119k

Database Administrator/System Administrator $120k

Database Administrator/Database Developer $127k

Senior Database Developer/Database Administrator $144k

Senior Database Developer/Database Administrator $144k

Database Architect and Administrator $186k

Write a review

Your opinion matters. Tell us what you think.

Rating Not enough ratings
Length 4 weeks
Effort 2 - 3 hours per week
Starts Jul 10 (149 weeks ago)
Cost $99
From Microsoft via edX
Instructors Geoff Allix, Cari Mason, Phil Stollery
Download Videos On all desktop and mobile devices
Language English
Subjects Programming Data Science
Tags Computer Science Data Analysis & Statistics

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now