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
Screenshots