The Ultimate Guide in Becoming a SQL Server DBA

Name: The Ultimate Guide in Becoming a SQL Server DBA
Rating: 4.4 (2308 reviews)

Everything you wanted to know about becoming a SQL Server DBA but were afraid to ask

Created byRaphael Asghar

Last updated 7/2020

English

English [Auto],

What you'll learn

At the end of this course, the student will have most of his/her questions answered as to what it takes to become a SQL DBA and the courses that will help them get a career in SQL Server environment

Course content

2 sections • 9 lectures • 1h 58m total length

Introduction9:28
Explore what it takes to become a SQL Server DBA, setting up a virtual environment, and learning T-SQL while understanding core database administrator responsibilities.

Create a Virtual Machine and install Windows Operating System19:15
Learn to create a self-contained virtual machine with Oracle VirtualBox, allocate memory and storage, install Windows Server 2012, configure the administrator password, and prepare for domain controller setup.
Promote a Windows Server to a Domain Controller11:53
Promote a standalone Windows server to a domain controller by installing Active Directory Domain Services, creating a new forest and domain, and configuring DNS and administrator credentials.
All the software needed to SQL Server 20148:24
Download and install VirtualBox and its extension pack, then prepare the Windows server OS and AdventureWorks 2012 sample database to set up a SQL Server 2014 virtual environment.
How to create and add an IP Address13:41
this lecture shows how to assign a static ip address to a domain controller, including finding the default gateway and setting ip and dns configurations.
Create a second stand alone server part 111:00
Create a second virtual machine as a standalone server, configure network settings and firewall, then join it to the domain to emulate a production SQL Server DBA lab.
Create a second stand alone server part 211:39
Learn to configure a second standalone server and join it to a domain by assigning IP addresses, setting DNS to the domain controller, verifying firewall settings, and restarting services.
Install SQL Server 201414:27
Learn to install sql server 2014 on a Windows 10 host by extracting iso, using the extracted files, setting up a shared folder for the virtual machine, and meeting prerequisites.
Restore a SQL Server database19:02
Attach the Adventure Works 2014 database to the SQL Server 2014 environment, restore it from a backup, and learn t-sql commands like select, where, update, delete, and join.

Requirements

All material such as SQL Server 2014, Windows Operating System 20112 and Virtual Box will be downloaded as free and trial basis. All documentation will be provided. The student needs a desktop or a laptop

Description

The primary purpose of this course is to give the student a sample of what the SQL Server administration is about, what are the requisites courses in becoming a SQL DBA, some guidelines as to what to expect from the job, and get some hands on experience in installing and navigating through SQL Server management studio. The course will provide a summary of courses needed that will enable the student to prepare for the real world IT industry. These courses are SQL Administration part 1, SQL Administration part 2, SQL Administration part 3, SSRS part 1, SSRS part 2, Learn T-SQL and SSIS. Collectively, it's all that a SQL dba needs to secure a job.

Who this course is for:

Anyone who want to know what are the requisites to becoming a SQL DBA, what courses to take, what are the benefits of being an IT industry

The Ultimate Guide in Becoming a SQL Server DBA

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 9min

Ultimate guide in becoming a SQL Server Database Administrator8 lectures • 1hr 49min

Requirements

Description

Who this course is for: