• Length:
    4 Weeks
  • Effort:
    2–3 hours per week
  • Price:

    FREE
    Add a Verified Certificate for $99 USD

  • Institution
  • Subject:
  • Level:
    Introductory
  • Language:
    English
  • Video Transcript:
    English

About this course

Skip About this course
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.

What you'll learn

Skip What you'll learn
  • How compute resources affect SQL Server
  • What types of storage are available for your database systems
  • How networking affects database connectivity
  • How security is implemented in SQL Server
Module 1: Compute Resources
Module 2: Types of Storage
Module 3: Networking Terminology
Module 4: Security

Meet your instructors

Geoff Allix
Microsoft Certified IT Professional for SQL Server
Content Master
Cari Mason
Content Developer
Microsoft
Phil Stollery
Principal Technologist
Content Master

Pursue a Verified Certificate to highlight the knowledge and skills you gain $99.00

View a PDF of a sample edX certificate
  • Official and Verified

    Receive an instructor-signed certificate with the institution's logo to verify your achievement and increase your job prospects

  • Easily Shareable

    Add the certificate to your CV or resume, or post it directly on LinkedIn

  • Proven Motivator

    Give yourself an additional incentive to complete the course

  • Support our Mission

    EdX, a non-profit, relies on verified certificates to help fund free education for everyone globally