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,578 ratings)
52,306 students
The Ultimate Guide in Becoming a SQL Server DBA
Rating: 4.4 out of 5 (1,578 ratings)
52,306 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
Curriculum
1 section • 19 lectures • 3h 25m total length
  • Introduction
  • All the software needed to SQL Server 2014
  • Create a Virtual Machine and install Windows Operating System
  • Promote a Windows Server to a Domain Controller
  • How to create and add an IP Address
  • Create a second stand alone server part 1
  • Create a second stand alone server part 2
  • Install SQL Server 2014
  • Restore a SQL Server database
  • Migrate data from source to destination using SQL Server Wizard
  • Viewing reports for databases
  • Copy paste clip board and completing the introduction course
  • POST ADDENDUM
  • SQL SERVER 2017 APPS
  • CREATE SQL 2017 VM
  • INSTALL SQL SERVER 2017
  • RESTORE ADVENTUREWORKS2017 DB
  • COMPARISON BETWEEN SQL 2014 AND 2017
  • BONUS LECTURE: GET GUIDENCE TO BECOMING A SQL DBA

Instructor
Production SQL Database Administrator
Raphael Asghar
  • 4.4 Instructor Rating
  • 11,791 Reviews
  • 84,837 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.