The Ultimate Guide in Becoming a SQL Server DBA

Everything you wanted to know about becoming a SQL Server DBA but were afraid to ask
Rating: 4.4 out of 5 (1,615 ratings)
53,095 students
The Ultimate Guide in Becoming a SQL Server DBA
Rating: 4.4 out of 5 (1,615 ratings)
53,095 students
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

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
Course content
1 section • 19 lectures • 3h 25m total length
  • Introduction
    09:28
  • All the software needed to SQL Server 2014
    08:24
  • Create a Virtual Machine and install Windows Operating System
    19:15
  • Promote a Windows Server to a Domain Controller
    11:53
  • How to create and add an IP Address
    13:41
  • Create a second stand alone server part 1
    11:00
  • Create a second stand alone server part 2
    11:39
  • Install SQL Server 2014
    14:27
  • Restore a SQL Server database
    19:02
  • Migrate data from source to destination using SQL Server Wizard
    10:21
  • Viewing reports for databases
    08:10
  • Copy paste clip board and completing the introduction course
    09:19
  • POST ADDENDUM
    08:11
  • SQL SERVER 2017 APPS
    07:34
  • CREATE SQL 2017 VM
    18:22
  • INSTALL SQL SERVER 2017
    09:43
  • RESTORE ADVENTUREWORKS2017 DB
    08:13
  • COMPARISON BETWEEN SQL 2014 AND 2017
    02:38
  • BONUS LECTURE: GET GUIDENCE TO BECOMING A SQL DBA
    03:47

Instructor
Production SQL Database Administrator
Raphael Asghar
  • 4.5 Instructor Rating
  • 12,253 Reviews
  • 86,496 Students
  • 21 Courses

Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen.  Want to help those students that want more that the basic SQL Language.  Creating real life courses for those students who want a simple path to becoming a SQL DBA.  I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.