Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Comprehensive SQL Server Administration Part 1
Rating: 4.1 out of 5(36 ratings)
113 students

Comprehensive SQL Server Administration Part 1

Introduction to SQL Server, Authentications, RBAC, Database Maintenance, Disaster Recovery, and High Availability
Created byAdewale Adeniji
Last updated 12/2024
English

What you'll learn

  • Microsoft SQL Server, Versions, Editions, Database Types, Configuration Manager and Management Studio
  • Authentication Types, Role-Based Access Control (Server and Database Roles) and the Principle of Least Privilege
  • Industry Standard Disaster Recovery Strategies Using RPO, RTO and SLA
  • Database Maintenance Tasks (Database Backup, Index Maintenance, Statistics Update and Database Integrity Check)
  • High Availability Solutions such as Log Shipping, Mirroring, AlwaysOn Availability Group and Replication

Explore related topics

Course content

8 sections • 84 lectures • 11h 57m total length

  • What is SQL Server?1:22

    History of Microsoft SQL Server and why companies adopt it.

  • The Evolution (Versions) of SQL Server8:30

    Learn how Microsoft SQL Server has evolved since 2008 and its different versions

  • The Editions of SQL Server6:56

    Learn the different editions available in Microsoft SQL Server

  • The SQL Server Configuration Manager10:02

    Explore the interface of SQL Server Configuration Manager

  • The SQL Server Management Studio2:01

    Explore the interface of SQL Server Management Studio

  • Demo: SQL Server Configuration Manager14:22

    Learn the different configurations that are managed on the SQL Server Configuration Manager

  • Demo: SQL Server Management Studio Part 18:05

    Explore the interface of SQL Server Management Studio and its features via technical hands-on demonstration

  • Demo: SQL Server Management Studio Part 214:53

    Continuation of exploring the interface of SQL Server Management Studio and its features via technical hands-on demonstration

  • SQL Server Databases5:35

    A glimpse into the SQL Server databases

  • Database Types1:50

    Identify the different database types in SQL Server

  • System Databases (Deep Dive)3:36

    Explore system databases in more detail

  • Database Server Environments6:23

    Identify and familiarize with the different database environments used in the real world

  • Demo: Database Types Part 17:05

    Technical hands-on demonstration of the database types on SQL Server Management Studio

  • Demo: Database Types Part 212:13

    Technical hands-on demonstration of the database types on SQL Server Management Studio

  • Demo: Database Types Part 39:59

    Technical hands-on demonstration of the database types on SQL Server Management Studio

  • Knowledge Check: Introduction to SQL Sever

Requirements

  • No Prior Information Technology (I.T) Experience Is Required
  • Windows Personal Computer (Laptop or Desktop)
  • Reliable Internet Connection
  • Great Passion to Learn
  • Existing Virtual Lab Environment for Technical Hands-on Practices

Description

Dive into the world of SQL Server with our comprehensive course designed for existing and prospective Microsoft SQL Server Database Administrators. Whether you're a beginner, junior, or intermediate-level Database Administrator, this course equips you with essential skills and knowledge to excel in the field. You'll gain a solid foundation in SQL Server architecture and functionality, and learn critical topics such as authentications, database maintenance, disaster recovery, and high availability (Log Shipping, Mirroring, AlwaysOn Availability Group, and Replication).

This course is rich in technical hands-on demonstrations to enhance your comprehension of the material, and it includes numerous practice exercises to reinforce your learning. You'll also find a wealth of typical interview questions to help you prepare for job interviews and knowledge checks. Designed to help you break into the IT field or switch roles within the industry, this course ensures you are well-prepared for your career.

This engaging course is perfect for those with a passion for technical hands-on activities and aims to provide a solid foundation in SQL Server administration.

Prerequisite to this course is a virtual lab, with setup videos available in my first course (Comprehensive SQL Server Administration Lab Setup). Trainees with an existing lab can skip the first course and proceed with this course.

Who this course is for:

  • Individuals with Technical Hands-On Abilities (Prospective Microsoft SQL Server Database Administrators)
  • Beginner/Junior Microsoft SQL Server Database Administrators
  • Mid-Level/ Intermediate Microsoft SQL Server Database Administrators

Report abuse