How To Land Your 1St Microsoft Sql Server Role

SQL Server Database Administration

What you'll learn

Audience will learn how to build a virtual machine from scratch

How to configure Domain Controller and Active Directory

Able to perform basic junior windows system Administrator tasks.

Recommended practice time - 2 hours daily

Requirements

Windows computer or laptop with minimum 12 GB Memory

Description

The best way to break into tech or learn Microsoft SQL server is through practice.In this course, the audience will learn how to install SQL Server from scratch as well as basic windows system administrator functions using a hands-on step by step approach.Data is the currency the world uses, and this course would teach the audience how to set up a home lab on Windows Server 2016, Install SQL Server then practice. In this course, we would begin by installing Vmware workstation Pro, configuring Active Directory, promoting a server to a domain controller, creating a domain joining our 2 servers to the domain. The intended audience for this course must have a basic understanding of navigating computer and not be scared to ask questions about the topics covered in this course. We are on Udemy for the first time thus we would need all feedback so that we could provide better learning experience to our students to help you get your first tech job or break into the SQL Server DBA field.We wish you a happy learning experience and if you do have any questions, concerns or comments, always feel free to reach out to us . Thanks

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Installing SQL Server 2012 Step by Step

Lecture 3 Types of Backup in SQL Server

Lecture 4 SQL Server Security- logins and Users

Lecture 5 SQL Server Performance Tuning

Anyone seeking to break into tech and understanding Active directory or Windows Servers