Learn VMware and SQL Server - Step by Step

Discover essential Vmware and SQL Server skills necessary to become a DBA

4.60 (5 reviews)
Udemy
platform
العربية
language
Databases
category
28
students
8.5 hours
content
Aug 2017
last update
$19.99
regular price

What you will learn

Over 8.5 hours of content!

By the end of this course, you will understand VMware and SQL Server concepts

Understand the concepts of Design Storage For New Databases

Create lab of Six virtual machines under domain controller

You will know how to use SSMS to manage your SQL Server

You will know how to perform Backup & Restores Strategies

You will know how to perform basic maintenance indexes

Description

This course will be divided into three sections:

 - The First Section will explain what the Vmware Workstation is and what are the ways to create virtual machines using this platform as well as how to configure the virtual network and how to implement file sharing between host and virtual machines  and finally how to do Snapshot.

- The Second Section of the course you will learn how to create lab of Six virtual machines and how to install the operating system Windows Server 2012 on these virtual machines, also you will learn how to Install Domain and join the virtual machines to the domain.

- The Third Section you will learn about SQL Server 2012 editions and how to install the default and name instance and how to do the testing connectivity between SQL Server instance , also you will learn about RAID technology and how to use them with SQL Server data files, you will get a good knowledge about : Exporting and Importing DataCopying Database to Other Servers , Backup & Restore Strategies , and Indexes.

Once you have completed this course you will be able to do the 70-462 books exercises also will have a good knowledge about VMware and SQL server 2012 as database duties.


Content

Vmware Workstation Install and Configure

Why We Use VMware Workstation
How We Use VMware Workstation
What You’ll Learn in Part -1
Top Features of VMware Workstation
Download VMware Workstation
Hardware Requirements and OS Support
Installing VMware Workstation Step by Step
Ways to Create a New Virtual Machine
Install Windows Server 2012 R2 and VMware Tools on VM
Virtual Network Configuration
File Sharing Requirements
Explain Virtual Machine Library,Status bar
How to do Snapshot

Setting Up The Lab - 6 Virtual Machines

Instructions For Setting Up The Lab
Prepare and Install Domian Controller part - 1
Prepare and Install Domain Controller part - 2
Prepare and Install Domain Controller part - 3
Add Active Directory User
Reverse Lookup Zone
Prepare a Member Server Sql- A and Join It to the Domain
Prepare V-Computer SQL-B with customs advanced
Prepare V-Computer SQL-c and SQL-D with Clone
Join SQl-B , SQL-C and Sql-D to the Domain Controller
Prepare V-Computer as SQL-Core , install windows core , Join DC

SQL Server 2012

Evaluation Installation Requirements
Designing The Installation of SQL Server and its components
SQL Server Editions & Scale up and Scale out
Configure Firewall Rules
Configuring an Operating System Disk
Installing the SQL Server Database Default Instance
How to Add features to SQL SERVER and Installing the SQL Server Database Nam
Installing SQL Server from Command Prompt
Installing SQL Server By using Configuration File
Testing Connectivity
Instance-Level Settings Overview
Design Storage For New Databases
Configuring and Managing Databases
Migrating Database to SQL Server 2012 Instance
Copying Database to Other Servers
Exporting and Importing Data
Backup Strategy part - 1
Backup Strategy part - 2
Backup Strategy part - 3
Restore Strategy part - 1
Restore Strategy part - 2
Indexes Overview part 1
Indexes Overview part 2

Screenshots

Learn VMware and SQL Server - Step by Step - Screenshot_01Learn VMware and SQL Server - Step by Step - Screenshot_02Learn VMware and SQL Server - Step by Step - Screenshot_03Learn VMware and SQL Server - Step by Step - Screenshot_04

Charts

Price

Learn VMware and SQL Server - Step by Step - Price chart

Rating

Learn VMware and SQL Server - Step by Step - Ratings chart

Enrollment distribution

Learn VMware and SQL Server - Step by Step - Distribution chart
722326
udemy ID
1/10/2016
course created date
5/30/2021
course indexed date
Bot
course submited by